How do you code dlookup over two join tables?
Outbound Trucks    Join Table   Product Detail table  Join Table  Inbound
Table
    - OB Truck ID     Ob Truck ID       PO#                 IN Truck ID    

I have a check box on a form that when checked opens another form and copies
data to the newly opened form. Once the new form has been opened and data
added I would like the check box on the main form to be removed. However if a
user click on the check box I would like it to open ...

            I have couple of forms which need to be filtered before user
can work on them. I am using cascaded combobox. Each form needs to be
filtered by a contract Number which then shows corresponding vendors for that
contract but my question is....I know that Number of ...

I am entering data into to forms.
I have a Master_Jobs form I have an Account_No field and a drop down list
for the Job_type field where when I select a particular job type, in this
instance it would be "New Contract" a form with Contract Type Option box.  

I'm looking for an example VBA Code to export or transfer query data
from MS Access
to Excel.
I use this code:

I have a subform that allows for entry of up to three codes for every
record on the main form.  I want a text box (on the main form) to
display a phrase IF any one of the codes entered on the subform is
="10A2".

O.k., it's late and I simply cannot remember how to set this up
correctly...I've got a form (Applicants) with a button that opens another
form (References) to the linked records on the Applicants form--did that part
with no problem.  However the linked field doesn't auto-populate ...

I have a query where I want to calculate the sums of money received and also
the sums of money not received. I need to do both these sums in the one
query.
I am using the following expressions in the field rows:

I want to create a case number each time a new record is added via a form I
already have.  The form will be usable by numerous people at the same time to
enter information into the underlying tables.  It has two sub forms on it
that the user can also enter information in.  One of ...

I am using Late Binding for creating a word document from Access 2003.  All
is well and good EXCEPT I am having difficulty with the following.
I am using bookmarks within a template to place data throughout the
document.  One of the bookmarks is actually replaced with a Word table ...

I'm trying to control the appearance of a control (textbox) only when it
has focus. I set up [control name]_Enter and [control name]_Exit routines
which accomplish exactly what I want, except, all instances of the control
are changed instead of only the one with the focus.

I am trying to print a report for the current record only.
This is the code that I am using in the OnClick event of a command button in
a input form:
DoCmd.OpenReport "Rpt_Rental_Detail_Billing_Sheet", , , "Rental_ID = '" &

I have an application which allows the user to create a new database, then
links or imports data from an Oracle database into the MDB.
After using the Createdatabase method to create the mdb, I want to be able
to hide the system tables.  Any ideas?

Without linking to another database, how do you delete the contents of a
table in one database as part of a process in a second database?

Hi! Please help me! i have a filed ADay on the table. when i loop through
rows using "aDate = rst![ADay]" everything goes fine until there is a null.
and when it has null my program stop. and when i use "aDate =
DLookup("[ADay]", "Table1")", it would work good even if i have null ...