Search results

Thank you very much for your help

Hi, I am trying to repair the database when this message pops up that another user is using the database. However, the user is myself. How can I unlock it or clear up the situation ? I have tried to make a copy and rename it. Even though it allows me to do it, yet every time when I open this...

I think I got your idea: 1. hard code a drive (current) in the module 2. when the drive mapping has changed by the user, prompt user to enter a new drive 3. the module will then use the new drive What I am thinking is : Is there a function that can search for the drive and then I can append...

I think an example can illustrate this. 1. A excel spreadsheet is located in x:\ drive 2. In the database the vba is hard coded x:\nnn\nnn.xls When the user click on the button (front-end) it will run the event procedure. The function is to access the xls in x:\ to do processing. However...

Hi, I am trying to eliminate all the hardcoding of the drive so that I don't have to change the database every time the user change a drive. How should I code this ? Please help. Thanks!