Added: Aug 19, 2002
Snippet uploaded by: snippet
Written By: Unknown
Demo: Sorry, no demo
Open database with code & SQL
Highlight all by clicking in box
'gvDataPath is Global variable for Data Path
'stored/retrieved from ini file
'Open Table with code
Dim cDBName As String ' database name
Dim dbName As Database ' database object
cDBName = gvDataPath + "test.mdb"
Set dbName = OpenDatabase(cDBName)
'SQL to get Find Thing in Test Table
Dim SelectString As String
SelectString = "Select * from Test where [Name]= " & "'" & "Thing" & "'"
Dim rsName As Recordset
Set rsName = dbName.OpenRecordset(SelectString)
'Copy fields to variables
Dim Name As String
Name = rsName.Fields("Name");
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.