I have a subform on a main form that has a command button that I wanted to
use a single click as well as a double click event.  I have VBA code for
both the click event and double-click events.  When I try to double click
the command button, I always go to the click event.  Is this ...

I have an edit form that I want to create a command button
on that will close the form and reopen it.  The reason
being that the form is run on a criteria query that asks
the user to enter the document number they want to

Doesn't a checkbox have a non-selected state?
I'm using a combo box to designate
"Please Select"
"On State"

I've seen on many books on access that access database cannot be bigger then
100Mb
I would like to get some more data about this limit like:
100Mb of data, limit of code, forms, ect...

I have a form with a subform. I want to put a Cancel command button on the
main form that undoes the data entered in the subform in the event that the
user changes their mind. I don't want to undo the data in the main form
though, just the subform. I have got round this by putting ...

I posted this question in the general Access area earlier, but maybe I can
get a better answer in this forum.
I am trying to format the back color of a text box in a form, based on the
value in another text box. If this was Excel it would be easier to use

How to automatically close a form upon opening another.
I have two forms, the first prepares data for the second form, and have the
same table.  The second form is opened from a control button on the first.
I would like the first form to be closed when that button is hit, if

after much uphill skirmishes (for some unknown reason) i managed to drop an
unbound combobox onto my a2k (switchboard manager/wizard generated) startup
switchboard.
the RowSource depends upon the values of a 'Registration' table as follows:

Hi please help! I have a "tours" table in which there is a field for pick up
points and times. I'm trying to get it so that the data for this field can be
inputted through a user friendly form, I'm unsure how to go about this
because I've been trying to do it using a combo box ...

I have created a form and subform with the wizard.  After creating, I created
a combobox in my subform with the wizard.  This combo box lists all products
available.  My goal is to use the main form "Quote" to create quotes for
variuos customers.  The subform is where all ...

I'm trying to remove records in one table that match those in another table.  
I have the following code but this seems to make Access 'Hang'.  Is this the
best/correct way of performing this type of operation?  Any suggestions
gratefully received!

Even the VBA debugger doesn't look to me so smart. Same to you?
Sometimes when setting breakpoints it "jumps" somewhere else....is it
normal?

First, here are some components of my database:
tblPersonnel contains many fields including- PersID (PK)
tblPersQuals contains many fields including - fldQual,
PersID (FK)

I have a field in a sub-form where I want to validate that the value they
enter is a valid record in a different table. I’m not using a drop down
because the list could grow considerably. I am enforcing referential
integrity through table relationships but I would like to ...

I have a button that copies the back-end to a new file and renames it.  At
first it would not work (unless saveing to root drive) because I didn't have
the "\" before the file name.  Now it will save to a folder only but not the
root drive.  How do let the user save the file ...