I have two forms - a mainform with a subform on it.
Most of my code are on the main form, but I have startede to wirte
some code on the subform. In the code on the subform I need to call
some code from my main form. How can I do that ?

I'd like to automate printing a report to a pre-selected Acrobat pdf
file name. I've set the printer for the report to use the specific
printer "Acrobat PDF." When previewing the report, and selecting Print,
a popup box will always prompt for a location and filename. I'd like to

I would like to have a field on my form which will allow me to add "x" number
of days to a date in that form so that I can project when certain items
contingent on the date are to take place. Can I do it?

I hope I'm not wearing out my welcome here.  I've had some great answers to
questions and now I have another.
I want to add an "Add record" and "Cancel entry" button on a form so that
once data is entered into the form, the user must select one of the two:  

I am writting a macro that will delete, make a table and then append data to
another table for several tables. I unfortunately have to enter criteria on
for each of the make table queries that runs. The criteria is the same for
all the make table queries, beging date, end date ...

I am very new to writing macros ...sorry this is so basic.
I have two fields PatientID and PatientSuffix.  I want to combine these to
be field MemberID.  What is the proper way to write the sintax in a select
statment of a macro?

Is there a way within an access database to change Julian Dates into regular
dates? Any help would  be greatly appreciated

I have one form that is accessed from a switchboard that we want only a
handful of people to access.  We want just one password that those people
would know.  Users are not loggin in or anything.  I was going to build a
form which just one textbox for them to enter the password ...

For multiple printers and printer settings, can a macro be set up for each
printer and printer setting?

I am writing a macro that will be envoked on the command line:
winword /mmerge /q C:\file.doc
The macro merges a datafile with file.doc and then prints the filled in
document.

I have a macro attched to a command button. It opens up an eMail which a
person can either send or decde not to send. If the user 'x's out if he does
not want to send the eMail, they get the Microsoft ACTION FAILED message with
"HALT" button.

How do I create a message box to appear if the text box remains empty
(meaning user didn't put any values in it)

I'm trying to run a macro via a .bat-file (to make a scheduled task).
This is in my .bat file:
C: CD Program Files\Microsoft Office\OFFICE11 Msaccess.exe C:\Database\
AutoAlertByEmail.adp /x Macro1

When I open attachments, they often come up with Chinese letters.  How do I
fix this to read all in English?

In MS Access, it is possible to change the dafault format for fields in a
table that you create.  However, it is not possible to do the same for tables
that are created from a make-table query.  It is unclear why, in this case,
the default isn't simply "double".  If a field ...