Re: Too Few Parameters error ???

MLH wrote in
news:1cibj3tiaqo0r9eijjiuovln9jr48idhno@4ax.com:

> BTW, am trying to do this without qdfTemp being a
> permanent, saved querydef. Is that not possible? Will
> be happy to post the bulk of the snippet if need be.

Sure it's possible. Read the help on openrecordset.

your Set rstTemp = .OpenRecordset(dbOpenSnapshot)
is missing the required first parameter, but you've included the
second, optional, parameter.

try this
strSQL = "SELECT info from HELP where help.key = """ & openrecordset &
""""
Set rstTemp = .OpenRecordset(strSQL)


--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Too Few Parameters error ???

Set rstTemp = .OpenRecordset(dbOpenSnapshot)

Execution of the above line gives me a "Too few parameters"
error. The line is preceeded by another line I thought would
make it work... With qdfTemp

Is something wrong with the syntax? At compile time, I get
no errors.

Re: Too Few Parameters error ???

BTW, am trying to do this without qdfTemp being a
permanent, saved querydef. Is that not possible? Will
be happy to post the bulk of the snippet if need be.

Re: Too Few Parameters error ???

Thx, Bob!