Not a Member Yet,
Click here to Register
How do you like the new design?
It's cool, great job
[tally: 70%] 70%
It's okay
[tally: 20%] 20%
Its OK but I liked the old layout better
[tally: 0%] 0%
Please bring the old one back
[tally: 10%] 10%

votes: 10

ID: 308
Viewed: 3024
Added: Aug 19, 2002
Version:
Snippet uploaded by: snippet
Written By: Unknown
Demo: Sorry, no demo



User Rated at: 0 Stars
Rate This:

Thank you for your vote. Please wait...

It appears you already voted for this snippet

It appears your vote value was empty

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
<!---Declaration--->
none

Highlight All
<!---Code--->
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.


Replying to a Comment...


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.

© 2002 - 2017 snippetlibrary.com All Rights Reserved. Conditions