[AccessD] datatype underlying bound control

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





More information about the AccessD mailing list