Martin Reid
mwp.reid at qub.ac.uk
Thu Jun 15 14:17:40 CDT 2006
I have deleted it, rewriten it and its driving me nuts.So I deleted it again. WIl rewrite it in a few mins. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of David McAfee Sent: Thu 15/06/2006 20:13 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 and Stored Procedure Problem Do you have a sample of the code and or sproc that you were trying to execute? It may be a simple typo. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Reid Sent: Thursday, June 15, 2006 12:05 PM To: Access Developers discussion and problem solving Subject: [AccessD] Access 2007 and Stored Procedure Problem Working in Access 2007 This is driving me nuts and making me feel really silly. Re code last night. I have something simple here. An SQL Server 2005 SP whcih is a basic select statement. I execute it as shown last night and trying to use the results as the recordset for the form. Whatever I try to do this only returns a single record - as it seems. The move next fails to work at all and returns Object required. Does anyone have a simple working example of this. I need something I know is working to use as a base line.I get the feeling that this is either Access 2007 or SQL Server 2005. I have tried commands, execute into recordsets, last nights code and no joy with anyof this. If I simply use the SP as the record source of the form its fine. If I execute it outside the form its fine. But nothing I seem to do in code will work. I am beginning to feel somewhat silly with this. As I have done this many times. Of course the problem could be me ! Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>