Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: shar
  • Order by date
  1. shar

    fHandleFile / ShellExecute

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

    db file growing and compacting doesn't fix it

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

    db file growing and compacting doesn't fix it

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

    How do you get the long file name path to a db

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

    How do you get the long file name path to a db

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

    How do you get the long file name path to a db

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

    How do you declare api function in vbs?

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

    How do you declare api function in vbs?

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

    How do you declare api function in vbs?

    ...Here is the MS Access module that accomplished this objective: (This code was put together from various FAQ & posts in the Tek-Tips forums.) '****** start code ***** Option Compare Database Option Explicit Private Type FILETIME lLowDateTime As Long lHighDateTime As Long End Type '...
  10. shar

    How do you declare api function in vbs?

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

    Easy (?) newbe question

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

    WshShell.Run doesn't do anything! ? !

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

    WshShell.Run doesn't do anything! ? !

    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?
  14. shar

    WshShell.Run doesn't do anything! ? !

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

    Easy (?) newbe question

    ...copy, if different the following line of code is run: fHandleFile "D:\db\VXP\UpdateFrontEnd.vbs", WIN_NORMAL UpdateFrontEnd.vbs: ' * * * * Start * * * * * Dim strLocalPath Dim strNetPath Dim FSO strLocalPath = Left(WScript.scriptfullname, Len(WScript.scriptfullname) -...
  16. shar

    Easy (?) newbe question

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

    How do I run code in MSProject from Acc97

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

    I use access 97 to export data into

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

    How do I run code in MSProject from Acc97

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

    Closing a report w/o saving it.

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

Part and Inventory Search

Back
Top