I really have several questions that are related to accessing and
manipulating queries.
1. I would like my user to be able to
(a) open the Query Design window from a modal form,

If I change data on one page of tab control and move to another page
Form_BeforeUpdate event occurs and actually change does to database.
Why is it happened?
Thanks

i want to use a combo box in a form to select records eg
list of part numbers in the combo, description of the part; customer;
location etc
so i want to select say part number 1000 i want the other boxes to bring up

This is driving me crazy!  I'm collaborating with another party on a database
app in Access 2003, and the  forms he created are viewable in the design
view, but not in the  form view.  I get an error saying that the path is not
valid.

This is an Access 2003 Issue:
One of the fields in my table is a date type field. The user will input the
Month and Year only (no day in other words).
So the format is currently set to: mmm yy

I try to make a form and when i put the finish button from Command buuton
wizard i take the message that  Microsoft Office Acces failed to create the
Visual Bacis module...What happen? Also i have already create a command
button(An exit button) from wizzard, without any problem such ...

I'm using Access 2003.
I have created an invoice whereby when a product code is selected from a
combo box other combo boxes on my form are populated including unit price
based on the product code selected. I want to be able to multiply unit

I first have to say thtat I am fairly new to access and am a quick learner.
I still have a few problem I have to try and get working in my very first
database.
I have a main form called TimeCard where my fields are;

There are two buttons on form that both open the same form.
One opens correctly, second produces the following message:
"-2147352567 There isn't enough memory to perform this operation. Close
unneeded programs and try the operation again."

I want to obtain a sum of values in a field [AmountRecieved] on my subform.
I can do this correctly by placing the following  =Sum([AmountRecieved]) in
the controlsource [Text16] of an unbound field on my subform.  Next, I can
get it to return the correct value after I refresh ...

The datasheets do not update when the underlying data is changed in Access.  
How do I get the datasheet to requery the data and update?

I'm playing with conditional formatting in a report. I've got a one
character field that is properly changing color if the value is "A".
Unfortunately, as one character it doesn't show up real well. Is there a
way to change the color of the entire line (record) based on the value of

I am designing a database for an automated audit program which is currently a
paper based system and wanted to get some feed back to determine if I am
heading in the right direction.  My database will have two main tables.  The
first table will have the audit reference #(primary ...

I have on a form a list box named    MultiDomaine
It contains around 100 records (from a table)   I select let say 15 items
then I print the report.  After I have to select 9 other different items for
another report so I would like to have a button that would reset the list

I am using Access 2003. I have set a field to be a percent with two decimal
places. In the form when I input 10 (aka 10%) it comes up as 1000.00% so I
input instead 0.1 and it comes up as 0.00% versus 10%. I multiply this
percent field times a subtotal field to get a discount rate. ...