Access - Publish report to word and save

[Leroy_Brown]

I have an access 97 report that must be closed as the table it is based on must be deleted. However, I would like an input box to appear asking if they want to save the report.

Therefore, I would like to (In code) publish it to word and save it.

Any thoughts?

[Hack]

Why delete the table? Why not just delete all records in the table, thus maintaining the relationship between it and the report?

[Leroy_Brown]

You're absolutly right. Wish i'd thought of that. However, project is done with the exception of this and it would cause way too much grief to go back and change.

[Leroy_Brown]

I am going to cave and do what you said. Is there a command you know of to dump a tables contents? The only way I know howw to do this is deleting every row of a recordset but there has to be a more efficient way of doing that......

Any ideas??

Thanks a bunch

[Hack]

Dim SQL As String
SQL = "DELETE FROM tablename" 
dbobject.Execute SQL