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

Thu, 17 Nov 2005 03:12:17 -0800

OK, but using the Tab Control and placing the columns on each tab, in whichever order you determine, is better and easier for the user because they don't have to look at 150 controls at one time.
 
I try to create forms where the user does not have to scroll up or down, nor left to right (with the exception of continuous and datasheet forms) to see the information on it. As a user, this is very annoying to me. So I use the Tab Control. I have less of an aversion to clicking a tab button than to scrolling up, down,  left, or right.
 
--
John V. Ruff – The Eternal Optimist :-)

“Commit to the Lord whatever you do,
and your plans will succeed.” Proverbs 16:3
 
-------------- Original message --------------

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



Reply via email to