Darren D
darrend at nimble.com.au
Tue Jun 19 19:01:54 CDT 2007
Oh yeah!!!!!!!!!! - the possibilities - oh my gosh Many many thanks Arthur Have a great day Darren ------------------ T: 0424 696 433 -----Original Message----- From: Arthur Fuller [mailto:fuller.artful at gmail.com] Sent: Tuesday, 19 June 2007 9:53 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003: return records from Stored proc in SQL They are all hidden under the queries tab of the database window. From the moment Access introduced the ADP format, I was instantly and totally hooked. In fact, I have won a couple of bottles of beer when some snotty DBA said, "Oh yeah, can you talk to the system tables?" and I whipped up an app on the spot that not only spoke to the system tables but had combo-boxes too. It's a lot of fun to do that to people who think Access is a toy. A. On 6/18/07, Darren D <darrend at nimble.com.au> wrote: > > Hi Arthur et al > > I had no Idea what an ADP was - this looks like it could do the trick - > way cool > > I have been to the MS site and had a look at their blurb on this and in > their > screen dumps the ADP's display an outlook style tab (tables, Queries, > reports > etc) called Store Procedures > > http://msdn2.microsoft.com/en-us/library/aa155779(office.10).aspx > > But when I create an ADP I do not see this - Though the usual suspects are > there > - Tables, Queries, Forms, Reports etc > > Any clues on why I don't see Stored Procs? > > Many thanks > > Have a great day > > Darren > ------------------ > > -----Original Message----- > From: Arthur Fuller [mailto:fuller.artful at gmail.com] > Sent: Tuesday, 19 June 2007 12:22 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] A2003: return records from Stored proc in SQL > > The simplest way is to supply the name of the sproc as the record source > of > a form (this assumes ADP file format). You'll find near the bottom of the > data tab of the properties sheet a place to put your parameters. > > More complex is to create a recordset and use it to receive the results of > your sproc. But even then, it wouldn't be "visible", at least to the user, > until you did something with it. > > Dunno if that helped, > Arthur > > > On 6/18/07, Darren D <darrend at nimble.com.au> wrote: > > > > Hi All > > > > > > > > I have some code that runs a Stored Proc in SQL and it passes the dB > name > > username, pwd etc > > > > > > > > Cool > > > > > > > > How do I actually get the results from this Stored Procedure visible in > > access?? > > > > > > > > Many thanks > > > > > > > > > > No virus found in this outgoing message. > > Checked by AVG Free Edition. > > Version: 7.5.472 / Virus Database: 269.8.16/849 - Release Date: > 14/06/2007 > > 12:44 > > PM > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.472 / Virus Database: 269.9.0/852 - Release Date: 17/06/2007 > 8:23 > AM > > > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.472 / Virus Database: 269.9.0/852 - Release Date: 17/06/2007 > 8:23 > AM > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.9.1/854 - Release Date: 19/06/2007 1:12 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.9.1/854 - Release Date: 19/06/2007 1:12 PM