John W. Colby
jwcolby at colbyconsulting.com
Tue Jan 13 12:34:28 CST 2004
Drew, If the source is a complex query of 2 or 3 joined tables, how (other than parsing SQL text) do I determine the source table of the field? John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of DWUTKA at marlow.com Sent: Tuesday, January 13, 2004 1:05 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] datatype underlying bound control Yep, you can determine the field, and you can determine the source (that the form is bound too), so using those two pieces of information, you can open the source with ADO (or DAO) and determine it's data type. Let me know if you need help with the code. Drew -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Tuesday, January 13, 2004 9:18 AM To: AccessD Subject: [AccessD] datatype underlying bound control Is there any way to (easily) determine the datatype of the field that a control is bound to? John W. Colby www.ColbyConsulting.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com