Snippet Library

Account

ID: 308

Viewed: 3630

Added: Aug 19, 2002

Version:

Snippet uploaded by: snippet

Written By: Unknown

Demo: Sorry, no demo

Thank you for your vote. Please wait...

It appears you already voted for this snippet

It appears your vote value was empty

Other Snippets in this catagory
Show Printable Version

to load a database and have it print in textboxes.
Add some textboxes and 2 listboxes. also add a data control and leave tehn all named as defaults.

Highlight all by clicking in box

none

Highlight All

Private Sub Form_Load()
' to load from any harddrive    
    Dim DBPath As String
    DBPath = App.Path
    
    If Right(DBPath, 1) <> "" Then DBPath = DBPath & ""
    Data1.DatabaseName = DBPath & "nintendo.mdb"
    Data1.RecordSource = strsql
    Data1.Refresh
    On Error Resume Next

    Data1.Recordset.MoveLast
    'count the records
    Text6.Text = Data1.Recordset.RecordCount
    Data1.Recordset.MoveFirst
 
    
    Call filltext
    
End Sub


Private Sub filltext()
Data1.Recordset.MoveLast
Data1.Recordset.MoveFirst
Lst1.Text = ""
Lst2.Text = ""
For a = 1 To DatBoy.Recordset.RecordCount
 ' this one sets a carriage return
 Lst1.AddItem Data1.Recordset!Game
 Lst2.AddItem Data1.Recordset!volume
  DatBoy.Recordset.MoveNext
 Next a
 BtnClear.Enabled = True
End Sub;

No Comments to show

Please completely fill out the form below if you want to review this snippet. All reviews are subject to validation.

Adding your comment. Please wait...

Thanks for adding your comment!. After further review it will be added.

There was a problem adding your comment. Please try again.

Please complete all the fields in the form before sending.

Snippet Library

Replying to a Comment...