I have a combo box to be used for multiple selections throughout one form. I
am able select the different values throughout the form however when I try to
save it I receive the message: "The changes you requested to the table were
not successful because they would create ...

I have a price field of type Number.
I need the following validation rules to be set up.
If  (decimal part of price) < 50
  then round (decimal part of price) to 45

I have a set up Access security on a database containing two forms. One
that users can only create new records and one where they can edit
records. When a new record is created, I want the user's login (Access
login or Windows login) to be automatically entered in the form/table.

I have a search form with 2 subforms, one is the search criteria the
other is the results of the search.  This all works really well that is
not my problem.  the issue is that based upon the data being searched I
need to change the lables, record sources and control sources of the

I am using the beta version of Office 2007 in Access trying to use a text
box. I never had this problem in 2003. #Name?

I have a form that contains a couple of subforms. All works like I want it
too except that the subforms don't refresh their data unless I move to the
previous record and back.
In the past I have not been successful in getting all the sub forms to

I use Access 2000. Need help with moving through records. I have a main
form ”FMonPayPark” which has two continuous subforms.  Using a command
button which is on each record in the first subform-“FMonPayParkC”, I run a
query that appends records in the second subform-“FmonPayParkB”. ...

I have created an unbound combo box that when placed on a form takes me to
records specified.  Works great, however I have created a tab with three
pages and the control shows up on each of the pages.  I want it to show up on
only one of the tabs, so I have:

I am trying to use DCount criteria to verify if the record with some
criteria already exists in a table. Here's the code I used:
Dim conKey As String
Dim strExist As String

Good day,
My search for answers to my question is not very successful…
I have a listbox on a form (lstTask). Its source is a table with two fields:
[Task] (visible to the user) and [Item] (lstTask.Column(2) - hidden from the

Hi Group, this is my first post.
My forms sometimes open in maximised view, however I would like all the
forms in my db to open under the 'restore window' view.  Is there any way of
doing this.  I have had a check through this group and I have looked on the

I am designing a restaurant menu application and have been requested by the
user to design a menu ordering system where the names of items appear on
buttons.  E.g. Clicking on the Drinks button in the header will display
buttons for all the items with category drinks e.g. button ...

hi, i guess i'm missing one step in the create of the database....i'm create
the tables, and the big form...i was testing my form and appear #Name? in
every textbox....and in properties of each one, in control source, should
appear a list of fields, but its empty.....that why i ...

hi
im using a combo box to select an organisation name from the organisation
table and to fill another field for the organisation id.
once i select an organisation out of the list it changes every row how do i

I have 2 tables.
tbl_Customer
tbl_Contact
I have created a form (frm_Customer) that contains the fields from