I don't usually monitor this group, but I have a forms question, so here I
am. :)
I needed to put a checkmark on a form a while back, and I remember the
controls I was using in Access (2000 or 2002, not sure) not supporting

What criteria should be placed on the textbox "qty" on Form1 so that the
quantity that is going to be purchased should not exceed the quantity on hand,
which is shown on the textbox "unitsleft". Also if the quantity purchased
exceeds the quantity on hand, what should i do so that ...

How can I delete all the records of a certain table using a query, a macro,
or even a procedure module?
Thank you for the effort.
Best regards.

Which mask should I enter in a field, in order to assume the following types
of values: "11-AA-11" or "11-11-AA"? (note: the numbers and the letters are
examples). I just want to enter "11AA11" or "1111AA", and the mask would do
the rest... Is it possible?

I have a form for entering query information. Two of the fields are the
customer name and first line of address. When I transfer all the fields from
one table to another, I also transfer these two particular fields to a third
customer table.

I am trying successfully to add an Edit button on everyrow of the record for
user to edit current record on a Tabular form. This feature is turned off
when I switch to Datasheet form.
Is there an alternative way to put a button on Datasheet form to obtain view

On my form I have a check box called "Qry_NPE" which is defaulted to "true"
and it indicates that the enquiry has no errors. The errors are on a subform
and I have a textbox that counts the number of errors.
I am trying to use the "after update" event in this text box to uncheck

I have a main form displayere list of employees.
I would like to open a second form to display the details of a selected
employee. How can I do that?
One way I am thinking of is pass the employee number as argument when open

I am upgrading a large .ADP application from Office 2003 to Office 2007 and
would like some feedback on the best way to manage Ribbons in Access.
I am in the process of converting all the old custom menubar/toolbar
functionality into equivalent/similar/improved functionality using ...

I wonder how can I avoid  (with VB), the warning messages that appear when I
execute update query’s.
I know that I can go to Tools > Options > (Tab) Edit/Find in Access 2003 and
just uncheck the three boxes in the Confirm section (Records changes,

I have a combo box that is unbound that I'd like to be able to update if
there is new data.
I was looking at Allen Browne's example - http://allenbrowne.com/ser-27.html
however I have a unbound combo box, would anyone know how I could make this

Is it possible to mouse over each choice in a combo box and get a
different tip for each one?
James

I would like to use one form for several different "offices" data entry.  
The value for the "office" is provided on an "Office Menu" form.  
Once the user clicks on their Office name, I would like the data entry
screen's background to be a different color for each "office".

I have a combo box populated from a certain column.  This box also
acts as the input box for a search function that i have updating per
keyup in a list box.  The problem is that I would like to retain the
auto-expand feature, but would like the text it is suggesting to be

I have a picture that I want to be embedded into a command button.  I can do
all of that fine, but when I go to resize the button, it cuts off the
picture.  I have tried using the corners to resize, which usually just makes
the image smaller.