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!

  • Congratulations strongm 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: *

  1. 68790nuiihui

    Automatically Running a Compact and Repair

    J:\QC-App 1.0.mdb" in the text file should work... If not, try opening up a command prompt and entering the command that would be run in the batch script, so... START "" "%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" %1 /COMPACT /REPAIR would become START "" "C:\Program Files\MICROSOFT...
  2. 68790nuiihui

    How to send one line to printer or report using VBA

    If your printer is connected to your parallel port, simply send the data to port LPT1. I'm not very competent with VBA, but in a batch script this would look something like: ECHO The data is as follows: %DataStoredInThisVariable%>>LPT1
  3. 68790nuiihui

    Automatically Running a Compact and Repair

    yes - instead of using START "" "%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" %1 /COMPACT /REPAIR use something like this: CALL "%PROGRAMFILES%\MICROSOFT OFFICE\OFFICE\MSACCESS.EXE" %1 /COMPACT /REPAIR IF NOT %ERRORLEVEL%==0 GOTO FAIL ECHO Compact and Repair on %DATE% at %TIME% was...
  4. 68790nuiihui

    Primary pc setting - where is it stored?

    Thanks for responding LloydSev. There is a pdb on the palm scanners named DefConnection2db_EnUS.pdb that contains the Connection Setup options, so was really hoping that the primary PC would be stored somewhere in a similar way. Another possible way to do it though - any idea if i can set up...
  5. 68790nuiihui

    Primary pc setting - where is it stored?

    We have roughly 30 symbol spt 1700 and 1742 units that sync to one of our servers remotely from several uk sites, as well as various sites across europe. However, we now want to migrate all these units to a new server. I wrote a quick batch file that syncs that palm data (c:\program...
  6. 68790nuiihui

    Automatically Running a Compact and Repair

    Acc2k is in fact simpler as it doesnt give the irritating "Successfully repaired [yourdb.mdb]" dialogue, so you can strip out the reference to the clickok.ahk script from the batch script and you wont need to install AutoHotKey. the path to the access program is also slightly different - change...
  7. 68790nuiihui

    Automatically Running a Compact and Repair

    We have several ac97 db's that require compacting and repairing frequently, and also need to have macro's run inside them. i wrote the following batch script to do it all for us. you then just add the script to your windows scheduled tasks. put the full unc paths to all your ac97 db's in a text...

Part and Inventory Search

Back
Top