Search results for query: *

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!

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

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

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

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

Greetings, I am using the following code to display a report when a command button on a popup form is pressed. What I have had to do, however, is add the line of code, "DoCmd.Close" to close the form (so that the report can be seen). Otherwise the form overlays the report. Does anyone know...

Greetings, I work with a rather large Access database at my place of employment and we have corrupt records from time to time, forcing me to run a Compact and Repair several times a week on the source database. At any rate, I was wondering if there is some type of scheduling tool which would...

Greetings, I was wondering if it is possible to have a "counter" field in a report? For instance, I currently have a group header for a field named, "DepositDate". I want to place the total number of items that appear in the report (as a result of this grouping) in a separate field. If I use...

Greetings, I am trying to populate a hidden field (txtHiddenRepName) on an Access form when another field (cboLoanRep) is clicked. The following query is what populates the combo box: SELECT DISTINCT Members.LastName & ", " & Members.FirstName AS Fullname, Members.RepName...

Greetings, I am attempting to display the File Open dialog in MS Access (which I've never done before), and am having problems with the following line of code (which I have placed in a Class module): Private Type OPENFILENAMElStructSize As LonghwndOwner As LonghInstance As LonglpstrFilter As...

Greetings, I was wondering if it is possible to programmatically change the caption of a label on an Access report? For instance, I am attempting to use the following code to change the caption of a label (on a report). I receive no error message during execution, but the caption of the...

Greetings, I have the code below (in VB 6.0) and am attempting to open an existing report (in Access 2000) in Print Preview mode. However, I receive the following error when it gets to the line of code, "acapp.DoCmd.OpenReport ...": "Runtime error 2486: You can't carry out this action at...

Greetings, I have the following code (in Access 2000) which composes an email message and attaches an Access report in the message. What I have noticed, however, is that my Autosignature is not added to the email message. Any idea as to why? Is this a limitation of the "SendObject"...

Greetings, I am looking for some advice. I have a user who wants to use MS Access to display a calendar. For each day in the calendar, there should be room enough to display text. There should also be some way of adding text to a particular day so that a list of activities for that day is...

Greetings, I hope this is the right forum to post this question to. At any rate, I was wondering if it is possible (in Outlook 2000) to sort my shortcuts? So far I have been unable to find a way to do this. In IE, for example, I can right-mouse click and choose "Sort by Name". Is there...

Greetings, I have a popup form which has several fields that are bound to a table. When I choose the "Cancel" button on this form, however, the changes I have made to these bound controls are saved. The code I have in the "Click" event of the "Cancel" button is below. I have also set the...

Greetings, I have a question regarding the "Write Conflict" error message box in Access 2000. I have a main Data Entry form that is bound to a table called, "Loan". I also have a secondary popup form that displays when the user presses a command button on the Data Entry form. This second...

Greetings, I was wondering if it was possible to issue multiple "Update" statements with a single" "db.Execute" command? I am attempting to use the SQL below, but I am receiving a syntax error. Any thoughts or suggestions? strSQL = UPDATE [tblAudit_ApplicationLog] SET Seller = '1', Terms =...