I have built an education assistance database for tuition reimburstments. The
running total field I have on the data entry form needs to reflect how much
each employee has received in the current calendar year.
The school information, semester and dollars are in a sub-form of the ...

I open a form in dialog mode to add new facility to the facility table. This
table is the recordsource for a pull-down on the calling form.
How can I return the value of the new primary key to calling form?
Thanks!!

Access2007
I'm using form footer to make calculation to field in data sheet view form .
why to take the expression in main form (master form)
In the text box I put this expression (form footer)

Access 2007
I have query
I add 3 tables and make join between them
My question is:

I want to know how to create my MS Access report [tracking report] as Read
Only document. I want to convert the report to a Word doc, then save it as
"Read Only". I tried to save this before, but I received an error.... Can
someone walk me through it. I've made a copy of the ...

I have 3 checkboxes "Instrument", "Electrical", "Mechanical". Control source
data types are yes/no. I want to create automatic print out like if check box
"Instrument" and "Electrical" checked, put "I" & "E" in specific text box in
another form. Like (I & E). Can Access do that?

When I make changes to the data on my form which is based on a query, those
changes don't appear on my reports until I have advanced to the next record.
How could I apply those changes without advancing to the next record?
Thanks

Hello;
I need to know how to export an access report into excel.
Is there a link with sample code I can view?

I have a combobox that lists works of art by ID number (a number between 001
and 999) and name.  About 710 entries are listed.  The RowSource is:
SELECT qryArt.ArtID, qryArt.ArtName FROM qryArt ORDER BY ArtID;
The combobox's AfterUpdate event has code to display the desired data.  ...

Thank you
This message appear to me:
The SQL statement could not be executed because it contains ambiguous outer
joins. To force one of the joins to be performed first, create a separate

The value you entered isn't valid for this field
for example, you may have entered text in a numeric field or a number that
is larger the field size permits
this message appear for me on my (((Form))) when entering:

I have a frontend and backend database. With my desktop it is on drive D:,
with my laptop it is on drive E:
How can I catch the error message at start up "Tables not connected". This
happens every time I move the frontend between the two comps. I just want to

Is there a way to minimize access using a command button within a form?
I would like to be able to minimize the entire access application to the task
bar whenever a minimize command button  or the button on the top right of the
form is pressed.

What is benefit of relationship  window to me in access 2007??
Because I will use my Queries to  join my tables
I hope you understand me

Merry Christmas to all
I have 2 questions involving the KeyPress event:
1)  I use a numeric keypad that plugs into my laptop's USB port.  I have
programmed the '*' and '/' keys on the keypad to go to the Next or Prev