I have a form where certain fields that weren't required fields before now
have to be mandatory.
I have changed the Required property to yes in the bound table but when I
enter a new record in the form and exit the form, I don't get the error

I want to restrict the number of records displayed on a main form so that I
don't have to wade through hundreds of records for which there is no data
displayed on the subform.
I am really struggling to get the main form to only display records where

I have seven text boxes with calculations in them on my form. I'm trying to
get the highest value out of the seven to turn red. I used the conditioanal
formating feature and it doesn't work for the "greater than" function. So I
tried the "less than" function and that worked. So I ...

Hi guys.  I need some advice.  I've been wasting a lot of time trying
different approaches, but I thought I'd ask some experts for opinions.
I have a Form which access one table.
The table is not really normalized, it has a Document number as a key,

Is it possible to create a save and exit button within VBA?

I have a combo box with is linked to a column in a table. This column
can only have the values that are already listed in the combo box. How
do I prevent the user from entered any other values then what is
listing in the combo box?

Ok,
I have looked at this and customised it I think correctly, do I put the code
under the click event of a command button? Sorry new to this and getting to
know the ins and outs.

Dear all, I had a problem with the Access2003 database. Users use an access
database in a server's share folder in the LAN. When double click a form in
the database, it will popup a window which allows users to choose the date.
But there is a new computer can not display DTPicker ...

I'm wondering if there is a way for me to export some tables including
data and structure from old database to a new database and then save as
new database name.
I try to create a marco and it create a new table within the same

I'm certainly no expert in Access, but this has got me scratching my head...
I've got a form with a list box, used for locating the record I want to
view. The form's table is essentially a register of visitors. The list box
contains the unique visitor number, a surname and company ...

Can any one please help me how to i check the first character in a
variable. If user dont put 0 in the start of a variable the program
automatically insert zero before the number otherwise not.
mynumber=1234-6565-75 of type text

I have created a database which hold customer details, stock control and
sales.
I am having difficulty with the following.
When I sell and Item I need this to be deducted from the total stock for the

This may seem like a silly question given Access is a database
management tool, but I am working on a project to develop a change
management tool that will allow users to request changes to certain
data values within tables in a production environment database.  The

I have a form with clients’ data (clientID, clienteName, etc.).
I need the field clientname to be automatically filled after the user tapes
clientid.
Clientid is a 1 column combo box and it looks for data on clients table.

I thought I had this problem licked but I don't now. I have a subform with
the following
ProductName UnitPrice CostPrice Quantity UnitSubtotal CostSubtotal
where UnitSubtotal is =[UnitPrice]*[Quantity]