Can I declare global variables in a Form's macro?

I have  these "Pairs Qty1", "Pairs Qty2", "Pairs Qty3" fields in my
table, I want to have the Sum of each of them in my report, My problem
is that the sum needs to be selected by depending a selected Supplier
name

I have set up a macro that pulls information from a query and prints the
mailing label and a welcome letter.  It works which is great but after each
report is printed the table data also prints.  How can I stop the table from
being printed?

I have a number would like to pad with leading zeoroes so that to make up as
3 digits string.
eg.
1 --> 001

I wish to update a date automatically in a form, after data has been changed.
I have tried to do as the link belows shows, but I am not having any joy.
I do not need the time just the date.
If anyone can write what I need & give me a step by step Or a link, I would

I created a database where I had a macro  bring up a msg box (Read this
message - click OK) and then open the form. I had another macro that when the
user clicked the close button on the form a msg box (Back Up Reminder) would
appear.

I have two seperate complex databases for completing month-end reports. Each
database has macros set up to print all the reports for that specific office.
I am trying to collate the printing jobs. For example: I want macro 1 from
database A to run, then macro 1 from database B, ...

I´m trying to do a macro for copy and paste based on query. I should copy a
value from a form field and paste in to a table field by using SenKeys
commands ^C and ^V. Everything else works (query, opening the form and the
table) but copy and paste does not. How can I do this, or ...

I enter indivicual projects into a database via a form.  I include the e-mail
address of the salesperson that sent the project request when entering the
project.  After the project is completed we send it back to the person that
sent it. At some point they are to respond back and ...

I am using 10 append queries to create a table and am finding a need
to manipulate the criteria for the queries (i.e. the day)  is there a
way for me to create a macro that will allow me to update criteria for
each query all at once?

I use the following command line and it runs successfully:
"C:\Program Files\Microsoft Office\OFFICE11\MSAccess.exe"
"c:\Data\Apps\Client.mdb" /x StartMacro
However,  In the Macro I have a Where Condition

I want Access to fill in a file number field similar to AutoNumber except
that I want to be able to change the number.  I just want it to look up the
last record and incriment by 1.  Then by pressing [tab] or [Enter] it will
accept the new value or I can type in a new value.  I ...

I'm trying to make a macro repeat.  What I actually want is to use the
'repeat expression' field, but nothing I do seems to make it run >ONCE.
Thinking I might not be stating the expression correctly, I tried to just use
'repeat count', but it still runs only once.  It's a very ...

I have a macro that I need to output a pivot table to excel however I am
getting the following error message when I run it: The command or action
"output to" isn't available now. Here is the VBA code of the macro:
Option Compare Database

I’m building a database of Work Orders. I have Form that have following fields:
Primary key- PM#-auto number.
Job Plan #
JP# Name