Alternative to MS Message Boxes

  • Thread starter Thread starter GLT
  • Start date Start date
G

GLT

Hi,

I dont know if this is practical or not, but thought it might be a nice to
have.

I do three imports, and one update query, and two delete queries all in the
same code.

I have set warnings to false (and then turn it back on again) to stop all
those generic prompts. Is there a way I can still capture this info, and
then display it in a summary page or just in one message box?

Its not a critical thing but would be a nice to have...

Cheers,
GLT.
 
Hi Rob,

Thanks for our your advice it was exactly what I wanted - thanks to Allen
Browne as well :).

Just wondering if it is possible to so the same when importing records via
the transfer text commands, eg:

DoCmd.TransferText acImport, "ImportCompare", "tbl01_FullCompare", getFile
DoCmd.TransferText acImport, "ImportServices", "tbl01_Services", getFile1

Cheers,
GT.
 
I don't know of a way other than getting the record count in the table before
the import and then getting the record count after the import and then
calculating the difference. Of course, if the tables are cleaned out before
the import then all you really need is
DCount("*","tbl01_FullCompare")

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top