Class Parameters (DAO VBA)

A Parameters collection contains all the Parameter objects of a QueryDef object. To use a Parameters class variable it first needs to be instantiated, for example

Dim prms as Parameters
Set prms = Workspaces(1).Databases(1).QueryDefs(1).Parameters

Count

Returns the number of objects in the specified collection.

Because members of a collection begin with 0, you should always code loops starting with the 0 member and ending with the value of the Count property minus 1. If you want to loop through the members of a collection without checking the Count property, you can use a For Each...Next command. The Count property setting is never Null. If its value is 0, there are no objects in the collection.

Dim prms As DAO.Parameters: Set prms = 
prms.Count

Item

Item (Item)

Refresh

Updates the objects in the specified colletion to reflect the database's current schema.

Use the Refresh method in multiuser environments in which other users may change the database. You may also need to use it on any collections that are indirectly affected by changes to the database. For example, if you change a Users collection, you may need to refresh a Groups collection before using the Groups collection. A collection is filled with objects the first time it's referred to and won't automatically reflect subsequent changes other users make. If it's likely that another user has changed a collection, use the Refresh method on the collection immediately before carrying out any task in your application that assumes the presence or absence of a particular object in the collection. This will ensure that the collection is as up-to-date as possible. On the other hand, using Refresh can unnecessarily slow performance.

Dim prms As DAO.Parameters: Set prms = 
prms.Refresh