I have 2 fields:
1)Title combo box: "Mr";"Miss";"Mrs";"Ms"
2) Gender combo box: "M" or "F"
I was wondering how to get the form to insert into the Gender field to "M if

I have a combo box on a subform that I need to fill depending on the
selection from a combo box on a main form.  The query I have is working and i
son the subform combo.  But where I have the problem is in the WHERE clause.  
The clause has the following;

I have a database that keeps track of prescriptions (by patient) and the
doctor that writes each prescription.  The relevant tables are Patient_t,
Scripts_t, Doctor_t and Meds_t.  The Doctor_t is related to the Scripts_t in
a one to many relationship using the DoctorID.  Within ...

I have created a mailto control (command button) on a form in Access using
the following code:
Private Sub Command31_Click()
On Error GoTo Err_Command31_Click

Private Sub Item_No_AfterUpdate()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim strsql As String

Linking one of the tables in Access 2000 to Oracle using ODBC connection. I
created a DSN in every user m/c. In one system DSN creatrion was successful,
but when accessing the linked data in the form I got this error "Reserved
error (-7709); there is no message for this error." How ...

How can I rerun all of my private subs? If  I make a different slection in my
combo box it changes the base rate in my form so I need to rerun all of the
subs again. Does anyone have a clue on how to do this because I am out of
ideas.

I'm trying to populate a string to send in an email from a recordset.  I've
tried a couple things.  I get the email, but the body of the email only has
the first sentence, not the list I need from the query.  Anybody got any
clues?  If so, is there a way to insert a vbCrlf ...

I have a continuous form based on a query.  I have two text fields that I
want to be able to update when the user clicks the Next command button.  I
basically want to get the next PositionID and get the two text fields to
update. I was wondering if anyone can guide me through this?

I have a Main form with a field called "Name".  It is a lookup field with
three columns and it is bound to the first column.
On my subform, I have a field called "Percentage".  I need the second column
of the Main form "Name" to populate in each record of the subform associated

Is there a way, from code, to close Access?
(I want to add that to the closing of an application.)
Bill

in my code for a garage frmWork is a subform of frmCar.
frmWork is based on a query, which takes as criteria frmCar.RegNum both are
linked via car registration number RegNum
RegNum and CustID are PK in the underlying tblCar

This is a repost as I am down to my last hair on my head.
I am using a listbox on a tab control on my mainform that has alisting of
all records associated with form main record. when I select the record in
the list box that I want to navigate to.  my form does not update.  Using

i was wondering what was the most simple way of doing this:
I have 2 fields called
1) Type of employment which has 3 list values to select from = "self
employed/company/internal"

I am at my wits end with this database no matter what i do i can literally
close the table before opening it and i still get a an error 3211 The
database engine could not lock table tblToolingArchive because it is
already in use by another peroson or process. I am the only currently ...