Is there a way to save the form from run mode when the form is closed
(hide the prompt asking yes, no, cancel).
Thx

I have a continuous form that has 5 fields the user inputs numbers in the
first 4 fields, then the total of the fields for that record goes into the 5
field.
How do I get the total for those fields for a single row to auto update the

I have a subform that is in a continous for view.
There are 4 fields that the user inputs numbers for each record shown.
On the footer of this subform I have 4 unbound text boxes that I am trying
to put the total entered for each field every time the user adds data to

Is there a way to align the text that appears in a table heading. It seems
the default alignment is centered. Is there a way to have them default to be
left aligned instead?
I tried aligning my subform's label headings in Design View, but in Form

Using the Outlook MailItem object, I can format my email as desired and
.Display to popup the Outlook mail editing window with the appropriate
contents. There are three problems though:
1) I get those annoying popups due to the Outlook security patches

I need to be able to generate a report by date, or better still by month. I
am setting up a loan application tracker and need to display loan settled for
one month at a time.
Can anyone help me with this???

I have a standard tab contol on a form. I would like the font for the
selected page to go bold when the user selects it and the other non-selected
page font to not be bold. So the selected page caption would always be BOLD
and the other normal.

I'm quite a newbee, so please excuse me if I ask something that's very
obvious to you ;-)
Right now I've made a Word-template, in which data is retrieved from an
Access database using ADODB. The queries are defined in Word, and this is not

I am using:
Private Sub Form_Dirty
Me!FieldName.Value = Now()
End Sub

I'm running Access 97 in a mixed Word 97 & Word 2003 environment, and using
OLE automation to transfer data from Access to Word. In order for this to
work I need a reference to "Microsoft Word X.0 Object Library" where X=8
(for Word 97)or 11 (for Word 2003). I know how to set ...

I have a form based on a table that has a field where the user enters their
name from a drop down box. What I would like to do is after the user chooses
his/her name, the field locks out any changes. Is this possible and if so
where do I start?

I've read thru countless threads, but I can't seem to get my code to work.  
My office handle hundreds of correspondence, only some of which get filed.  
While I can easily use autonumber for each piece of paper that come thru, I
need a meaningful number for my file system that is ...

I need help with connecting 2 combo boxes. Depending on what is selected in
first, second one should give different list of possible selections. I also
want to force users to select something in both combo boxes.
Records for these combo boxes are in 2 different tables conneced ...

Environment: Access 2000 .mdb
I have a main form with a couple of subForms. The main forms’ data source is
a table.
tblMyTable

I get a message "You Cancelled the previous Action"
with just an OK button. It keeps popping up many times.
Then i get a message "Module Not found"
I can't open my form in design mode or normal mode.