I have two tables, Clients (ClientID,ClientIndustry,ClientCounty) and
EventStatus (StatusID,EventID,ClientID)
I have a form that Creates a new Event with the following fields:
EventID (Text)

i am in the midst of converting all of the "inherited" databases from
access 97 to access 2000. one of the issues i have is the basic one:
dao.recordset. i have read that i need to simply turn off the ADO
reference and change the reference ms dao 3.6 object library to ms dao

I have one report that consists of 3 subreports. Each subreport is
pulled from a query with date parameters ( Between [start] and [end]
).
When I run this report I have to enter the date parameters 3 times. Is

I am trying to create a validation rule in the DOB field of a table to
ensure the person is 16 years of age or older, can any one help with this?
Thanks

I'm using Access 2000.
I've written a function, blnExists(), to check if a particular value
exists in the primary key field of a table.  blnExists returns true if
the value is in the table and false if not.

I am making changes to an Access application that was written by a
previous coworker.
All I am tring to do is to get the text from a text box called
txtDate, and assign it to a string variable.

How do you add a header or footer to an Access report?  I followed the
Help suggestions of clicking on the View dropdown and either check or
uncheck Header/Footer - but that only deletes an existing one.  How
can I add a header or footer?

Greetings all.
Please help a real beginner using Access 2000.
During experimentation with this program I have deleted many records from my
main Table but the bottom left window always shows the actual number of

We are in the process of examining our current main application. We have to
do some major changes and, in the process, are questionning/validating the
use of MS Access as front-end. The application is relatively big: around 200
tables, 200 forms and sub-forms, 150 queries and 150 ...

We have a personnel database that we want to set up...For time off we
will have a start date field and an end date field as well as a field
for the number of hours.  We need to determine how many people (via
query) will be off for any given day (date) - for example:

I am trying to get this query right, but so far no joy...
I have written the following code in the Field box of the QBD grid of
a query:
firstvalue:IIf(Not (IsNull([Value1])),[Value1],(IIf(Not

I have a query that returns this recordset:
Bob, 1/1/2000
Bob, 3/1/2001
Bob, 2/4/2004

I will be doing an app for a nonprofit. It would be useful for them to
have a good entry-level book on Access so that they don't have to pay
someone to design all their queries and reports. I'm not familiar with
those books. Does anyone have a recommendation?

I want to use an Access web form for people to submit data on the company
intranet.
I currently have one table ("New PRoducts") that I am using for new products
and once that person has submitted the data and exited it is transfered to

I have a table which has path names to photos I would like to view. I
would like to open some/any kind of image viewer(Paint) to see the
picture when I click the pathname.
The pictures are mostly scanned newspaper atricles which are too big