Search results

This is beyond amazing! thanks!!

Yes I have observed this when using it with Excel, I attribute it to the server delay here at the VA Medical Center... We have a lot of security hoops and the servers are all remote

WOWZA!!! That's amazing! But i didn't see anything about It opens the MsgBox and leaves it sitting on the screen until you click OK

Regretfully, it doesn't seem to

I often use a timed MsgBox to advise user of events that happen during code execution and always to let them know who wrote the Database or Excel App with a contact email and phone extension. The most common vba code I use is CreateObject("WScript.Shell").Popup vMsg, vSec, vTitle...

That is a good thought! What I do now, is I have added code to verify the L:\ drive is connected, if not, as you noted, I map it. I am adding that to each of my Databases and Automated Spreadsheets so if a person uses any of the daily tools, they will always be remapped automatically. Great...

Wow... you learn something new every day!! Thanks so much!!!

Thanks for everyone's help! Problem Solved!!

Thanks for this information and the coding. I actually have two forms, the data entry form and then the log book form. The data entry form does exactly what you say, it allows me to look up an individual record and/or add and delete records. But we also need to see the whole log book and then...

Thanks for everyone's help! The key was telling the drives to reconnect at login. That works great. There doesn't seem to be a way to overcome the organizations reset of drives.

When our organization runs MS updates, they have a script that disconnects all mapped drives except P: and U:. Not sure why they do this, but they do, so I wrote a VBA script in an Excel Workbook that users can run. It hides excel, pops up a menu and offers them a chance to map any of 5 drives.

Maybe I should approach, showing this from another VBA perspective? Could I change the open form options and use a Filter and then turn that filter on or off?

Didn't work :(

Didn't Work :(

Didn't work... :(

I have a form and when I open it, I set the value of my lookup field to a value that intentionally has no records to force the user to click the ComboBox and choose their Department. The line of code being used to accomplish this is: DoCmd.SearchForRecord , "", acFirst, "[tDeptAbbrv] = " &...

Exactly... but how do I use VBA to tell the "Reconnect at Sign-in" box to be checked?

I have an Excel Macro that Maps several drives automatically. However, every time the computer reboots, they disappear. I noted that a manual mapping of the drives there is a box to select to "Reconnect at Signin" Is there a VBA command that allows us to select that option?

Hurray!! This worked with the removal of one "," to get the Where Clause back to the correct place in the equation! Thanks so much!! Here is what worked. DoCmd.OpenReport "rPolicyComplete", acViewReport, , "[tPlcydpt]='" & tPlcydpt & "'"