I have an issue with my database at the moment. I have a form based on a
query which shows records where Approval Status = Null. What I want to do is
have a combo button showing the different statuses. Once a status has been
selected they would then click on a command button to ...

I am creating a database in Access 2000. I have sucessfully created a
switchboard using the switchboard manager and have formatted the appearance
to my liking. The problem I am encountering is with the properties of the
command buttons. It will not allow me to change the special ...

I posted the following on July 15:
Hi
I have a Master/Detail (form/subform) for Customer Invoices.  The
Master portion of the form contains the Customer info. Customer

I want to check my understanding about using Stephen Lebans' solution
for coloring tabs' background. I'm pasting his old post, as replying
to the thread wasn't allowed.
His sample database seems to have "Use Windows themed controls"

Currently i have two seperate querys via a form.
One querys info from the a network of offices and the other querys on an
office by office basis using a combo box.
I would like to combine this so in the combo box there would be an option to

Hello everyone and thank you for your time,
I have a simple form with a subform with a CANCEL button on it.  The
problem is that if I don't use the DoCmd.Requery command, the form
advances to the next record even though the previous one was still

had a combobox set up via wizard (Access2003) that worked fine in selecting
the record to be shown in the form.
came back recently and found it not to be working...
The only code in the AfterUpdate event is what the wizard supplied:

I am getting the error message "The field is too small to accept the
amount of data...."
I know what is causing the error, but I can't seem to find a way
around it.

Ill try and explain this as best I can.
I have a form with a subform, the subform contains all the data, the main
form is used as a connection link.
On the subform I want to create a cumulative total specific to the project

i want to create a form with two combo/list boxes.
The first one will select a particular office, the second will depend on the
first and will show the employees for that office ONLY!
At the moment i can only get it to show all employees

I want to write a validation rule ensuring that the number in Field2 is
greater than the number in Field1. The problem is, both can be null.
How
do I write the rule so that Field1 can be null? Simply writing ">[Field1]

Can anyone help me please? i am trying to open a .CHM help file via a
command button on my form.
I have tried using SHELL but that doesnt work, presumably because it
is not a .EXE.

I have this check box...then I only want them to insert data when the check
box is being checked and not just click.
May I know how to code the line?

Dear All...
I wish to open a form for data entry, with the form containing a text
box for each element in a table. As the table changes in size over
time (usually bigger, not smaller) I require the new additions to be

Everyone,
I have a form which is bound to a table.  There are about 10 fields on
the form, and my users would like for all but 2 of the fields they
enter on this form as part of a new record to persist on the form