I have a main report (single column report and page headers and
footers) and a 4 column subreport in the detail section. The report
will generally be a single page.
Everything prints fine except that I cannot get the report footer onto

I have a strange situation where one or more landscape reports that I
created in A2000 sometimes come up in portrait mode when opened on an A2002
machine. This phenomenon is intermittent, and most of the time they come up
in landscape. But every once in a while they come up in ...

Access 2000
I want to run some code on the Form_BeforeInsert event. But if the user is
entering data into one particular text box I do not want the code to run.
Something like...

I've got a problem I have't run up against before.  I generally test
for an empty recordset using BOF and EOF.  Today, for the first time I
ran into a problem where my recordset shows BOF and EOF = true despite
the fact that there is has an actual record (record count = 1).  The

A marketing company conducts auctions.
For each auction sale, there is a table (AUCTIONS)listing the auction
sale number, date, location, etc.
Another table (SELLERS)contains our client list (seller name, contact,

Hi. I have the following code in a module which sends email via Outlook.
Option Compare Database
Option Explicit
' Declare module level variables

I'm working on creating a form that will be submitted to a govermental
agency.  The form needs to be exactly as they have create it so I've
imported the base form as an Unbound Object from the original Word
Document and I'm placing my items onto this.

I posted a question recently regarding problems I am having getting a
value from a list box to use in a query.  I got a lot of help, for
which I thank you and it's nearly working!  But I need a little more
help on one more point.

I want to make a Lookup Field based on another Lookup field.  In other
words, I have this table A with two fields: ID and Name, where ID is
an Autonumber and Name is a friendly name.  Then I have a table B
which links to A via a Lookup Field so that I can select the friendly

I have a data sheet with a subform; each time the user clicks on the
"+" to show the subform, I want some code to run.  I tried attaching
the code to a wide variety of events, but at best they only ran the
first time the subform popped up.

I have a form that is designed as a data sheet view.  Attached to this
is a subform with some VB code.  When the user clicks on a row, the
subform should pop up and run the VB code which accesses the record
corresponding to the row clicked.

I am trying to make addresses print on a report.  I have two fields
for the street address, how do I make the second field not leave an
empty space on the report?  I want the city, state, zip to print right
under the first address field if the second address field is null.

I am trying to create a query to use as a report record source. Below is
what I want to do (this was tested and works with a MySQL web script):
SELECT
    contacts.id,

This is an interesting one.....
I have a field on FORM!FORMDATA (no, I did not name this) called KEY.
There can be multiple KEYS per record (equates to FIELDS on a given
DOCUMENT).

I have a subform that display requisition information.  One of the
fields in the subform is a combo box that shows who requested the
requisition.  The users can change who requested the requisition and I
would like to only have them be able to choose active employees.  So,