[AccessD] Cross Tab Query Help Requested

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




More information about the AccessD mailing list