Search results for query: *

I have had this API function working for months without any problems. After XP SP2, the error it returns is 5. Anyone knows what fHandleFile / ShellExecute error 5 means? Thanks. shar

Greg Tammi, Thanks for your response. The Track Name AutoCorrect is not checked in my db. I do have a front-end back-end setting. I cannot set the Subdatasheet Name property on the back-end tables because the back-end is being used by Access 97 and XP users at the same time, I have to keep...

I have converted an Access application from 97 to XP. The problem is the XP version which keeps on growing in size, much faster than the 97 version does. I know db file growth is a typical Access behavior. I tried compacting it, but it did not reduce the size much. I tried the decompile...

Mikeauz, Tried CurDir too. Seems like it gives the "Default Database Directory" setting. In my case, I set this value when users start the db. And when they have moved the db, the setting still points to where it was set in the code. Looks like Access 97 has this short coming...

Mikeauz, Thanks for the reply, but it doesn't work in 97 :(

When I use the Currentdb.name, I get the 8.3 naming system, i.e.: C:\PROGRA~1\Projects.mdb. How can I get the long file name such as: C:\Program Files\Projects.mdb? I am using Access 97. Thanks. Shar

Hypetia, Thank you very much. The vbs code works like a charm. You earned your star. PS: The MS Access version I tried the code on was 97.

Hypetia I tried first set of code in a vbs file and get an error: Line 3, object doesn't support this property. In an Access module, the error says "version" method or property is not supported. Thanks. shar

Thanks to LPlates & strongm replies. LPlates, I am not using a form, just a plain vbs file for users to double click to run. strongm, How do you "wrap the API calls in a VB class, and then use the class from VBScript"? Here is the detail of how and why I want to use this: My...

Is there a way to declare api functions in a vbs file. I have been declaring api function such as: Declare Function RegOpenKeyEx Lib "advapi32.dll" Alias "RegOpenKeyExA" (ByVal hkey As Long, ByVal sSubkey As String, ByVal lOptions As Long, ByVal lSAMDesired As Long, hResult...

Thanks for the response Ben. After a few hours of working on it, I did find out that what you mentioned was the problem, i.e. trying to copy the file onto itself. I appreciate you taking the time to look into it and pointing out the problem. Here is a star for you. Thanks. shar

Thanks tsuji. I am a novice at VBSript and new to this forum. I appreciate the help. Here is a star for you. Thanks again. shar

D'oh. Thanks. Here is another question: Is there any way to pass a string to the vbs file? In other words, can I pass the value of lpath to this script from where I am calling it?

Please help. Here is a very simple 4 lines vbs code: Dim lPath lPath = "D:\cpj.mdb" Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run strLocalPath Why when I double click the vbs file it wouldn't start cpj.mdb in MS Access? It doesn't do anything. I tried...

Thank you for your responses. I tried the Windows Script debugger, but it seems that it is for html and java codes. Well, here is the code I am having trouble with. It is a VB script called from MS Access to update the front end of an Access application. I got it from FAQ of Tek-Tips' Access...

I am new to this, so please bear with me. How do you step through a vbs script? I know you save the commands in a text file with vbs extension and double click on it to run it. I have done that, but something in my script does not work. How can I step through the code one line at a time to...

Thank you scking. Your code helped me to get what I needed to do. Sorry for the delay in response.

I use access 97 to export data into an Excel file. I have written code in MS Project to import the data from the Excel file and perform modifications and formatting. In Acc97, my code exports the data to an Excel file and start MS Project, but I cannot run the codes in MS Project. I tried the...

I use access 97 to export data into an Excel file. I have written code in MS Project to import the data from the Excel file and perform modifications and formatting. In Acc97, I can export the data to the Excel file and start MS Project, but I cannot run the codes in MS Project. The SendKeys...

Some of the reports in my application (Access 97) are on legal size paper. As a work around for the problem of Access reverting back to its default page setup, I have the page setup icon on the report menu bar so users can change the paper to legal before sending the report to the printer. By...