Thanks again.
This worked excellently, as well as:
'Application.SetOption "Default Database Directory", CurrentProject.Path
Both worked great.
Thank you for your help!
Sue
Hi PHV.
Thanks, this does help.
It returns this:
C:\Documents and Settings\SNess\My Documents
C:\ThisFolder\MyDBFile.mdb
C:\ThisFolder
The CurrentProject.Path is what I need, but I need to be able to return it through the VBScript part of the code, which that DOES, except when you run it via...
Sorry. Try this one. This is the first time I have used this box.net service. Thanks for letting me know you couldn't get in.
Suehttp://www.box.net/shared/xv6l2he04m
OK. Here you go. 3 files.
The MS Access DB, the vbs file and the exe file. Scriptcryptor was used to convert the .vbs to the .exe. They both are the same code.
Take these three files and put them in any drive (not my documents), for Example c:\Fred or any place. Run the .vbs, it should...
This is a VBA/VBScript combo type issue. I have written a vbScript that uses GetAbsolutePathName and it works great. I use ScriptCriptor program to compile it into an .exe file and the .exe file also works great. Then when I use the Shell command to run the script in MS Access Form VBA code...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.