I have a database where users are inputing customers who are identified by a
unique Customer_ID (this is the primary key).  If a user attempts to enter a
primary key that is already in use, they will get the following message
after completing the entire form and attempting to ...

Ever since I moved the access 97 backend to a SQL Server backend with Access
97 front end..some forms pop up with a The data has been changed...Another
user edited this record and saved the changes before you attempted to save
your changes. Re-edit the record. Message...when I ...

     Access novice here!
I have Form (plus subform) which contains 4 fields (Surname, Forename, Year,
Tutor Group). The "Surname" is a combobox with RowSource set to table
"Student List" which has Surname as primary key. I have set the Surname

Okay, I know this is an easy one but it has eluded me.  I have a details
form, each item being ordered.  I want to calculate the price for each item.  
How to I limit the Qty*Price calucluation to just the row not all records in
the datasheet view?  Thanks

Thanks for taking the time to read my question.
I have 2 combo boxes that I want to filter on. One is Person, the other is
location.  Many people could be at many locations, and I want to filter the
form for a person at a single location, thus showing me all their visits to

I get an error 2501 any time I cancel a switchboard operation that needs user
input before occurring, e.g. criteria for a report.  When I go to debug, it
highlights the docmd line in the select caseportion of the HandleButtonClick
code for the switchboard.  The switchboard was ...

I asked a similar question in an earlier thread, but I think I wasn't as
specific as I should have been.  I am using a form's BeforeUpdate event to
perform data validation.  When something is found to be amiss, a message box
advises the user that they need to go back and fix ...

I have a table named "Nil-Master" having a string type fiel
named"Customer". Now  a new Form is used for data entry. This for
named "Nil-Question" having field named "Customer"
I want that when User enter customer no on form then this custome

I have a database that has an error but I don't know what the erro
is, it appears in the debug.  The problem I have is that thi
database was created years ago has not had an administrator fo
years.  I have no idea what the original code was and I don't kno

How do i make a caption of a form equal to a field in a table...
example   Tablename : tblCOMPANY
              Field : co_name
on the on load event of a form do i put a code like

In making reference/settings to a text-box field in another form,
I've used the statement:
Forms![TMS Switchboard].Form!InstName.Caption = IPName
Where "TMS Switchboard" is the name of the form. What's the

I have a form frmNewMembers and I record member’s first names in a field
FirstNames which I would like to copy into the next field PreferedName making
it easier to edit than type in the entire name.
I have no idea how to go about this as I have tried this in the Default

I would like to be able to lock a particular field from being changed when
opened to be edited - specifically the name in a form, while allowing other
data to be updated / modified. any suggestions would be greatly appreciated -
TIA

I have a main form with an unbound sub form. The main form has an option
group with several toggle buttons. The source object of the unbound sub form
is filled at run time when the user clicks on the toggle buttons for the form
they want.

I have a start-up form that I want to perform queries upon opening then close
and compact the database once finished. The problem that I will have is when
I want to maintain the database, I will not be able to stop the code from
running. What I thought I could do is open the form ...