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.

...check the log in Task Scheduler I see an error message such as the following: "CompactandRepair.job" (CompactandRepair.bat) 6/30/2005 10:14:00 AM ** ERROR ** The attempt to log on to the account associated with the task failed, therefore, the task did not run. The specific error is...

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.

...= .Recipients.Add(strEmailBccAddress) objOutlookRecipient.Type = olBCC End If .Subject = strSubject .Body = strMessage '* Add attachments If Not IsMissing(strAttachmentFullPath) Then If Trim(strAttachmentFullPath) = "" Then Else Set...

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?