Message Box - Number of records

[jempie]

Using the TransferText function, I am exporting a table from access as a text file.

What I would like to do is have a message box appear showing the number of records that have been exported.

Can anybody help?

Thanks

 

[Bat17]

Use the dcount function after you run the transfer to check how many rows were transfered

MsgBox DCount("[YourField]", "YourTable") & "Rows Exported"

Peter

 

[jempie]

that's great, thanks!