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

[A.D.Tejpal]

Angelo,       My sample db named MotelBooking might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com         The form displayed on clicking of command button captioned "Status of bookings at a glance (Style 2)", showing dates across columns, demonstrates handling of variable number of columns. Adequate number of unbound controls are placed on the form, so as to cater to the maximum likely number of columns required to be displayed. Assignment of control source for individual controls is carried out in load event of the form.       Corresponding report with variable columns is also demonstrated.       You could adapt the underlying approach suitably, for your specific needs.   Best wishes, A.D.Tejpal --------------   ----- Original Message ----- From: Angelo Antonino To: AccessDevelopers@yahoogroups.com Sent: Thursday, November 17, 2005 10:33 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. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access training Microsoft access training course Microsoft access programming Microsoft access tutorial 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.