I have a query that is presented in a form.  I'd like to be able to click a
button on the form and it would automatically enter all of the email address
of all the contacts on that form into Outlook.  Can anyone help me do this?
I would also like to be able to Fax to these contacts ...

Can you check if an table object exists within a macro, and only it it does, delete it...if it doesnt exist, then just ignore it
THANK YOU ANYONE!

2 Issues I can seem to find any guidance on:
1. I have a macro with a series of TransferText (export
to .csv) Actions, say 4. They all use the same Export
specification. I would like the user to be able to run

Can anyone offer me any help on this function.
I can get it to run with out any errors but it doesn't seem to b
creating the DSN.
******************

I would like to use the OutputTo action to automate a
series of exports I do each week. However, I need comma
seperated values, and no text qualifiers. Is this
possible? Ideally the files are .csv, but I can just

I recently upgraded Office (Access and Outlook) from 2000
to 2002. I can send an email message with an attached
report from Access with no problem. I have some macros
that run overnight that email reports using sendobject.

I am working with Access 2000 on Windows 2000.
I have a very simple report that is tracking incidents.  I am using a memo
field for 'Description'.  In the report the Description field is set to "Can
Grow".  When I run the report I can see all text that was entered into the

My database is due to be finished tomorrow...
However, one small problem, I want my records to show in backwards order, so the most recent one is shown on the form first.
My primary key is Call No and when the program is opened I want it to show Call No 500 say, and scrolling ...

Good morning,
I'm in Access 2000 and have a Macro that I've setup to run OnClick on my main form.  My users will access the database form via Citrix / Thin Client, however the database itself is on a common area fileserver.  The macro calls up the command to go to User and Group ...

Does anyone know of a way to check a table name?  I do a
lot of work at home and transfer databases back-and-forth
so I have to rename tables for testing (don't have access
to the live data so I import the data tables for testing).

every now and again I need to link tables to sql they come through with dbo_
and then the name I then have to manually rename the table, easier than
changing existing code.
Can anyone please tel me how I can maybe change the name of the table by

Have a list box that I'm trying to populate on an Access 2000 form. Created
in XP version as 2000 format.
When run in computer with Access 2000, I get an error that the .AddItem
method is not supported.

Just another quick question.  Is it possible to run an Access macro from an
Excel spreadsheet? (Using Office 2000)
many thanks
Neal

I have 1 form in continuous forms view that I would like to have a user click
on and have it open another form to the record the the user just clicked.
I created an openform macro with the following SQL Where Condidtion
[studentid]=[Forms]![frmcounselorselect]![studentid]

I am trying to create a macro that will send a message to
all the people that currently have my database open to
tell them to close it.  I can create the macro and it
will only show up on my computer.  If this is not