I have an unbound form that I have set up to give me date parameters for different reports ie I have text boxes with start and end date and command buttons for OK and cancel etc.
We create documentation for several reasons disciplinary, on-site visits etc.  These reasons are ...

First fo all a big thanks for Mr. Hookom for this wonderful application
which helped a lot of newbies including me. i have a few questions t
Mr. Hookom or anyone else familar with this matter:
(1) What is the easiest way to nullify the database to start from ID=0

OK, I admit this is a refresher questions, can't find my notes in my piles.
On my employee form, I have two calculated fields one is for their age and one is for employment length.  This were originally set up as event procedures on "On Update"
How or can I set it up so that ...

 I am VERY new to working with Access. I am in the
process of creating a database for an elementary school
that will house data for each student, for each grade
level (ex: 1st grade data, 2nd grade data). Would it be

I have a table [Analysisform] with a field of "CertificateNo".  I need to
assign a custom autonumber that will advance one number, such as K1000,
K1001 etc. Not for each record, but for a summary of records.  The summary
could include from 1 to 75 records.  Each record must have the ...

I need to design a database which will allow only one
record to be returned, the table has Ages (between 18 and
80) and Premiums (between $10 and $150). The ASP form
will request age and premium and I need to return only

I'm currently trying to build a database for the public
radio station I work at for our first membership drive.  
I've found a pretty good template online, but I need a
little more from it.  The donations template is great,

How do you get the database to enter the same field entry
for each record you add, for example the same state for
all records?

How can I set the order of a group of records after they
have been entered?  My problem is that I have several
entries with dates.  I can do Sort Ascending in the date
field within the table view, but that doesn't change

I am considering a redesign of my tables. Currently I use an Autonumber
field called Book_ID, to identify records in my library table (Tbl_Library).
Now, this number has no meaning to the users of the application, so the
possiblity of gaps isn't a problem. However, it *is* used to ...

Wondering if anyone can tell me if and how it is possible
to link a table or subtable to a record in a field of
another table. For instance the parent table has one
field called vehicle make, and in that field are several

I have a A2K database with a table which seems to have a corrupt index
on a memo field. The corruption shows as garbage characters when the
memo field is used in some queries.
If I delete the index on the memo field, everything is ok. Since I

Can't seem to get either of these combo boxes to work.
Both are on the same form and I have been playing around
with them, but can seem to get them to pull up the right
record, or I get a runtime error '3464' Data Type Mismatch

What is wrong here ??
ALTER TABLE TRefStubData
   ADD CONSTRAINT TRefStubDataTData
   FOREIGN KEY (nDataID) REFERENCES TData (nDataID)

Windows XP, Access 2000
========================
Hi,
I have a table with a field for firstName and another for