[AccessD] datatype underlying bound control

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


More information about the AccessD mailing list