I want to have a custom Warning Message pop-up when a duplicate valu
in entered in a text field where duplicate values are allowed
Can anyone help

I need a little help creating a particular default value if this is possible
Lets say I have several vehicles with different numbers attached to them,
23, 43, 504, etc.
43 already has 3 entries along with the other vehicles (each on a separate

I need  access automatically create new rows. For Ex
Qty     Product     Price     Total  (when total entered,new row created for
next entry)
Qty     Product     Price       Total

I recently converted from 2000 to 2003.  Now none of my fields on mainforms
which refer to subforms are recognized.  (on forms or in queries).  I have
tried the =forms![mainform]![subform]![fieldname] and the me.parent things,
but nothing works.  Somebody please help me!

I have the default value for a control on a form set to Date().  Most often
the current date will be the entry, but I need to be able to change the date
if necessary.  If I change the date and tab to the next field, the date
changes back to the default date.  If I use the mouse, ...

I have 2 tables (Customerstbl, and ShipTotbl) and 1 form (Ordersfrm) I want
to use default address values from the Customerstbl to fill out the "Ship
to:" information on the form if there are no values in the ShipTotbl. But, if
I change the "Ship to:" values on the form, I want ...

Can I change the enter key to act like the tab key in a form?

everytime i try update a field on a form using the combo box, it keeps
coming up with an error message:
Cannot update field
it sometimes saves the update and sometimes doesnt saying it cannot say the

i know you probably had this one before,
i want to type in text in a combo box so as to update the table which
contains the data how do i do that?

Good Morning,
I am trying to create a calculated field in a report that creates a sales
tax report (driven by a query).  I have to report tax exempt sales, but I do
not include them in the taxable gross sales for sales tax purposes.  So

I want to do the following in a form:
I have a field named [Contact] if the user enters "Internet" then another
field named [Internet Contact] should be enabled. If the user enters anything
else in the [Contact] field box the [Internet Contact] field box must

I'm having a problem with my Forms.   I have a combo Box which works find but
when I use check for another CTAName the first search had replaced the first
CTAName with it's address.  What is going on here?
I have to replace the info in the Table.  I don't want the users having to

I was wondering if there is a way for me to add a button, link or something
that would tell me who is currentlt in the database. I maintain quite a few
and each time there is usually someone in it where I don't have exclusive
rights. My database is not split and is currently on ...

OK, I'm pretty new to access and I have this (maybe simple) question
I have to tables
Employee
Computer

I have a form that has 1 combo box.  When the form is first pull up it comes
up with all field blank.  This is what I want.   When I do a search on the
combo box and pull in the info - comes in fine.  But here is the problem -
when I do another search from the combo box the ...