I'm attempting to use the windows scheduled task feature to automatically
download information via ODBC into an access db.  The problem is that the
ODBC user id and password has to be entered before the data will transfer.  
Is there some way to programmically enter the user id ...

How does one report bugs?

I've been asked to generate a list of all the fields used within an mdb for
certain selected tables. Aside from going through each query and manually
inspecting them, is there a programmatic way to do this? (I've examined the
hidden system tables but they have not been helpful).

I have two different reports that are generated from the same table. They are
sorted by customer, generally one page per customer. I would like to be able
to print the reports collated together, as follows:
Report 1, Customer 1

I have an Order entry form that contains fields for customer name and order
date. It also contains a subform with order details.
I would like to test the customer name and order date and in certain
situations stop it from generating a new record. But it seems like whenever I

I have a combo box in the form header that finds my record of interest (I
used the wizard to create it.)  When I disapprove a client  (in the
after_update event of a frame that contains option buttons labeled "approve"
and "disapprove") that record disappears (via Requery in the ...

Here's my code:
Private Sub Command4_Click()
   DoCmd.OutputTo acOutputQuery, qryBillingExport, ,
([Forms]![frmBillingExportFrom]![dateCollectionDate])

Hello, I am having a problem with a database that I have.  The database is a
vehicle checkout one that I helped create.  The part where I am stuck is when
a user goes to checkout a vehicle they click on checkout vehicle and then can
slecet the vehicle they want along with the ...

I've actually posted a similar question but still cannot resolve... Please
help!
What i want to do is when i select a value from a drop down list in a form
another text box needs to be populated with a value from the same line...

I'm using this code to identify existing cases in a table based on an account
number.  This code searches all records for the past 3 years, I'd like to
alter the code to only look at the past 60 days cases rather than the entire
table.  The date is in a field called ...

Hi I have the following code:
Dim xlapp As Excel.Application
Dim xlwkb As Excel.Workbook
Dim xlWs As Excel.Worksheet

How do you send email in an access code in a module? Using access 97. Thanks.

I would like to know how to test if a person is less than 18 years old.
Something like this:
where dtDateOfBirth is their birthday and Date is the current date
if Date - dtDateOfBirth < 18 then strStatus = "Child"

I have surname on a form, and sometimes the surname might have a quote, like
O'Neil.  This is my statement to set the criteria, but it does not like the
user entering a quote in the data - how can I fix this?
stLinkCriteria = "[LastName] LIKE '" & Me![surname] & "*'"

Is it possible to print a report based on the selected record of a form
without actually opening the report.  I would like to print the record to a
delivery manifest as the user completes the current record.  The form name is
frmDelivery and the report name is rptDeliveryPrintOut ...