Charlotte Foust
cfoust at infostatsystems.com
Tue Jul 1 11:58:02 CDT 2008
The query can't run if you have missing pieces in it, whether or not you could turn off the error messages. Your Union SQL needs to be valid right now in the current datastructure, regardless. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of CHERMOSHNYUK, ANATOLIY Sent: Tuesday, July 01, 2008 9:09 AM To: Access Developers discussion and problem solving Subject: [AccessD] Turn off error message I am running union query that has some elements that are not currently in the database but might be added in the future. Since query cannot find them it is prompting several error messages. I tried to turn off warnings in Macro that runs these queries, but to no effect. Any ideas how to turn off these error messages? Thank you -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com