As you probably know, in Access a parameter query displays one or
more predefined dialog boxes that prompt you for a parameter value.
In most cases, you use a parameter query to determine criterion. For
example, if you limited a query's result by the parameter, <[Please
Enter A Date], then when you ran the query Access would display a
prompt and ask you to Please Enter A Date and filter the records
accordingly.
When you manipulate these queries in DAO through VBA, however, you'll
need to supply the parameter value before you open the recordset
object. If you don't, DAO generates an error.
To do so, access the Parameters collection of the DAO querydef
object. A querydef is a query's definition, or blueprint. It tells DAO
what the query's layout should be, while a recordset contains the
results generated by the querydef. To illustrate, take a look at the
following code:Private Sub cmbRunParam_Click()
Dim wrk As DAO.Workspace
Dim db As DAO.Database
Dim rst As DAO.Recordset
Dim qdf As QueryDef
Set wrk = CreateWorkspace("", "Admin", "", dbUseJet)
'Change database path
Set db = wrk.OpenDatabase("D:Examplesdb1.mdb")
Set qdf = db.QueryDefs("qryParamQuery")
qdf.Parameters("[Please Enter a Date]") = #8/15/2000#
Set rst = qdf.OpenRecordset()
rst.MoveLast
MsgBox "There are " & rst.RecordCount & " projects to"
_
& vbCr & "complete before this date."
Set rst = Nothing
Set qdf = Nothing
Set db = Nothing
Set wrk = Nothing
End Sub
Parameters in a DAO parameter query
By ElementK Journals, published on 14 Jul 2001
| Filed in
You might also like...
Database forum discussion
-
Required Every quarter data from sql automatically in below sql format
by jain.piyush831 (0 replies)
-
Is Your Data is Lost? Learn Online How TO Recover Your Data.
by dataempires (0 replies)
-
Executing a command line SELECT
by cyoung311 (0 replies)
-
Softaken Mac OLM to PST Migration Software
by albertcolin012 (0 replies)
-
MAX value of each column - HELP
by triparipr (0 replies)
Database podcasts
-
Stack Overflow Podcast: Podcast #45 – Keeping it Sharp
Published 7 years ago, running time 0h54m
Our guest this week is Eric Lippert – language architect extraordinaire and famous for all his work at Microsoft in developing their languages Eric joined Microsoft right out of college and was originally working on VB It’s time for everyone’s favorite game: Name the Worst Feature of that Microso.
Comments