Francisco H Tapia
my.lists at verizon.net
Thu Apr 3 18:24:52 CST 2003
I don't use that feature, but perhaps this might help, I've found that the "EXEC stpMystoredProcedure @Param1 = " & iMyparam1 & ", @Param2 = '" & strParam2 & "'" works well when applying it to listboxes, combo, forms.. you name it ... I wonder if it would work this way for you as well... -Francisco http://rcm.netfirms.com On Thursday, April 03, 2003 4:15 PM [GMT-8], David Emerson <davide at dalyn.co.nz> wrote: : I am able to use the following line to export the result of a sproc : to excel - : : DoCmd.OutputTo acOutputStoredProcedure, "spBookingExport", : acFormatXLS, strFullName : : However, can I do it if the sproc has parameters and I don't want the : user : to have to enter in the values as they are already on the form that : calls : the sproc? : : Regards : : David Emerson : DALYN Software Ltd : 25b Cunliffe St, Johnsonville : Wellington, New Zealand : Ph/Fax (877) 456-1205 : : _______________________________________________ : dba-SQLServer mailing list : dba-SQLServer at databaseadvisors.com : http://databaseadvisors.com/mailman/listinfo/dba-sqlserver : http://www.databaseadvisors.com