Advertisement

02.06.2008 at 08:13AM PST, ID: 23141655
[x]
Attachment Details

Set Query caption through SELECT statement

Asked by InterCrownTech in VB Database Programming, Visual Basic Programming

Tags: Microsoft, Access, 2003

i have the following SELECT statement....

"SELECT PurchaseOrders_Detail.Product_ID, PurchaseOrders_Detail.Name, PurchaseOrders_Detail.Book_Price FROM ......etc.

This statement is being set in a list and will fetch the data from a query.
I want to have the fields, like Product_ID, Name, Book_Price.. appear with my own headings in the list.

Right now they appear as is... Product_ID etc. and there is no caption set in the query or the table so the the raw field name is displayed in the heading.

How can I set my own caption (heading name) by passing a SELECT statement to a list.Start Free Trial
 
Loading Advertisement...
 
[+][-]02.06.2008 at 08:16AM PST, ID: 20833220

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: VB Database Programming, Visual Basic Programming
Tags: Microsoft, Access, 2003
Sign Up Now!
Solution Provided By: bradleys40
Participating Experts: 2
Solution Grade: A
 
 
[+][-]02.06.2008 at 08:17AM PST, ID: 20833226

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.06.2008 at 08:17AM PST, ID: 20833227

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.06.2008 at 08:54AM PST, ID: 20833556

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628