RE: [AccessDevelopers] Displaying SQL Temp Table data on a form

[Angelo Antonino]

Thanks John. Unfortunately the columns can not be grouped on similar characteristics.   Angelo   thanks, Angelo ________________________   Angelo Antonino Tanzanite Software Solutions E: [EMAIL PROTECTED] W: www.tanzanite.com.au     -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:AccessDevelopers@yahoogroups.com] On Behalf Of John Ruff Sent: Thursday, November 17, 2005 7:37 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] Displaying SQL Temp Table data on a form   Why not use a TabControl and then group the columns on each tab by similar characteristics.   John V. Ruff – The Eternal Optimist J   “Commit to the Lord whatever you do,                 and your plans will succeed.” Proverbs 16:3   From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Antonino Sent: Wednesday, November 16, 2005 9:03 PM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] Displaying SQL Temp Table data on a form   Hi, I have an Access ADP connected to a SQL Server. I'm looking to dislay the results of a SQL Temp Table in a form. The challenge is the number of columns in the Temp table is variable. (could be up to 150 columns = but I don't what to impose a maximum number of columns to be displayd) To display the results of the temp table on a form, I need to somehow customize the form (or use some other control - flexgrid...etc). Can anyone offer any suggestions??? thanks, Angelo Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.