UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> ColumnHeading    
 
   
azizrasul
post Oct 8 2007, 11:41 AM
Post #1

UtterAccess Ruler
Posts: 1,068
From: Faisalabad, Pakistan
I have a combo box on a form where the column headings are set to Yes. Is there a way placing any code which would allow different column headings to appear e.g. DrCode becomes Consultant ID, etc.

DrCode is of course the name of the field in the table. This and other field names come from a Oracle table to which I have no control over.
Go to the top of the page
 
+
datAdrenaline
post Oct 8 2007, 11:54 AM
Post #2

UtterAccess Editor
Posts: 15,974
From: Northern Virginia, USA
I would suggest to set your RowSource to a SQL Statement and use ALIASES as your Field names ...

SELECT DrCode As [Consultant ID] FROM tblMyTable

Then you column heads will show "Consultant ID" and not DrCode.
Go to the top of the page
 
+
NoahP
post Oct 8 2007, 11:55 AM
Post #3

Retired Moderator
Posts: 10,493
From: Lexington/Louisville KY USA
Do this in the RowSource of the combo box itself: instead of just selecting DrCode as the field in a particular column, use: Consultant ID: DrCode
Go to the top of the page
 
+
azizrasul
post Oct 9 2007, 03:57 AM
Post #4

UtterAccess Ruler
Posts: 1,068
From: Faisalabad, Pakistan
Thanks guys.
Go to the top of the page
 
+
NoahP
post Oct 9 2007, 01:17 PM
Post #5

Retired Moderator
Posts: 10,493
From: Lexington/Louisville KY USA
You are welcome!
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 23rd May 2013 - 10:03 AM