Recent content by hsp7777

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!

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

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!

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

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.

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

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

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

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

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

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

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

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

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

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