473,473 Members | 2,026 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

how do you add column heads to a list box?

5 New Member
I'm calling a external database and populating a list box, this part works just fine. I want to use the query column heads as the list box column heads. Because the list box is in Projects the RowSourceType will not accept Table/Query. The objField.Name will give me the names of the column heads, but I don't know how to get them into the listbox column heads. Any body have any ideas?
Jul 11 '14 #1
2 1149
twinnyfo
3,653 Recognized Expert Moderator Specialist
Have you tried setting the list box ColumnHeads proerty to True? That will allow you to display column heads.
Jul 11 '14 #2
tomric3589
5 New Member
Yes I have, no go. This database is opened up through an ADODB connection, and the query is ran through that.
Jul 11 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Darryl Kerkeslager | last post by:
Access 2002 on Win98 at least, not tested elsewhere: Bug: The ListCount property of an unbound listbox may be incorrect if you use column heads. Model: Set up a simple database with two...
9
by: Bob Alston | last post by:
I have a drop down combo box that gives the user to enter an item not in the list by adding it to the list. The list is a table. It works fine on Access2003 but fails on Access2002/XP. ON XP, it...
2
by: Aravind | last post by:
Hi guys, Is there any way to access the full column form a table into a List Box..If you have some samle codes ..plz forward them..thats very useful for me to refer.. Thanks in Advance,...
3
by: Randy Harris | last post by:
With a multiple column listbox, I'd like to be able to change the sort by allowing the user to click on a column. Is there a practical way detect in which column the user clicked? I know this...
0
by: JJ_377 | last post by:
I am trying to populate a two-column dropdown list from a populated datareader (dr) having two fields from the Categories table of the Northwind database: CategoryID and CategoryName. I've used...
4
by: Tony Toews [MVP] | last post by:
A client asked why some code behind a list box suddenly started updating 57386 records in a table instead of the expected 38 records. Turns out the problem is a difference in behavior between...
6
convexcube
by: convexcube | last post by:
After searching the web for a solution to total a specific column in a list box and not finding it, I came up with this: Dim varTotal As Currency Dim varRow As Integer For varRow = 1 To...
1
by: TravelingCat | last post by:
Hello, I'm wondering whether it's possible to not show one specific column's heading in a listbox, does anyone know? My column heads property is set to yes, but there's one column, ordinal number,...
2
by: sarah2855 | last post by:
I have a listbox object and I have it bound to column 7 which is orderID. but I don't like order Id to be shown in the listbox. I only would like to see the name and property of that order. Can I...
6
by: Mihail | last post by:
Hello again ! Is it possible to have custom Column Heads in a ListBox (ComboBox) ? I have a ListBox bounded to a table (if necessary I can bound it to a query). One field (or ListBox column)...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.