Wrox Programmer Forums
|
VB How-To Ask your "How do I do this with VB?" questions in this forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB How-To section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 25th, 2005, 08:37 AM
Authorized User
  
Join Date: Mar 2005
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to akash Send a message via MSN to akash
Default CAPTION OF ACCESS DB IN VB
I am to know the caption of the field name of Access Database. I want to use that caption in my VB program.

Pl. Suggest

Akash
 
Old April 25th, 2005, 09:06 AM
Authorized User
  
Join Date: Apr 2005
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to EricJ
Default
Be more specific please! You want to use the caption from Access in you VB project or something similar?
 
Old April 25th, 2005, 10:17 AM
Friend of Wrox
  
Join Date: Nov 2004
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default
Field names don’t have captions...
 
Old May 8th, 2005, 05:41 AM
Authorized User
  
Join Date: Mar 2005
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to akash Send a message via MSN to akash
Default
In VB6 I have to show the list of fields (database is in MS ACCESS) of one table to the user. Instead of field name I want to show the caption so that it would be more user friendly.
 
Old March 8th, 2007, 09:20 PM
Registered User
  
Join Date: Mar 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default
hi akash, since I very new to vb , I don't know searching a record in a MS ACCESS table. I need to learn it quickly to submit my project.
Can you help me by sending the all vb code for "serching a record entered by user at run time in table"
please Hurry up! Waiting 4 ur reply????
 
Old March 8th, 2007, 11:01 PM
Friend of Wrox
  
Join Date: May 2006
Posts: 643
Thanks: 0
Thanked 0 Times in 0 Posts
Default
Believe it or not, guyes, in Access a field can have a caption. This is not directly accessible through SQL as far as I have ever seen.

It is possible that ADOX might give you a way to get at it, but I would be looking for alternatives that don't include trying to use the caption.

Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems





Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VB : How to change Label Caption papanchal Excel VBA 1 September 22nd, 2008 04:46 PM
Can I open access DB stored in CD from VB Andraw Pro VB Databases 1 August 14th, 2008 10:05 AM
VB.Net - Access DB - Date compare johneecc VB How-To 4 August 7th, 2008 04:23 PM
How to connect to Access db thru VB.NET? am_kuthus Visual Studio 2008 1 June 3rd, 2008 04:48 AM
Connecting VB Proj to a local Access DB jpaulptr Access VBA 0 May 27th, 2004 12:30 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.