We have a customer who has developed extensively using Access 2000.  She has
requested our help but we do not have the same version of Access as she does.
I looked at the MS site and of course they no longer allow purchase/downloads
of 2000.

Hi, I’m hoping someone might be able to help me with a date expression. I
have a table called ‘Personal details’ with a field called ‘DateOfBirth’ and
it has a short date for its data type (ddmmyyyy). So a person’s date of birth
goes in that field. I then have a field called ...

I have a dropdown to select a type of report to run, then a button to call
the report.
The dropdown changes but the control's value doesn't until I leave the
dropdown.

OK.
I've got a form that contains two subforms, one called "Units subform", the
other called "Records subform."  The Units subform allows the user to select
a record from the database in Datasheet view.  The Records subform displays

name list in demo i modified it but i cant fix it
error (there is no field name)

I have a database with a query with patient referral details plus some
calculated fields. We need to monitor whether the patients are referred on
fast enough. There are the following fields (in addition to others): date
referral received, date referral passed on, today's date, ...

I enherited a database (.mdb) that was recently converted to Access 2007 from
Access 2000.
The users swear that they used to be able to click and hold the MoveNext
navigation button and the form would scroll through all the records.  These

I have a one to many relationship between two tables. In the "many" table I
have a date field. In the one "table" I also have a date field.
What I would like to do is find the most recent date in the "many" subform
and place it in the date field in the main form.

I'm trying to use option buttons on a form to output a value other than 1,
2, or 3 to my table. It needs to output a character instead, E, TD or C.
However, I can only get the numbers to output. Any help would be appreciated.
Thanks,

I have a form in which I have 2  combo boxes. 1 called StartMonth and
another called EndMonth.
I have a query called MonthsAvailable, this gets its info from
Date Out By Month: Format$(JobsInv.DateOut,'yyyy mm')

Does anyone have a form template for password requests? Thanks in advance.

Split Access 2000 application.
As a user moves through records in an app on one machine I need to display
related records on a large screen.
The user's screen will be completely different that what is displayed on the

How can I get a date or any field to stay the same in a form until I change
it.  I need to post a lot records under same date.  It would save untold time
if I could not have to re-enter the date each time.
Thanks for any help.

I have a  form in which I m trying to add the value of two bound textboxes  
to be displayed on a third textbox, the sum on the third textbox is not
stored on the table.
I've tried to add this code:

Is there a way to populate a multi select listbox in this way.
Alabama Arkansas
Arizona
Alaska