Loosing Controls After Upsizing from mdb to Adp

[paulgenga]

After upsizing my mdb to adp, The search FindFirst is sending an error message...
"Object doesnt support this property". The instruction example is as follows...

Dim rs As Object
rs.FindFirst "[ID]="&Str(Me![List0])
Me.bookmark = rs.bookmark

 

[TimKThailand]

DAO is discarded in Access Project.
You have to change DAO code to ADO instead.

Dim rs As Object
rs.Find "[ID]="&Str(Me![List0])

 

[paulgenga]

Thanks Tim.
I have just seen it, Be blessed
I am also unable to include form controls on my View/Query Criterias such as Forms!MyForm!MyCotrol is there a way to get round this in ADP

Regards
Paul

 

[jlitondo]

PGENGA04, I also recently upsized my mdb to an adp. Since the queries that you are viewing in the adp are actually sql objects, using Forms!MyForm!MyCotrol will not work since sql does not recognize this format. You will instead have to declare a variable to recieve the value of MyControl, and then have your front end pass this value whenever it calls your "query".
Also, I am finding that I like editing my "queries" through SQL Query Analyser much more than through the adp file. You may want to study how it works, along with the Enterprise Manager as they are both turning out to be extremely handy.