By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Suppressing popup message after a TransferText

P: n/a
Is there any way that I can suppress the message that pops up after
running:
DoCmd.TransferText acImportDelim.
I have the transfer text action on a form load so that every time the
database it opened it checks for updates. The problem is that our end
users don't really need to see how many records were imported. I'm
looking for a way to keep that message from showing. Does anyone have
any ideas on this??

Thanks

Jan 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Add this line before the DoCmd.TransferText acImportDelim
DoCmd.SetWarnings False

Add this line After the DoCmd.TransferText acImportDelim
DoCmd.SetWarnings True

Jan 13 '06 #2

P: n/a
Thanks that took care of it. That and it stoped creating a table for
the errors.

Jan 14 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.