Recent content by sambo

Right on Mile! Here's a reference for future viewers. This basically amounts to a souped-up inputbox. 'clear tags Me.FRNT_Serial.Tag = "" Me.FRNT_Part.Tag = "" 'open and wait DoCmd.OpenForm "NEW_CASE", , , , , acDialog If Me.FRNT_Serial.Tag = "" Or Me.FRNT_Part.Tag...

Tricky tricky tricky... I shall try.

I removed my calculation from the ControlSource and all was right with the world again.

So you're telling me that I can't pass a pointer as an OpenArg to a form??? So basically I am forced to use a global variable to share between the two? Please clarify if I am misreading your post. If I read it correctly, then that certainly is shocking that there is no sure fire way to share...

I would like to popup a form after a button is clicked. I would like the button click event code to wait until the modal form is closed before continuing. The code will be reliant on the values returned from the modal form. This is a simple task in c++, but I can't seem to find a way to do it in...

Just found this . I should have known!

I'm experiencing this same issue. It happens when I change records on my form. The status bar reads "Calculating..." and the conditions do not take affect until I mouse-over any of the BOUND fields on my form. Very strange. Anyone know why?

A word of caution.. The code in your vb module will continue to execute regardless of whether or not the batch file has completed. You can combat this problem by putting a "copy /y" statement at the end of your batch file. Now in your vb code module, use a while...wend loop to continually check...

Some of my users have MS Office Service Pack 10.0, others have Service Pack 9.0. I developed a DB using SP 9.0, it does not work for those users who have SP 10.0. They are forced to manually go into the Tools->References Menu and change the MISSING libraries from 10.0 over to 9.0. Is there a...

If you want the appearance of a hyperlink, then change the Text Color to blue. On Mouse Over change to Dark Blue or something similar. I'm sure there is a way to change the mouse pointer to a hand also if you really wanted to get technical. Here is a link on how to use a control as a...

I run the batch file directly from the Shared Network and I don't get the File Download Dialog. My users click from their Desktop, however, not from an HTML page. This is probably an Internet Browser setting more than it is a DOS Window setting. Do your users have to confirm that they are about...

I understand where you are coming from, but it is just so much easier to have the users double-click the .bat Icon and away they go. I'll probably just end up having a batch file call an intermediate db (or maybe just a vb app) that opens the working db.

FYI.. :end is not a "statement" it is a "tag". It is used only for "goto end" statements (of which I have none). Actually, the "quit" statement should be ambiguous in this instance as well, but I just put it in there for giggles. The real problem is that the batch file never gets past the...

The batch file does much more than simply opening the .mdb. It also checks the network for new support documentation or new Front End Version. I'll attatch a .txt version of the batch file. Please advise..

I implement the exact same Access.exe call as is suggested on the previously mentioned site, but my DOS window still hangs. It looks like the command window is just waiting for the MsAccess.exe line to finish running, but because the user is using the access app, the batch file doesn't go to...