I would like to read Q&A's on using Access mdb as a front
end, linking all tables needed from SQL Server.
Can someone please tell me which forum I need to be in.
For now I have given up on adp.

If the required field property is set to yes, and data validation code is
not met, how do you cancel the event and undo data only in the required
field rather than the whole record?
Please help!

I have a form with buttons(for each company) on it and when clicked should
bring up another form with data records for that particular company.  Each
button represent a company set of records.  When I click on a button,
another form opens with data records for that company.  When I ...

The debug stops on the first "Case Is = 1 to 20000" line:
Private Sub PopulationBracket_BeforeUpdate(Cancel As Integer)
Select Case Nz(CountyPopulation, CityPopulation)
    Case Is = 1 to 20000

I am using Me.requery with a form's timer to access new data in the
underlying table. Everything works well except for the calculated text boxes
in the form footer which flash as they are recalculated. Most intervals the
values do not change, but the flashing is VERY distracting. ...

I am working in Access 2K and have a continuous form that
displays between 1 and hundreds of records depending on
the query choices the user makes. While scrolling through
the recordset it is easy to lose your place. What I'd like

Don't know if this is possible or not, but hope someone can help.
I use Access 2002.
My form contains the following fields:
DocumentID

I would like to have spoken instructions play when the user opens a form and
have inserted a sound object using windows sound recorder
Form in Design View
   Insert

I have a form that looks like this:
Actn  Model     Description
[ ]     [         ]  [                    ]
[ ]     [         ]  [                    ]

I apologize for my ignorance.  but I'm doing this for the first time and need
the advice of someone in the know.
I'm creating the frmSales based on qrySales.  My sales revenues are based on
either (not both) city or county populations.  Hence, every sale created by

I am using Access 2000
1.   I created a form with a field for "EmpID".  I made
this field a drop down list so employees only have to
click on a button and pick out their ID#.  But I want to

Right now I have Subform that I am controlling how it Sorts by using the
"OrderBy" Property.  It is working fine execpt when I try to Sort by a Field
in the table called "ProposalNumber" which is a Text Field.  So when Sorted
by this Field you get:

I have a user database that requires an Append Query to be run everytime the
user closes a specific form.
Can someone guide me in writing the procedure for this?
I don't want the user to see any of the process.

Can I test for an event from inside another event?
For example: I'm in an OnExit event. However, that OnExit event (from a
text-entry field) was precipitated by the clicking of a button. Chan I check,
withing the OnExit event, whether or not an OnClick event has also taken

hi, i am trying to create a code where when the user presses a button,
depending on which option button is chosen the report based on a query will
be shown in ascending order by Date Set (one field) or by Date Due (another
field). so on the form i have a group of option buttons. ...