How would I do this ... I want to set the Windows Scheduler to run the
.bat file which will open an access database at like 2 in the AM.  What
code do I need in the .bat file.

I have a form with a rectangle [backstyle normal] and a label
[backstyle normal]
If the rectangle is placed first, and the label second, the label is
seen.

Hi, for the first time in my career I have a legitimate need for a one-
to-one relationship between tables.  I see no way to set op a one-to-
one within an ADP project, however.  Do I need to write a trigger to
enforce a one-to-one, or is there an easier way?

i want to know event occurenced when the access application is closed.

Can anyone help me please, this is causing me a real headache.
A Database here (Access 2003) uses code to open a mailmerged document
in Word 2003 which is linked to a query.
Problem is, it opens the document but doesnt actually do the

Anyone have an idea what I am doing wrong? I am using MS Access and I
am creating a Pass Through Query. I get the following error:
ODBC--call failed>
[Oracle][ODBC][Ora]ORA-00904; "B"."RECVDATE": invalid identifier

I have a bound textbox called txtMyBox with the current string value
of "200".
Once the user enters the textbox, and while the user is still in the
textbox, I would like to check the changed value using a function to

=DLookUp("[CompanyName]","Model Data","[CompanySymbol]='" & [Ticker].[Value]
& "'")
This formula works...it pull the company name, matching the Ticker put into
the Ticker field.  So putting in IBM will pull its name from the Model Data

Is there any way to export an Access Report, including the format, into a
Word document - other than printing to a PDF.

I have a supplier database from the microsoft templates Inventory
management database. The trouble is when you change the supplier the
list of products in the subform remain the same everytime and are not
unique to that supplier. Is there some way to get the drop down to

I have an Access db with two large tables - 3,100,000 (tblA) and 7,000
(tblB) records.  I created a select query using Inner Join by partial
matching two fields (X from tblA and Y from tblB).  The size of the db
is about 200MBs.

I have an orders form which has orderID as the primary key, it also
has supplierID as a foreign key located on the form. I need a lookup
field (that looks up the account number which is located in the
suppliers table) on the orders form that syncs, so when the user moves

I have an Access db application that is intended to present the user
with the next available record to make an outbound phone call on.
Originally, I had set it up as a "split" database but, due to
performance issues, I moved it into one database which is accessed by

I have a textbox "Fname" where users input what they would like a
filename to be.  I would like to strip out all invalid characters with
an "After Update" Event.
I have searched other strings and attempted to use other suggested

Does anyone knows the odbc driver / string to connect to Access 2007
file (.accdb)?
I can't find it anywhere...