db.OpenRecordset

[pcdaveh]

I have a record set object that points to a query. I'm tring to get vba to recognize it and it won't. Please tell me what is wrong with this code. The error I get is invalid argument

Thanks!

Dim db As Database
Dim rst As Recordset
Dim x As Integer
Dim li_OnOff As Integer
Set db = CurrentDb()
Set rst = db.OpenRecordset("q_TransactionSummaryForm", dbOpenDynamic)

 

[Databaseguy]

Is this a table or query ??"q_TransactionSummaryForm". If not, it needs to be. Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[Guest_imported]

Have you referenced your project to?

Project
References
Select Microsoft DAO 3.51 Object Library

Hope it helps,

AmaHerrn

 

[Guest_imported]

Sorry, I misunderstood your question, thought it was on VB alone.

 

[Guest_imported]

By the way, why not doing directly

Set rst = Currentdb.openrecordset("your Query or table", dbopendynaset)

I notice now that dbopendynamic,.. is that valid? try with dynaset instead of dynamic.

 

[Databaseguy]

Your Syntax is correct. Have you checked the query ??? Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy

 

[nickjar2]

Amaherrn is correct isn't he. The invalid arguement is the dbOpenDynamic. Like he/she said, it should be dbOpenDyanset.

Nick

 

[jebry]

Hi!

I think dbOpenDynamic will only be a problem if the query references linked tables. I believe you can only use Dynamic with objects in the direct workspace?

hth
Jeff Bridgham

 

[Databaseguy]

Oops. My mistake. dbOpenDynamic is valid only in the ODBC direct workspace. pcdaveh should be using dbOpenDynaset if it needs to be edited. Oherwise use dbForwardOnly or dbSnapshot Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy