Avoid warning message when importing email-addresses from Outlook.

[Anders Berlin]

When trying to import email-addresses from Outlook 2003 into Access 2003, I
get a warning message every time. I have to manually allow the
email-addresses to be imported for 1, 2, 5 or 10 minutes.

This can get quite annoying and time-consuming in the long run. Is there a
way to turn of these warnings?! Either in Outllok or Access (through the
VB-code)?

 

[Roger Carlson]

Try bracketing your import code with the SetWarnings command:

DoCmd.SetWarnings False
' your import code here
DoCmd.SetWarnings True

The only problem is that is will suppress ALL system warnings. This may
cause problems if other errors happen.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L