Select Record


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: Select Record

Hybrid View

  1. #1
    woody Guest

    Select Record


    I am trying to write code enabling the user to select a record within the
    datagrid and then write another query based on what the user selects. I
    am not sure where to start with allowing the user to select a record. Can
    anyone help? Thanks

  2. #2
    Leopoldo Guest

    Re: Select Record


    Look, let me see if I undertand you,

    Example:
    1. You populate a grid with varios records with your customers.
    2. The user click's on the row with the customer he wants.
    3. You create another query with the value
    DataGrid.Columns(0).Value
    4. You populate another Grid.

    I hope i can help you.
    Leopoldo


    "woody" <wood060898@aol.com> wrote:
    >
    >I am trying to write code enabling the user to select a record within the
    >datagrid and then write another query based on what the user selects. I
    >am not sure where to start with allowing the user to select a record. Can
    >anyone help? Thanks



  3. #3
    Woody Guest

    Re: Select Record


    I am still unable to get this to work this is the code I have:

    Private Sub cmdSubmit_Click()
    Customer = txtQuery.Text
    s1 = "'"
    s2 = "%"
    Custquery = s1 & Customer & s2 & s1
    On Error Resume Next
    adCarolynWood.RecordSource = "SELECT CoNum,CustNum, CustName, City, St
    FROM CUSTOMER Where CustName Like " & Custquery
    Call adCarolynWood.Refresh

    End Sub


    Private Sub dgCarolynWood_DblClick()
    Call frmFindInvoices.Show
    End Sub


    I show the infor from the first Query in dgCarolynWood. I am then trying
    to take the customer number from a record selected by the user and load a
    differant dg showing the invoices fo that customer.

    "Leopoldo" <poloart@hotmail.com> wrote:
    >
    >Look, let me see if I undertand you,
    >
    >Example:
    >1. You populate a grid with varios records with your customers.
    >2. The user click's on the row with the customer he wants.
    >3. You create another query with the value
    > DataGrid.Columns(0).Value
    >4. You populate another Grid.
    >
    >I hope i can help you.
    >Leopoldo
    >
    >
    >"woody" <wood060898@aol.com> wrote:
    >>
    >>I am trying to write code enabling the user to select a record within the
    >>datagrid and then write another query based on what the user selects.

    I
    >>am not sure where to start with allowing the user to select a record.

    Can
    >>anyone help? Thanks

    >



  4. #4
    Leopoldo Guest

    Re: Select Record


    I don't understand you very well,

    The "cmdSubmit_Click" creates a recordset with some customers, and you want
    the user to select a record from this recordset?,

    can you epxlain to me the steps you are following?

    Leopoldo



    "Woody" <wood060898@aol.com> wrote:
    >
    >I am still unable to get this to work this is the code I have:
    >
    >Private Sub cmdSubmit_Click()
    > Customer = txtQuery.Text
    > s1 = "'"
    > s2 = "%"
    > Custquery = s1 & Customer & s2 & s1
    > On Error Resume Next
    > adCarolynWood.RecordSource = "SELECT CoNum,CustNum, CustName, City,

    St
    >FROM CUSTOMER Where CustName Like " & Custquery
    > Call adCarolynWood.Refresh
    >
    >End Sub
    >
    >
    >Private Sub dgCarolynWood_DblClick()
    >Call frmFindInvoices.Show
    >End Sub
    >
    >
    >I show the infor from the first Query in dgCarolynWood. I am then trying
    >to take the customer number from a record selected by the user and load

    a
    >differant dg showing the invoices fo that customer.
    >
    >"Leopoldo" <poloart@hotmail.com> wrote:
    >>
    >>Look, let me see if I undertand you,
    >>
    >>Example:
    >>1. You populate a grid with varios records with your customers.
    >>2. The user click's on the row with the customer he wants.
    >>3. You create another query with the value
    >> DataGrid.Columns(0).Value
    >>4. You populate another Grid.
    >>
    >>I hope i can help you.
    >>Leopoldo
    >>
    >>
    >>"woody" <wood060898@aol.com> wrote:
    >>>
    >>>I am trying to write code enabling the user to select a record within

    the
    >>>datagrid and then write another query based on what the user selects.


    >I
    >>>am not sure where to start with allowing the user to select a record.


    >Can
    >>>anyone help? Thanks

    >>

    >



  5. #5
    woody Guest

    Re: Select Record


    I am not explaining well. I crated a for with a text obx for a use to entered
    part of a customer name. I am using a command buttone submitt to take the
    partial entry of the customer name and run the query to show the a list of
    customers in a datagrid

    EX User enters Woo
    the grid may show 3 Records along with their # and Address

    Wood, Carolyn 104
    Woods, James 105
    Worner, Mike 106

    I then want the user to be able to Double Click on James, Woods have my second
    form Laod that will query another database based on the # 105. The part
    that I am getting stuck on is how to get the 105 from my datagrid. Thanks

    "Leopoldo" <poloart@hotmail.com> wrote:
    >
    >I don't understand you very well,
    >
    >The "cmdSubmit_Click" creates a recordset with some customers, and you want
    >the user to select a record from this recordset?,
    >
    >can you epxlain to me the steps you are following?
    >
    >Leopoldo
    >
    >
    >
    >"Woody" <wood060898@aol.com> wrote:
    >>
    >>I am still unable to get this to work this is the code I have:
    >>
    >>Private Sub cmdSubmit_Click()
    >> Customer = txtQuery.Text
    >> s1 = "'"
    >> s2 = "%"
    >> Custquery = s1 & Customer & s2 & s1
    >> On Error Resume Next
    >> adCarolynWood.RecordSource = "SELECT CoNum,CustNum, CustName, City,

    >St
    >>FROM CUSTOMER Where CustName Like " & Custquery
    >> Call adCarolynWood.Refresh
    >>
    >>End Sub
    >>
    >>
    >>Private Sub dgCarolynWood_DblClick()
    >>Call frmFindInvoices.Show
    >>End Sub
    >>
    >>
    >>I show the infor from the first Query in dgCarolynWood. I am then trying
    >>to take the customer number from a record selected by the user and load

    >a
    >>differant dg showing the invoices fo that customer.
    >>
    >>"Leopoldo" <poloart@hotmail.com> wrote:
    >>>
    >>>Look, let me see if I undertand you,
    >>>
    >>>Example:
    >>>1. You populate a grid with varios records with your customers.
    >>>2. The user click's on the row with the customer he wants.
    >>>3. You create another query with the value
    >>> DataGrid.Columns(0).Value
    >>>4. You populate another Grid.
    >>>
    >>>I hope i can help you.
    >>>Leopoldo
    >>>
    >>>
    >>>"woody" <wood060898@aol.com> wrote:
    >>>>
    >>>>I am trying to write code enabling the user to select a record within

    >the
    >>>>datagrid and then write another query based on what the user selects.

    >
    >>I
    >>>>am not sure where to start with allowing the user to select a record.

    >
    >>Can
    >>>>anyone help? Thanks
    >>>

    >>

    >



  6. #6
    Leopoldo Guest

    Re: Select Record


    Ok, Well the value you requier is in some part of the grid matrix, so you
    must access this value,

    When a user clicks on a grid the Row moves to the clicked row, and the only
    you need now is the col, So if the value you are looking for is in the Column
    2, you should access the data with this:

    DataGrid.Columns(2).Value

    This will give you the value of the third column (remember the columns begin
    at 0) in the currently selected row.

    With this you can do what you whant, I think.
    Leopoldo

    "woody" <wood060898@aol.com> wrote:
    >
    >I am not explaining well. I crated a for with a text obx for a use to entered
    >part of a customer name. I am using a command buttone submitt to take the
    >partial entry of the customer name and run the query to show the a list

    of
    >customers in a datagrid
    >
    >EX User enters Woo
    >the grid may show 3 Records along with their # and Address
    >
    >Wood, Carolyn 104
    >Woods, James 105
    >Worner, Mike 106
    >
    >I then want the user to be able to Double Click on James, Woods have my

    second
    >form Laod that will query another database based on the # 105. The part
    >that I am getting stuck on is how to get the 105 from my datagrid. Thanks
    >
    >"Leopoldo" <poloart@hotmail.com> wrote:
    >>
    >>I don't understand you very well,
    >>
    >>The "cmdSubmit_Click" creates a recordset with some customers, and you

    want
    >>the user to select a record from this recordset?,
    >>
    >>can you epxlain to me the steps you are following?
    >>
    >>Leopoldo
    >>
    >>
    >>
    >>"Woody" <wood060898@aol.com> wrote:
    >>>
    >>>I am still unable to get this to work this is the code I have:
    >>>
    >>>Private Sub cmdSubmit_Click()
    >>> Customer = txtQuery.Text
    >>> s1 = "'"
    >>> s2 = "%"
    >>> Custquery = s1 & Customer & s2 & s1
    >>> On Error Resume Next
    >>> adCarolynWood.RecordSource = "SELECT CoNum,CustNum, CustName, City,

    >>St
    >>>FROM CUSTOMER Where CustName Like " & Custquery
    >>> Call adCarolynWood.Refresh
    >>>
    >>>End Sub
    >>>
    >>>
    >>>Private Sub dgCarolynWood_DblClick()
    >>>Call frmFindInvoices.Show
    >>>End Sub
    >>>
    >>>
    >>>I show the infor from the first Query in dgCarolynWood. I am then trying
    >>>to take the customer number from a record selected by the user and load

    >>a
    >>>differant dg showing the invoices fo that customer.
    >>>
    >>>"Leopoldo" <poloart@hotmail.com> wrote:
    >>>>
    >>>>Look, let me see if I undertand you,
    >>>>
    >>>>Example:
    >>>>1. You populate a grid with varios records with your customers.
    >>>>2. The user click's on the row with the customer he wants.
    >>>>3. You create another query with the value
    >>>> DataGrid.Columns(0).Value
    >>>>4. You populate another Grid.
    >>>>
    >>>>I hope i can help you.
    >>>>Leopoldo
    >>>>
    >>>>
    >>>>"woody" <wood060898@aol.com> wrote:
    >>>>>
    >>>>>I am trying to write code enabling the user to select a record within

    >>the
    >>>>>datagrid and then write another query based on what the user selects.

    >>
    >>>I
    >>>>>am not sure where to start with allowing the user to select a record.

    >>
    >>>Can
    >>>>>anyone help? Thanks
    >>>>
    >>>

    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center