Dumb question 
Author Message
 Dumb question

I have an ADO database application.

The way I am reading records, is reading the data from the form's text box
that is bound to, kind of like this

ItemCost = val(text1.text)              (with text1's datafield property set
to the item cost field of the database.)

If I am not creating a form, can I access the data another way?, with a
simple command, something like....

adodc1.recordset.ItemCost                 or something nice and simple like
that.  (i know there has to be a nice easy simple way)

Thanks
Davester



Mon, 28 Jun 2004 08:57:44 GMT
 Dumb question

Dave,

I'm not sure quite what you are looking for but this is part of a test
program that uses the MSHflexgrid. See if this helps any.

Gary...

Private Sub cmd_so_Click()
   Set rx = New ADODB.Recordset

   objGrid.Clear
   frmHFlexGrid.Refresh

   sql_cmd = "select order_no,partno,on_ord_mfg,start_date,due_date "
_
           & "from SO_mast where stat_flg = 'R'"
   rx.Open sql_cmd, cn, , , adCmdText
   With objGrid
       Set .DataSource = rx
        .ColWidth(0, 0) = 400
        .ColWidth(1, 0) = 2000
        .ColWidth(2, 0) = 2000
        .ColWidth(3, 0) = 1000
        .ColWidth(4, 0) = 1200
        .ColWidth(5, 0) = 1200
        .RowHeight(0) = 500
        .TextMatrix(0, 1) = "Order"
        .TextMatrix(0, 2) = "Partno"
        .TextMatrix(0, 3) = "On Order"
        .TextMatrix(0, 4) = "Start Date"
        .TextMatrix(0, 5) = "Order Due"
'        .WordWrap = True
   End With

End Sub

Quote:

>I have an ADO database application.

>The way I am reading records, is reading the data from the form's text box
>that is bound to, kind of like this

>ItemCost = val(text1.text)              (with text1's datafield property set
>to the item cost field of the database.)

>If I am not creating a form, can I access the data another way?, with a
>simple command, something like....

>adodc1.recordset.ItemCost                 or something nice and simple like
>that.  (i know there has to be a nice easy simple way)

>Thanks
>Davester

-----------------------------------------------------------

VP Technology - Monitor Aerospace Corp.
-----------------------------------------------------------


Mon, 28 Jun 2004 09:13:59 GMT
 Dumb question
adodc1.recordset.fields("AFieldName").Value
Quote:

> I have an ADO database application.

> The way I am reading records, is reading the data from the form's text box
> that is bound to, kind of like this

> ItemCost = val(text1.text)              (with text1's datafield property set
> to the item cost field of the database.)

> If I am not creating a form, can I access the data another way?, with a
> simple command, something like....

> adodc1.recordset.ItemCost                 or something nice and simple like
> that.  (i know there has to be a nice easy simple way)

> Thanks
> Davester



Mon, 28 Jun 2004 14:02:57 GMT
 Dumb question
THANK YOU ! ! ! !!  ! !! !  ! ! !!  !! ! !  !! !  !!  !

 It was a real pain the other way ! ! ! !! !  !! !  !!  !!

Davester


Quote:
> adodc1.recordset.fields("AFieldName").Value


> > I have an ADO database application.

> > The way I am reading records, is reading the data from the form's text
box
> > that is bound to, kind of like this

> > ItemCost = val(text1.text)              (with text1's datafield property
set
> > to the item cost field of the database.)

> > If I am not creating a form, can I access the data another way?, with a
> > simple command, something like....

> > adodc1.recordset.ItemCost                 or something nice and simple
like
> > that.  (i know there has to be a nice easy simple way)

> > Thanks
> > Davester



Tue, 29 Jun 2004 05:11:05 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. dumb question!!

2. Very dumb question from Newbie

3. Kind of a dumb question

4. Probably A really Dumb Question

5. DUMB question: Standard security / NT security

6. Possibly dumb question - fact data in non leaf hierarchy members

7. Dumb Question: Table Copy Script

8. Dumb question

9. Turbo-dumb question: DTS lookups

10. Dumb question

11. A real dumb question about sql client.

12. really dumb question


 
Powered by phpBB® Forum Software