Alternative to MS Message Boxes

[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.

 

[Rob Parker]

This might be a good starting point:
http://allenbrowne.com/ser-60.html

Use the Execute method to run your action queries; save the Records.Affected
value to a variable (for each action query), then display them in a
messagebox at the end.

HTH,

Rob

 

[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.

 

[John Spencer]

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