I have a Macro which opens four queries, when it is
finished it leaves the last query open on screen.  I would
like it to close the last query and return to the access
screen (the screen from where I run the macro)

I have a set of reports/queries. There are date ranges on most of these.
These are used interactively to get reports between date ranges. I can set
the criteria to do the last month or week (and have a macro run and output
the data to excel for example), but then I can't ...

I have created a macro that filters data for different users. I have
also created a submacro, which is the following:
Sub macro1()
For MY_ROWS = Range("L65536").End(xlUp).Row To 1 Step -1

I have a new version of Access 2003 and transferred my Access 97 files. 3
macros will not work in 2003. 2 of these relate to the Export Word for
Windows Merge transfer text macro. Each time I run this I receive a message
'Cannot update. Database or object is read-only. However, ...

Howdy,
What I am trying to do is import around 30-31 text files in one hit,
currently I have a transfer text for each file. is there a way of importing
all files in one go rather the 30-31 transfer texts macro actions?

I have an AutoExec macro to download data when user open the database.
Because the macro append data to my local table, it always give user warning
message while open.
Is it possible that I set mute macro which may run the macro without popup

I am working on a laptop with too much security. The Admin group have
disabled the windows scheduler and do not allow installation of 3rd party
software. I need to schedule a macro to fire at a specific time every day
in access. I've searched the web but every scheduler I see either ...

I went to view/database view to create a macro for the first time.   I'm
getting a run-time error '2110' message which says that Microsoft Access
can't move the focus to the Control Option 1.

I have made a mcro that opens and prints a report. This works well but when I
use a command button on a form to run the macro, it prints the form as well
as the macro. Is there any way to get the button just to print the report?

I have a macro set up to export to an Excel spreadsheet, but I was wondering
if there is anything I can add to make it automatically enter a week ending
date?
I don't care if I have to use code or an input box or anything, just so long

I'm trying to open a certain word document with a macro from within Access
but I'm having some problems.  Can someone help please?
This is the command line I'm trying to use:
WINWORD.EXE "<Drive>:<Path with extension>"

Good day,
   I have inherited a very complex Access database that has a
plethora of tables, queries, forms modules and reports.  Within a few
tables are a number of data elements with names that include a space.

I would need to dynamically rename the tables with the user input
variables submitted by user via inputbox.
I tried approach from Excel, but syntax error has occured during
compilation in Access.

My team is working with a simple module that imports data from a Word
document.  We completed the module now we need to make it user friendly
enough for the masses to use.
We're attempting to create a simple command button to run the module, so I

I have a macro that copies about 6 or 7 large tables from an Oracle database
into a local Access db, using a series of MakeTable queries in the macro. The
whole set takes about 7 or 8 mins to complete. I am trying to show status on
screen, at least to show which table is being ...