Replies

I’m not sure if this last reply is covering me or not.

The intention of my form is to add items to my junction table, and to the underlying tables if need be.

Would it really be appropriate to do this through a query?

Or is the suggestion to use a query just a way to populate my combo boxes that are already updating the table?

I’m not sure if this last reply is covering me or not.

The intention of my form is to add items to my junction table, and to the underlying tables if need be.

Would it really be appropriate to do this through a query?

Or is the suggestion to use a query just a way to populate my combo boxes that are already updating the table?

This is a great help, but I’m still not that good with VBA.

I understand what is going on in the post from MS. But what I want to do is populate the combo box with names from a table other than my junction table (the junction table just contains ID numbers from different tables, while the table with the names has an ID number and the name in text). The MS example populates the second combo box with names that are in the junction table.

So, I’m missing a bit of VBA to make a compound statement.

This is a great help, but I’m still not that good with VBA.

I understand what is going on in the post from MS. But what I want to do is populate the combo box with names from a table other than my junction table (the junction table just contains ID numbers from different tables, while the table with the names has an ID number and the name in text). The MS example populates the second combo box with names that are in the junction table.

So, I’m missing a bit of VBA to make a compound statement.

Thanks to both of you.

I have been trying to use the *.reg suggestion from Hans, and am having problems. When I run that file I first get a message to confirm that I really want to update my registry. It would be nice if I could suppress this. More importantly, after clicking yes, I get red error box from Windows that it only accepts binary registry files. Any suggestions?

As to the VBScript solution, it is good to know that there is supposed to be an annoying delay in there.

For future readers, you can also do this with a VBScript that opens Explorer and submits keystrokes to change those options – but it is much more cumbersome than either of these solutions. On the bright side, it doesn’t affect your registry directly.

P.S. Hans … I was one of those people that got caught by that *.txt.vbs virus about 3 years ago. To make matters worse, I was using Eudora which shows file extensions on attachments automatically, and I was still dumb enough to open it. So … showing file extensions wasn’t a real solution anyway.

Hans answer to my Toggle File Extensions post answered this one too.

In answer to the question … I’m so tied up in a Windows environment that I can use their little icons for most file type identifications. But, I do manage a website too, and so knowing the exact extension is critical sometimes.

I do have one question in response. I’ve never written a *.reg file from scratch, and I’m curious if I can put a statement in there to open Explorer? Or … should I write a batch file that run both the *.reg file and opens Explorer?

I’m ready to close this thread down. I think the problem is with other software not Windows.

After checking on Hans suggestion, I realized that I do have Power Rename from Creative Elements Power Tools (rather than the company that Hans suggested). I e-mailed them, and they have seen a similar problem in Windows Me, so I guess I’ll just wait for a bug fix.

In response to both replies (so far):
1) No, I haven’t downloaded that file off the internet. Interestingly though, I do have Power Rename from Creative Element Power Tools (O’Reilly) installed on my machine.
2) This is by design! Are you sure? I may be mistaken, but I seem to remember doing this all the time successfully. Is this something that was changed with XP?

That works. I thought this would be easier than paying for software … but that’s OK. I recommend the software to anyone with this problem.

This problem has been solved through another forum. The answer is to include the appropriate command line arguments in the shortcut to both unpack the jar, and run the enclosed executible with the submitted program:

“C:My Program FilesJavaj2re1.4.1_02binjavaw.exe” -jar “C:My Program FilesArachnophiliaArachnophilia.jar” “%1” %*

I actually have a Java application (an editor called Arachophilia) that is packaged in a JAR file. A shortcut to the JAR will open, but with no documents. I do have my associations set up so that I can double-click on a file, and it will unpack the JAR, run the executible, and open the file I want to edit. It would be a lot more convenient to be able to drag and drop.

That doesn’t seem to solve the problem. In some sense, I guess I want to put a field in one cell that looks at a source cell. When the source changes, the field referencing it changes as well.

The VBA suggestion worked fine for copying and pasting – but it didn’t update automatically when the source cell was updated.

I like the nested fields. Is there any way that I can make it append that to an existing title?

Going on your conjecture that Office is looking for help files on the network, I presume there is a setting somewhere in Office to tell it where the help files are. It doesn’t seem to be in the “file locations” tab under options.