Overtime, I have created 3 Access DB (each with separate uses and information)
which require updating. I have also written VBA behind a button in each DB
which to automate the update procedure.
I instead of having to open 3 DB each time I would like to be able to start

I am using a Word mail merge template using my access database (2003) and
then calling the new document with the merged information back into access to
tell it to print. I have had to use the ActivePrinter command and switch from
one printer to another. This part is working good. ...

I have a form that were i want to detect when the user presses the ESC key
in order to perform some background operations.
Is there a way to do this?
Thanks.

I have a query in which I want to create a pivot table in excel. When I try
to open the db in excel I receive an error Syntax Error [missing operator]
Query 2.1998.Doc Type
After looking at the SQL coding I wrote in access there seems to be no error

Hello to everybody and thanks for your time and help.
I have a database witn around 30 tables linked together. That makes a lot of
tables and uses much space in the relationship window. A lot of my tables are
out of sight and I use so much space I can't even print the relationship ...

I have a command button located in the form [IHS to Categorize] that I am
trying to disable when the form [DistinctMSNNum]  returns null for the record
[MSM Number]
If I try it with a record of the [IHS to Categorize] form it works but not

I have a field that will automatically store first initial last name of the
user.  I want the data formatted so that the first two letters are always
capitalized.
i.e.

I am using a combo box to lookup employee information stored in a LARGE
table.  This combo box autofills numerous items on my form and gives me
information about the selected employee.  This is the code I am using on the
combo box:

I have the following code in Access that is used to open an Excel file, do
some work with that file, then close the file and the Excel application.  
   Dim xlApp As Excel.Application
   Set xlApp = CreateObject("Excel.Application")

I insert 5 pages in a Tab Control object. I want an event action when the
mouse clicks on a specific tab. Here's the code...it doesn't produce
anything...
-----------------------------------------------------------------------------------------

I have an Access front-end running input screens, etc for some linked SQL
tables. Is there a way to populate a field on an input screen (setup as a
form), to the last value entered for the previous record?
Thank you in advance!

I am working on a database that we use in the office to assign task to
everyone in the office. I want to be able to have the database auto send the
notification.
There is a table that I had build that have Name and Email inputs for each

I need to check to see if strPhone is a phone number with this format:
xxx-xxx-xxxx
It has to be this way or it won't work in the code further down the line
(which I can't change)

Hi again!
On an input screen (set up as a form), is it possible to only make certain
fields accessible based on another field. e.g. I have a field for department,
and depending and which department is selected other fields must be enabled /

Is there any way to trap the key combination Alt + P during Print Preview.  
I've created my own custom toolbar and menu bar and would like to be able to
disable the Alt + P combination during print preview.
Thanks in advance!