How to Use Variables in Access Query

<P>Open the Northwind Microsoft Office Access database. The Northwind database is included in the Microsoft Office suite.</P><P>Click "Database Tools" then select "Visual Basic" to open the Microsoft Visual Basic Window. Click the "Insert" field and select "Module."</P><P>Copy and paste the following code into your new module to use "Supplier A" as a variable in a select query and view the first name and last name of "Supplier A":</P><P>Private Sub userQueryVariables()</P><P>Dim strSQL As String</P><P>Dim rst As Recordset</P><P>Dim dbs As Database</P><P>Dim supplier As String</P><P>supplier = "Supplier A"</P><P>Set dbs = CurrentDb</P><P>strSQL = "SELECT Suppliers.Company, Suppliers.[Last Name], Suppliers.[First Name] "</P><P>strSQL = strSQL & "FROM Suppliers "</P><P>strSQL = strSQL & "WHERE (((Suppliers.Company)='" & (supplier) & "'));"</P><P>Set rst = dbs.OpenRecordset(strSQL)</P><P>rst.MoveLast</P><P>rst.MoveFirst</P><P>Debug.Print (supplier & " Information:")</P><P>Do While Not rst.EOF</P><P>Debug.Print ("First Name: " & rst.Fields(2).Value)</P><P>Debug.Print ("Last Name: " & rst.Fields(1).Value)</P><P>rst.MoveNext</P><P>Loop</P><P>End Sub</P><P>Press "F5" to run your subroutine.</P><br /><p><a href="http://www.ehow.com/how_7431972_use-variables-access-query.html" rel="nofollow" target="_blank">View the original article here</a></p>

How to Use Variables in Access Query

Open the Northwind Microsoft Office Access database. The Northwind database is included in the Microsoft Office suite. Click "Database...

Continue Reading>>