Library tutorials & articles

Data Control

By James Crowley, published on 14 Jul 2001
James Crowley James first started this website when learning Visual Basic back in 1999 whilst studying his GCSEs. The site grew steadily over the years while being run as a hobby - to a regular monthly audience of over half a million unique developers. In July '08 James left his job as Head of Development at a digital agency in London to focus his energies on developerFusion full-time.
Page 8 of 11
  1. Introduction
  2. Viewing a simple database
  3. Adding and deleting records
  4. Editing Records
  5. Moving between records
  6. The BOF / EOF Action
  7. Finding the number of records
  8. Getting a fields value
  9. SQL Statements
  10. Using Bookmarks
  11. Finding Records

Getting a fields value

You can extract the contents of the fields by examining the corresponding properties of the bound controls. So, to find the value of the ISBN in the current record, you look at the text property of the bound control that displays that field (in this case, txtISBN). The following code displays a message box displaying the ISBN.

Msgbox "ISBN: " & txtISBN.Text

If you do not want a particular field to be displayed, but still want to get its value, set the text box's (or label's) visible property to False.

AddThis

Related tags

visual basic

Comments

  1. Bhasker Kumar
    28 Jun 2007 at 13:19

    Hi ! All,

    I'm new in VB Programming and trying with all your given examples. I'm trying to create a database project. I've created a table in Access 2000 and wants to attatch it with my VB Project. But whenever I run the Project it displays the following error message:

    Runtime Error # 3343

    Unrecognized Database Format

    Please tell me what to do now.

    Thanks & Best Regards

    From

    Bhasker Kumar

    Email :- bhaskerno123@yahoo.co.in

     

  2. Regie
    28 Jul 2005 at 08:27

    im a newbie in vb, im working now with the examples above, my objective is to save,add, delete files to the database i can't do it. there is a propmted error invalid or unqualified references.

  3. Regie
    28 Jul 2005 at 08:20

    i am a newbie in vb,and now im currently working with the tutorials that are post above, my objective is that i want to save, add or delete a file to my stand-alone database. thanks for fast replies.

  4. chandrababu
    28 Jul 2005 at 07:50

    At least give some explanation about the environment or
    what is you objective.

  5. Regie
    28 Jul 2005 at 07:35

    hi there, why is that i can't add or save new file? the error propmt is
    "invalid or unqualified reference." plz send me an answer or email it to me plz..hoping to hear from you. ASAP..thanks

  6. Sonic D Hedgehog
    04 Sep 2003 at 19:32

    The download link doesn't work...

  7. Chris Taylor
    28 Nov 2002 at 22:54

    I am currently having problems searching a dbase3 file using the data control.  Can anyone offer any suggestions as to searching?  I am using bound controls (testboxes) to display the data.  I can use the directional buttons to move forward and back but I cannot search for a specific value.


    Thanx in Advance

  8. kittiez1
    26 Jan 2002 at 13:34

    What is the table name?
    is it the recordsource or what?

  9. navinwest
    07 Nov 2001 at 06:10

    it's good control

Leave a comment

Sign in or Join us (it's free).

Related articles

Ask a question

Related discussion