Hi, I am not very good with code and I have a cbo in which a user selects a
value from a drop down list. If a user types a value that is not in the
list, I would like a custom message to display that will inform the user the
value needs to be entered into the table via another ...

Is it possible to run an Update query on all records in a table
automatically.
I have a database with about 120,000 entries with 4 sets of prices. I wish
to run a price matrix (update query) against this database. The price matrix

I need to select a record with a SQL, which will execute when i click a
button. the field SSN is in the main form, the field DateOfVisit is in a
subform (which is on a tab within the main form).  i have tried the follwing
but have been unsuccessful.

I have a form that opens on autostart. I added code for its OpenForm event,
and included the "On Error go to error-routine" command.
This code checks that a specific table has specific data in it. If it
doesn't, a message is displayed (OK only reply), after which the Quit command ...

         I WOULD LIKE TO GET THE CODE FOR CLOSING THE CURRENT OPEN FORM
WHEN WE OPEN ANOTHER FORM IN A DB.
THANK YOU

I've just created a send to file button and it works fine except that it
wants to send every record into the file.
Here's the code:
Private Sub cmdFGSpectoMSWord_Click()

currently I'm using a bunch of subforms in an informational read-only DB
for my call center. users type in a zipcode or a city name into a text box
I use as a search box and then a bunch of different subforms bring back a
bunch of different info from a different tables about that ...

I have a subform (subDonations) that I want to change based upon a choice in
in an option group (grpReports).  I am using the following code, but it isn't
working.  Any suggestions?
Thanks.

I am trying to set up a form from which the criteria of a query can be
changed, ie once a month the dates will need to be changed for the rest of
the users-so the intention is to set up a form to amend the query- Any ideas
on how to code this would be appreciated.

MS Access 2K, Windows XP
====================
Hi,
I have a form with a combo-box whose row source is a query. I want to give

I have a combo box in the header section of a form, I have the code below in
the after update event to find the record that goes with the item selected in
the combo box.  The problem is, some of the selections will have more than
one record associated with them.  With the form in ...

I'm trying to clean up some data in a database I was given.
One of the fields (Text, 50) is a unit designator, some of which are
hyphenated.  When I sort by this field, I get some results that I did not
expect.

I have main form with a subform. this subform is a continous form type
date sheet. I have implemented code that allows a user to multiple select
checkboxes in the continous form by using a collection of checkboxes.
this works great.

I have a Form/Subform. The FORM consists of two field "Confirmation ID"(Key),
and "Confirmaiton Number".  The subform consists of "Purchase ID"(Key),
"Confirmation ID", "Item Description", "PricePaid", and "QTR".  The QTR field
is a combo box which indicates when something was ...

I have a subform that gets populated with records.
After it is populated I would like to loop through
the records in the recordset.
I know I could create an ADO recordset that exists seperate of the datasheet