Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
| Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 9th, 2010, 06:21 AM
Registered User
 
Join Date: Apr 2010
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default SQL stored procedure with multiple data sets

Hi guys, 1st post here...

We are using SQL2008/64 (YAY!) and Access 2003 (BOO!)

I have an established SP that generates multiple data sets. I can get at the first dataset using either a pass through query or an ADODB connection in VBA, but I cant find anything on the net about how you would navigate multiple results sets in Access (I know it can be done in .NET)

Is this possible and if so, how do I configure the access objects to handle it (I guess I need an array of Recordsets??)


Thanks in Advance

Obiron




Similar Threads
Thread Thread Starter Forum Replies Last Post
validate multiple sets of data on a form smys123 Javascript How-To 1 October 30th, 2009 07:28 AM
stored procedure with two result sets joxa83 SQL Server 2000 14 July 18th, 2007 01:03 AM
stored procedure that inserts data desireemm SQL Language 5 January 22nd, 2006 04:25 PM
Sql server Stored procedure ranakdinesh BOOK: Professional C#, 2nd and 3rd Editions 2 May 29th, 2004 12:08 AM
SQL Stored Procedure... babloo81 SQL Server ASP 1 December 8th, 2003 03:38 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.