Created a macro to send a reoccourring report. I can use individual addresses
but it tells me it's to long ( 17 floks "Last name, First name") and that it
will truncate and does so cutting off the last 3. How can I "simply" have it
just use the Outlook Distribution List I created ...

Currently I run a month end macro which calls about 20-30 queries in order –
due to server issues this process can take up to 2 hours is there anyway I
can get Access to show a status box during this time? (a box which shows
which query is being run)

I need some assistance in created either a macro or command. I have a form
(Classes) that contains information about particular classes including "class
name" and "class date". I have created another form (Class Search) with a
selection list that shows all the classes with their ...

I have a problem with this function (TransferSpreadsheet).
Transfer Type :  Export
Type of Sheet : Microsoft Excel 8-10
....

I have 2 macros created which exports an excel spreadsheet to our server, is
there a way to run the macro and then send it through Outlook without having
to attach the spreadsheet?  It will be sent to several and this will be done
everyday.

I am trying to create a report that shows a series of events such that when I
enter the date for event 1, the date for event 2 shows up as 90 days later, i
have tried to use =DateAdd("d", 90, [FCLComittment]) as the default value for
event 2 where the field FCLCommitment is the ...

I am trying to use the Tranfer Text function in a Macro.  I have file
C:Test.txt , but when I run the macro I get the error msg - Cannot Update.
Database or Object is read only.  The file is a text file with the data in
the same order as the database.

I'd like to apply a macro to the toolbar command that allows users to send an
object as an attachment (in Excel).  I want the macro to essentially say:
"If Form A has the focus, then send Union Query A (not Form A, because it is
a continuous form).  Else, send the selected form."

I need a macro or code to print project reports in the order that the
projects are listed in a query (datasheet view).  There are four reports per
project and they need to print in a specific order - the problem is to print
each set of reports per project.  At this time the ...

I'm trying to use a macro in ofrm_Options to select ProjectName and therefore
open the frm_Projects form displaying only the selected ProjectName.
tbl_Projects = all Project data including field "ProjectName"
ofrm_ProjectSelector = ComboBox "ProjectName" (values =

On a form, I have a macro attached to a command button that saves the record
and previews a report.  If a field is not filled in according to the
validation rule for that field at the time the user clicks the button, the
Validation message appears and then the "Action Failed" ...

Original:  Is there a way to write a macro that will run a query and then
save it to a
server file and name it the date it was ran? The first answer gave me:
You can output the data returned by a query as a text file, using a

I have a need to test if a table exists in a current database system.  Is
there a sample of what I would have to code in VB via a function in a form to
determine if table named CaseNames exists in table named Legal_FR.mdb.  The
form would be the current active form and is part of ...

I posted the following question and was given the answer below,  new question:
Can it be saved as an excel spreadsheet or access table without it being a
txt file?
Is there a way to write a macro that will run a query and then save it to a

I asked this question on 5/18/2005:  
When a user checks a box on a form, I want to change another control to not
updatable.  More specifically, it is giving the user to specifically limit
(or identify criteria or range of data)  or  to select a check box to "select