DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Jan 13 12:47:00 CST 2004
Who cares what the source is. If it shows in the form as SQL, then just open a recordset with that SQL. If it shows as a saved query, just open the saved query, etc. Drew -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Tuesday, January 13, 2004 12:34 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] datatype underlying bound control 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com