b heygood
bheygood at abestsystems.com
Tue May 3 16:38:56 CDT 2011
no, the parameter is a long integer. I just was trying various..... thx for responding. bob -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, May 03, 2011 1:50 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A97 SQL Server If the parameter in the sp is some sort of string, as suggested by '" & "M" & "'", try conTest.Execute "EXEC sp_Add_FutureServicesOrders_byRoute '" & Trim$(RTE) & "'" i.e. embed RTE in single quotes and trim the leading space placeholder for "+/-" -- Stuart On 3 May 2011 at 11:05, b heygood wrote: > 'conTest.Execute "sp_Add_FutureServicesOrders_byRoute '" & "M" & "'" > conTest.Execute "EXEC sp_Add_FutureServicesOrders_byRoute " & RTE > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com