I have developed a form and now everytime I try to scroll to the next message
I get the message "The value you entered isn't valid for this field" before
it lets me go to the next record.  How do I get rid of this?

I have a subform inserted in a main form. There is a border at the top and
left margins of the subform. Can I eliminate it to make it all look seamless?
Thanks

With a number of forms open, when I return to a form I want it maximised, to
fill the screen. Generally it returns reduced. How do I get it to be always
maximised.

When i drag a command button onto a form the wizard does not start i.e. run
qry open table etc any ideas

I'm new at Access so please bear with me.
I put together a Form without a data source. Just unbound text fields to
allow someone to enter some min and max values to control a report. I
then make a control to open the report. (I tried both a Macro and via

I have a simple DB file which has Employee details regarding salaries and
allwoances and deductions.
I created a form to suit my needs but when it comes to the calculation part
of it, I always fail even though I tried looking up in the Help menu.

I have a form linked to a customer table. On the form is an Add New button. I
need to check for duplicated codes after user enters the customer and not
after all the form has been filled in.
Can anyone tell me which event I should do this on i.e. Before Update, After

Can someone tell me if it is possible to utilise the Microsoft calander from
Microsoft Acces to set and check on appointments that I have in my Microsoft
Outlook program.  I need to be able to set and cancel and check on the
current appoinments that I have.   Is there code that I ...

I have created a tab control on my form and am trying to get one of the tabs
to display a subform. I dragged and dropped the form onto the tab control but
in the normal manner of creating a subform but it doesn't work. Can you not
do it this way? I've manually entered my link ...

I have an existing training records database.  These are the three tables:
tblEmployees
   EmployeeID (PK)
   FirstName

I have a sub-form (continuous forms) which displays data from an archive
table. I want to be able to highlight the duplicate entries in a different
colour.
Ive tried the duplicate query wizard and conditional formatting. Im guessing

Thanks in advance.
Below is an explanation from access about requering. To me its not clear or
is it saying there is a difference between DoCmd.Requery method and Requery
method. If you could, could you show me the expression used for both. Thanks

I have two tables, one with the key "Building ID".  The second table has the
key "Image ID" plus I also added the field Building ID to it in order to
relate the two tables in a one-to-many relationship.
My form for Table 1 has a button which opens the form for the second table.  

I'm using access 2003, and can find a listbox control and a combo box
control, but no a drop-down list box control. Is there one, or can you
make the combo box act like one? I basically don't want to be able to
type anything into it, and always want the default selected item to

I have a field named LOAN_STATUS, which is a drop down menu of the following
options.  Approved & Research.  I want to write the following code but I
don't know how.
IF the Refund Amount >= $350 the LOAN STATUS must equal to Research.