RecordSet in VB 6.0-VBForums
Results 1 to 3 of 3

Thread: RecordSet in VB 6.0

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Apr 2010
    Posts
    73

    RecordSet in VB 6.0

    Hi Guys,

    Quick question, im in the process of beginning a recordset procedure and im just curious can the following be done?

    Im aware you can use a recordset to open a database but what im looking to find out "maybe for an example if anyone is feeling nice" :/ say i had a main menu with loads of different tabs leading to different sections of the application etc and say one of the tabs were "invoice register" i would ideally like to just type "ir" and it finds the most relevant and then opens the screen? is that something i can programme in to the record set to do?

    Thanks in advance guys much appreciated.

  2. #2
    Freelancer akhileshbc's Avatar
    Join Date
    Jun 2008
    Location
    Trivandrum, Kerala, India
    Posts
    7,572

    Re: RecordSet in VB 6.0

    Welcome to the forums...

    You mean, you want to open a form and load data from the database, when you type "ir" in main form ?

    If my post was helpful to you, then express your gratitude using Rate this Post.
    And if your problem is SOLVED, then please Mark the Thread as RESOLVED (see it in action - video)
    My system: AMD FX 6100, Gigabyte Motherboard, 8 GB Crossair Vengance, Cooler Master 450W Thunder PSU, 1.4 TB HDD, 18.5" TFT(Wide), Antec V1 Cabinet

    Social Group: VBForums - Developers from India

    Skills: PHP, MySQL, jQuery, VB.Net, VB6, Photoshop...

  3. #3
    Super Moderator Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,334

    Re: RecordSet in VB 6.0

    Recordsets do not open databases.

    Connection strings and connection objects open databases.

    Once the database is opened, you may perform a query against a specific table, or tables, in the hopes of returning records stored in the database that match the criteria you used in your query.

    If there are records that do match your search criteria, then those will be returned to you in a recordset. From there you may manipulate those records as needed.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.