Opensnapshot

[BoroLee]

Can anyone tell me wot is wrong with this code please???

It works in another db of mine, but won't work in one i'm developing now.

Set rstTmp = db.OpenRecordset(sqlstr, OpenSnapshot)

Thanks.

 

[Mile-O]

A quick look at the OpenRecordset keyword in the help files would have told you that your syntax is incorrect.

It's not OpenSnapshot; it's dbOpenSnapshot.

 

[BoroLee]

Ok thanks.

Have changed that, and now get :

Run time rror 3061

Too few parameters: Expected 3

Any idea's??

 

[Mile-O]

A QueryDef looks like your way forward.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=45940&highlight=parameters