I have a combo box that is set for a not in list event if the customer that
the user types in isn't in the current db.  When the not in list event is
entered the user is presented with a message if they want to add the user?  
If they respond yes the I bring up the master input ...

i want put my pictur on internet

I have an unbound subform that for some reason gets reloaded when the main
form is requeried.
Has anyone else experienced this problem?
The DB was converted from Access 2003 where this problem did not occurr. The

I have a database set up with Construction Equipment for a large construction
fleet.  Each piece of equipment is assigned an equipment number and that is
how it is stored in MS ACCESS.  If you want to know something about a piece
of equipment you pull it up by equipment number.  ...

How do I make availible mulitiple selections in an option grouping using
check boxes with out having to do them all manually?  Can I just change the
properties after the wizard builds the group?

In Access 2002 I could right click the darken square in the upper left then
pick properties, then source to see the querry.
How does this work in 2007?
Thanks

I am using MS Access 2000
I have a table that has several required fields.
I developed a form to add records to the table.
In addition to the table fields, the form has a form-close button

I need a solution to calculating a pre school students age in years
AND months as at start of school year.  I've found a formula below
that works out the age in years, but can't quite nut out how to do
the months.  I dont care if I display it as a second calculated field,

At the moment my mdb (Access 2002) opens onto the inbuilt switchboard and
menus.
I would like to introduce a different form upon startup, which is no problem
in itself, I know how to do that.

How can I get rid of all menubars.
I can remove them temporarily by 'Tools/Customize' and tick off all
menubars but when I restart MyAccess.mdb one menubar is still there.
What command should I use on Form_Open to eliminate all Menubars.

Hello.  I have an orders form that contains customer id, order id and
order date and it's control source is the order table. This also
contains a text box for order subtotal, sales tax and order total.
I have an orderdetailsubform based on the orderdetails table that

I have a form that creates new records.  As soon as I begin to populate
fields, the AutoNumber is assigned for the new record and is displayed on the
form.  
While populating the form for this record, I want to use the AutoNumber

I have a tab control with 5 pages.  When I'm on the first tab page, if I use
the nav buttons to proceed to the second record, I want a user to remain on
that second record if they click any of the other pages.  Currently, if I've
gone to the second record and clicked another page, ...

I am following Allen Brownes code from this page http://allenbrowne.com/ser-57.html
to copy duplicate records with child fields.
I keep geeting a Run TIme Error 3146 ODBC Call failed at the  .Update
command in the code. ANy ideas?

I have a form I have created that will print out on an 8.5 X 11 paper the
top half of the form -- the part I want to fill in --  is an exact duplicate
of the bottom half and I want the bottom half to be fill in as the top half
is, automatically.  I know how to do this with cells ...