?
Solved

USING MULTIPLE ADO RECORD SETS ON MAINFORM

Posted on 2004-09-07
3
Medium Priority
?
205 Views
Last Modified: 2010-04-17
Have 1 form, on form textblocks for DriverId,name,street, etc.. for this data adorecord set,
second adrecordset contains table with licenseplate numbers belonging to a DriverId,
then a third adorecordset contains table with list off accidentreports belonging to DriverId.
What I trying to figure out:
In DriverId txtbox e.g. looking for JACK-01, start typing in J,A,C,K  etc. how to let datagrid
at same moment scroll while typing letter J/A/C/K etc to postition in grid on screen.
So if more JACKS exist they show on order etc.
Then when I pick e.g. JACK-01, how to make call (in record JACK-01  I have key for both accidentreport and licenseplate)  how to make call to second recordset with key and same
for third.
Regards Jack
0
Comment
Question by:BIAPRO
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 19

Accepted Solution

by:
arif_eqbal earned 1000 total points
ID: 12003340
I hope you are using VB

First problem:
In order to show relevent names as user keeps typing trap the change event of the textbox where user is typing JACK...
on the change event filter the recordset with whatever has been typed so far and populate the grid
However this might slow down the Interface a bit, a better more elegent solution is to have all IDs in a comboBox, user can select from it also you can easily implement autocomplete type of feature in combobox so that as soon as user types Jack, Jack-01 comes automatically on the press of a character that makes the name unique like in unix.

Second Problem:
Here also the same solution, filter, your other two recordsets must be containig the key field DriverID you need to filter the two recordsets based on the driver id
AdoRecordset1.Filter="DriverID='" & TxtDriverID.Text & "'"
then show the records
0
 

Author Comment

by:BIAPRO
ID: 12053706
Ok based on your info I did this.
Only one problem left ,  the records start at  AB-001  untill ZZZ-9999
in file 30000 records,  so when I start typing e.g.   NIC-123 grid scrolls
ok to first found but if I make type error like NIX- and do backspace
grid is not scrolling  backwards because it passed that row already
How to make it scrolling backwards  specialy if you would go like back to N
or even back to nothing and want to start with e.g. BA  etc.
Ok clicking op adocontrol <<  would solve but thats not sofisticated.
Regards Jack


Private Sub TxtCustomerSearch_Change()
Dim Count As Integer
Dim LastRow As Boolean
On Error GoTo ErrHandle:
    Count = 0
    Do Until LastRow
        Customgrid.Row = Count
        Customgrid.Col = 1
        If UCase(Mid(Customgrid.Text, 1, Len(TxtCustomerSearch.Text))) = UCase(TxtCustomerSearch.Text) Then
            DisplayFields
            GoTo endSub
            End If
       Count = Count + 1
    Loop
    Exit Sub
   
endSub:
   Count = 0
   Do Until LastRow
       dtgrdLicense.Row = Count
       dtgrdLicense.Col = 1
       If UCase(Mid(dtgrdLicense.Text, 1, Len(txtCustomerId))) = UCase(txtCustomerId) Then
         Exit Sub
        End If
        Count = Count + 1
    Loop
ErrHandle:
End Sub
0
 

Author Comment

by:BIAPRO
ID: 12091935
I forget about ADO,  I wrote (yes, its more work) a APX module with Vaccess and a. will work, b.  MUCH faster.
Thanks anyway
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn different types of Android Layout and some basics of an Android App.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
Introduction to Processes
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question