Parameter Query in Query Def

M

MSProject

I am trying to upzise my access db to an Access Project. I have code in a
form that uses values from the form to create a query as the values are
updated. The query recreates itself using the Afterupdate() event. In the
"Access Project.adp" my code breaks when declaring my variables (Dim db as
database) I don't think it recognizes the "database" type. I would greatly
appreciate any help. Thank you

Private Sub RecalcResults()

Dim RS As Recordset
Dim dbs As database
Dim strSQL As String
Dim strStructure As String
Dim strCSD As String
Dim varitem As Variant
Dim strAg As String
Dim vitem As Variant
Dim strISect As String
Dim vISect As Variant

On Error GoTo Err_RecalcPipeResults
 
Top