Is it possible to run an access query from the scheduler? I need to
update a table in the middle of the night, and so I would like to set
up a job on a machine thats on all night so I dont have to manually do
it.

I own a small business.  Need to track a few hundred pieces of rental
equipment that can be in any of a few dozen locations.  I'm an old-time C
language programmer (UNIX environment).  If the only tool you know how to
use is a hammer, every problem tends to look like a nail.  ...

Access 2003
I have a simple line graph with one line and I need an extra horizontal
line in that graph. I want something similar to this, (without the
vertical line):

I have a database that is built in Access 97 that was perorming quite
well. After my company upgraded to SP2 it wreaked all kinds of havock,
and I spent weeks resolving all the issues. A form that opnened in less
than a minute would take up to twenty minutes.

The following expressions will not work on my computer. As far as I can
tell everyone else in my work group has the same version of Access with
the same service pack #. Any suggestions.
=Format(Date(),"Short Date") & " " & Format(Time(),"Short Time")

Howdy!
I am using '97 and I need a quick and dirty bit of code that will
convert user entry like this:
015,017,023

Friends, I would like some help with a code that allows me to run an
append query only if a specific field is not already stored into
another table.
Example.

I need to create a barchart to display how long our returns have been
in house.  The categories should be a count of items that have been
here:
1)  <30 days

I've seen this asked several times, but never a straight answer.
I have a query returning a set of sorted rows.  Let's say I get back:
Alice
Bob

This one is stumping me!
I have a Form/Subform arrangement. The main form is set as a Single
Form and the sub form is set as Continuous Forms.
On the Form_AfterUpdate event of the subform, I run some code that

Can someone tell me if this is close and if it can be done
IF ctl.control Source in CurrentDb.Querydefs("Maps and Plans Query")
then
Wherestr =  Wherestr & "(((" & "[Table_name].[colum name]" & ")" & "="

Recently we, in Norway changed to three different VAT levels. All three
needs to be on the invoice program. This is easy obtained via a new
field and set the rowsource to valuelist and make the three values :
0;0,00;0,06;0,12;0,25.

I can convert a yymmdd to (yymmdd - 1 day)
What I do is take the existing yymmdd string, convert it to a
mm/dd/yyyy date and subtract a day from it & then format it back into
yyymmdd.

I have a database which I have developed in Access 2000 which is working
nicely.
The problem is that my customer only has Access 97.  I tried to convert the
database but the main menu won't work.

I did a few searches, but couldn't come up with a clear answer to my
question.  So here it is: If I am in an open form (MyForm1), is it
possible to set the RecordSource of an un-opened form (MyForm2).  I
want to use the OnClose Event of MyForm1.  But I do not want to have