Send Object

I

Ian Stoddart

I have a maco within an Access 2002 db that contains the
following actions -:

1. Run SQL x 2 (clears all records from tables)
2. TransferSpreadsheet x 2 (populates tables)
3. SendObject x 5 (emails results of 5 Select queries)

The macro works fine, though on a number of occasions it
wipes out a couple of my queries. If I look at these
queries in design view they have become completely empty.

Has anyone else encountered this?

Regards
Ian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Object Dependency Tracking 4
How to join 2 sumarised data sets 2
How to populate VBA Variables from ADODB.Connection Results? 4
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
group by query bound to check box error msg this record is notupdatable. 4
Stubborn Array won't Populate from single ADODB.Connection Query 4
Blank shows in combo when there is an excluded record 2
Help? I need help in making formulas work to accomplish... 0

Top