pi********@hotmail.com wrote:
Yoiu mean you're deleting the tables completely and recreating them
from scratch each time? Why not just clear out the tables and reuse
them? instead of doing a DROP TABLE <tablename>, just use a delete
query with no criteria to delete all the records in your temporary
tables or whatever.
Thanks. That sounds like a better way than what I'm currently doing.
What I need to do is this: I have to have a report print in MS Word.
The powers that be want it in Word, and converting an Access report to
an RTF doc won't do because there are lines and a table that need to be
printed. The report will contain different data depending on
selections made by the user. A command button on the form runs a query
that fills tblReportData and opens a template in Word. When the
template opens, it pulls the data from tblReportData and populates the
report. Because the report data changes each time, I only need one row
in tblReportData. So the way I originally did this was by filling
tblReportData with
SELECT <data> INTO tblReportData FROM <tables>.
So I was not explicitly doing
DROP TABLE tblReportData,
but tblReportData was being deleted and recreated each time the query
was run. It seemed to be satisfactory at the time. Then I split the
DB, and the query created a new front end table while the Word template
was still pulling old data from the back end table.
So now I will try deleting all old data from tblReportData and
inserting new data for each new report. This is my first attempt at
creating a report in Word. If anyone could suggest a different/better
way, I will happily accept all suggestions.
Thanks again for the help.
Randy