/ Snippet Library - View Code

Visual Basic / Database / Open database

Snippet details

ID: 312

Viewed: 938

Added: 2002-08-19

Version:

Snippets in this catagory
Show Printable Version

Open database with code & SQL

General Details

Snippet uploaded by: snippet

Email : webmaster@snippetlibrary.com

Snippet By: Unknown

Snippet By:	Unknown
Declarations
Highlight Allnone
Code
Highlight All'Example code '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 Reviews to show