Issue with SetWarnings - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Issue with SetWarnings

Jerry Fowler

2 years ago

I have a database that I use to store info on your TechHelp videos. I have been manually entering the data. I re-watched Expert 24 about importing data off of an RSS Feed. ok, my issue is there are warnings about the import due to duplicates (photo 1) so I added the DoCmd.SetWarnings False as I have done for outer procedures., but I'm still getting the warning shown in photo 2. Any thoughts? Thanks

	Jerry Fowler OP @Reply 2 years ago

	Jerry Fowler OP @Reply 2 years ago

	Adam Schwanz @Reply 2 years ago
Is it still working, just the error is annoying? If so, you could just put On Error Resume Next at the top of the code

	Jerry Fowler OP @Reply 2 years ago
Adam thanks, that's so simple. It worked great and I can take the set warnings code out.

	John Davy @Reply 2 years ago
Hi Jerry I would certainly check to see what the error was. You may need to rethink what was NOT imported and modify the import routine. John

	Jerry Fowler OP @Reply 2 years ago
John, I did check the error and the issue is I have it set not to import duplicates and when I import there are always a number of items that are already in the table. But a very good thought if I hadn't. Thanks

	Richard Rost @Reply 2 years ago
Yeah, there's a big difference between a warning and an error. You're actually getting an error, so turning off the warnings won't help, but proper error handling does.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View