Search results for query: *

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

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

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

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

Thanks so much! I appreciate it!

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?