Variable Type - ADP

[cschan80]

I am currently using SQL Server with an ADP frontend, and am trying to get a form to return values to a parameter query.

There is some code already in place, and it looks solid. There were just some wrong variable definitions when dimensioning them. I have pasted the problem variable definitions below:

Dim qryCriteriaDef As QueryDef
Dim qdfNew As QueryDef
Dim dbsScholarship As Database
Set dbsScholarship = CurrentDb

These do not work properly...are not defined as user-defined types.

Was just wondering if anyone had any ideas what might be the right variable type for use with ADP, or if these types need to be defined.

Any help will be appreciated, thanks.

-chris

 

[Nowell]

Hi Chris,

This is because acces project and SQL server support ADO not DAO.
if you need examples of ADO give me all your code