Bruce Bruen
bbruen at unwired.com.au
Mon May 14 16:50:35 CDT 2007
>From memory, dim rs as recordset dim cmd as new command cmd.text="qrfmWeeklyData" cmd.type=acStoredProc '????? cmd.connection = CurrentProject.Connection set rs=cmd.exec(,param1) ... hth On Monday 14 May 2007 21:10, ewaldt at gdls.com wrote: > I am running into a problem with a cross tab query. > <snip> > Here's the code portion that Access highlights: > > rst.Open _ > Source:="qfrmWeeklyData", _ > ActiveConnection:=CurrentProject.Connection, _ > Options:=adCmdTable > > I'd greatly appreciate any help with this. > > > Thomas F. Ewald > Stryker Mass Properties > General Dynamics Land Systems > > > > This is an e-mail from General Dynamics Land Systems. It is for the > intended recipient only and may contain confidential and privileged > information. No one else may read, print, store, copy, forward or act in > reliance on it or its attachments. If you are not the intended recipient, > please return this message to the sender and delete the message and any > attachments from your computer. Your cooperation is appreciated. -- regards Bruce