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 Chriss Miller 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: hsp7777
  • Order by date
  1. hsp7777

    Email Alert Box

    Just as a follow-up to the "ClickYes" freeware program, I have noticed that if my workstation is locked, then the program doesn't run until I unlock my machine. Is there anyway to get the "ClickYes" program to run even if the workstation is locked? Thanks!
  2. hsp7777

    Utility Which Closes Access Applications

    I did see some information on Google regarding shutting down an Access application at a certain time. However, I didn't see anything which shows how to determine if there has been no activity within, say, the last 15 minutes. Since I don't want to shut down an Access application at a particular...
  3. hsp7777

    Utility Which Closes Access Applications

    Greetings, I was wondering if anyone is aware of a third party tool or utility which will shut down any sessions of Access that a user has open (after a period of inactivity, such as 15 minutes)? Thanks in advance!
  4. hsp7777

    Task Scheduler Problems

    Thanks. I appreciate it. (By the way, I haven't added any patches recently. I simply have XP Professional with SP2).
  5. hsp7777

    Task Scheduler Problems

    This is being done on my local machine. I am logged in as myself (I have Admin rights). I guess I could use the Admin account and see what happends. Thanks.
  6. hsp7777

    Task Scheduler Problems

    Greetings, I was wondering if anyone has any suggestions for me in regards to using Windows Task Scheduler? I have attempted to use it numerous times (to run batch jobs at night, etc.), but it seems to run half the time and at other times it won't. When I check the log in Task Scheduler I see...
  7. hsp7777

    "Object Expected" error with Body.Onload

    Thanks. I discovered that it was due to a semi-colon after the function header. Sometimes it's the little things, huh?
  8. hsp7777

    "Object Expected" error with Body.Onload

    Greetings, I have a "newbie" question in relation to the following code below. I am simply trying to call a JavaScript function (and pass the following argument) when the "body onload" event occurs. I am receiving an "Object Expected" error instead. Any ideas as to what I am doing wrong...
  9. hsp7777

    Automatically Running a Compact and Repair

    I added "IF ERRORLEVEL 1 GOTO FAIL", but this still writes out to the log file that the Compact and Repair was successful, even if the database is open and the Compact and Repair doesn't complete. It almost appears that no error occurs even if the Compact and Repair was not successful. Does...
  10. hsp7777

    Automatically Running a Compact and Repair

    Greetings, I am attempting to use the code below (in a batch file) to write out text to a log file, but it writes out that the Compact and Repair was successful even if it does not run (due to the Database being open by another user). Is there anything obvious in my "IF" statement that I am...
  11. hsp7777

    ActiveX Component Can't Create Object

    It is declared as the following: Dim objApp As Outlook.Application Thanks.
  12. hsp7777

    ActiveX Component Can't Create Object

    Greetings, I am using the following code and trying to send an attachment from Access 2000. The code works fine if I have Outlook open. If Outlook is closed, however, then I recieve the following error message: "Error in SendOutlookMessage (1):429 - ActiveX component can't create object"...
  13. hsp7777

    Email Alert Box

    Thanks. The "ClickYes" freeware program seemed to do the trick. Thanks again.
  14. hsp7777

    Exporting a Query

    Thanks. The "DoCmd.TransferSpreadsheet" solved the problem.
  15. hsp7777

    Email Alert Box

    Greetings, I am attempting to use the following code (in Access 2000) to email an attachment. However, when the code runs I receive the following message: "A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus...
  16. hsp7777

    Exporting a Query

    Greetings, I am looking for someone to point me in the right direction as to how to use VBA code to export a query (as an .XLS file). I wasn't sure if I needed to use something in the query defs collection, or if there is a parameter that can be used with the "DoCmd.OpenQuery" command. At any...
  17. hsp7777

    Automating an Access Query and Saving it

    Greetings, I am looking for some general information which will help me accomplish the following (on a nightly basis): 1) Run an existing Access query (which resides in an Access 2000 database). 2) Save the results of this query as either an Excel file or .CSV file. 3) Email this file as...
  18. hsp7777

    Automatically Running a Compact and Repair

    I have one other question. How would I run a Compact and Repair for a database that has a space in the name? The name of the database in question is "J:\QC-App 1.0.mdb". I have tried using the following in the "2000MDB.txt" file: "J:\QC-App%1.0.mdb" "J:\QC-App%%1.0.mdb" "'J:\QC-App 1.0.mdb'"...
  19. hsp7777

    Automatically Running a Compact and Repair

    Thanks so much! I appreciate it!
  20. hsp7777

    Automatically Running a Compact and Repair

    Thanks. By the way, do you know if there is there a way to write out a log file to indicate that the Compact and Repair was successful?

Part and Inventory Search

Back
Top