Drew Wutka
DWUTKA at marlow.com
Fri Oct 24 16:08:46 CDT 2003
Even easier. Just dump it into a table, and sort the table any way you please! I have used it. I wrote some code to 'create' an Access Form in HTML version. To make it complete, it had to create VB code to interact with it, which required the use of the recordsource for each control. I had the recordsource dump into a table, for easier referencing. Drew -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, October 23, 2003 8:06 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] list every field bound to a control LOL, yep too easy. I was hoping for someone who actually used it. I need it sorted so I can find things in the listing. I can whip out what you wrote in about 5 minutes. Sorting is another matter. I actually have a sort I wrote one time that sorts stuff going into a collection. Guess I need to dig it out. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka Sent: Thursday, October 23, 2003 5:14 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] list every field bound to a control That's easy. Dim ctrl dim strTemp strTemp="SELECT " For each ctrl in Me.Controls if isnull(ctrl.ControlSource)=False and ctrl.ControlSource<>"" then strTemp=strTemp & ctrl.ControlSource & ", " end if Next strTemp=Left(strTemp,Len(strTemp)-2) Now, if you have unbound controls, that code might act up a bit, so you would need to nest the If then statement in another one that checks the types of controls (either ignore the controls that can't be bound, or specify those that can). Drew -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, October 23, 2003 3:49 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] list every field bound to a control I have a form that the user wanted hundreds of fields from half dozen tables displayed on tabs. I just used SELECT * during design because I didn't know what they would want and what they wouldn't. Now it is done and it's time to clean up, not pull more than I absolutely need etc. One tabbed form. John W. Colby www.colbyconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Drew Wutka Sent: Thursday, October 23, 2003 3:15 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] list every field bound to a control Clarify. Is this for a particular report or form, or for every control on everything in an entire database? Drew -----Original Message----- From: John Colby [mailto:jcolby at colbyconsulting.com] Sent: Thursday, October 23, 2003 12:50 PM To: AccessD Subject: [AccessD] list every field bound to a control I need a utility to list every field bound to a control. Has anyone ever written such a thing? 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 _______________________________________________ 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