I want to create a create a table macro; that would create a table within a
form with user entered column x row size.
For example
if th user enters 2x3 than the macro will create a table in the form a size

I need to run a macro when the tab (Sheet1) is selected, as opposed to
getting a user to "Click a button" - any suggestions how this can be done?

Everyday, I get a file with a list of items and thier prices. I have
to format it several times for different regions, but with the same
data. How would i create a macro to automatically copy the same data
to the four regions.For example:

I have an assignment whereby I need to open my database automatically by
creating an AUTOEXEC macro?
Can someone give me a hint as to how to accomplish this please?
Regards

I have a large Access DB.  I want to create a macro to create a compressed
file of the DB (I would ordinarily right click in Explorer: Send to
Compressed (zipped) Folder) and then send the compressed folder to an FTP
site (with password protection).  Is there a way to do it ...

I am setting up a macro to run a query that finds records, and copies them to
another table.  I want to have the user select which records from the
returned set to copy.
Anybody know how to do this?  

I am concerned about a user who is editing or completing a form being able to
use  their mouse to scroll through other records before they are finished
with the current record. I am worried they will inadvertently change
something in the wrong record.

I have created a database and now I have been asked if it's possible that
once an entry form has been marked 'complete' to purge it into a query.  I've
looked for a command, or something similiar, but it seems the 2003 version is
limited.  

Good day,
I am working on a database that keeps track of checks (checks are composed
of a "Symbol" and "SerialNo") and how many times that particular check has
been requested.  I created a form "CheckHistory" that shows me the Check No

I've had the same situation come up several times when I've developed a macro
to send a report (an appointment list in snapshot format) via email. It will
work fine - perhaps for months - and then somehow change from sending a
snapshot format to sending in *.xls format. The *.xls ...

I have a table called landlord and archive of the landlord table. I created
append query to retrieve one record from archive to landlord through using
[Please enter landlord ID] in landlord ID field criteria and a delete query
to delete that record from the archive.

I have created a database and now I have been asked if it's possible that
once an entry form has been marked 'complete' to purge it into a query.  I've
looked for a command, or something similiar, but it seems the 2003 version is
limited.  

I am using MS Office 2003 and I need to create a macro in Access that links
to an Excel workbook.  I haven't used macros in Access very much and am not
sure if this is possible through a macro.  I would like to be able to do this
so that my users could just click a button and the ...

I have created a spreadsheet with totals on it, the total is a formula
in cell J25, what i am trying to do is each time the total goes over a
limit of £5k, i want a message box to appear and say somethinkg like
seek more approval, also is there a quick way to archive data from a

I'm trying to write a macro that compares 2 addresses to see if they are the
same or not.  We generate letters and do not want to send the same letter to
the same address.  If the address is the same, I want a message box to appear
telling them that they already sent a letter ...