Search results

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...

Are you talking about a carraige return/line feed in a string? If so, then you want the vbCrLf constant.. MsgBox("This is a test..." & vbCrLf & "Press OK To Continue")

I open my database via batch file, but the batch file hangs at the final line (as if it is waiting for the MsAccess.exe line to complete) It never makes it to the "quit" line, so the batch file continues to run infinitely (or until I shut it down manually) Here are the final few lines of the...

Just so you know.. TopPic should be replace by the name of your image container. TopPic just happens to be the name I was using on my form. Same with txtMyHyperLink

Thanks for all the help... I like the idea of firing in an autoexec macro everytime the db is opened. Glad to see I wasn't the only one losing sleep over this. Here is my take

I've got to add my take... This is just too cool. Here is an easy way to re-link all of your "linked" tables. This will also work if you are rolling a product out and you aren't sure what Server(s) it will eventually end up on. All the Host Company will need to do is enter the "Back End"...