pcs at azizaz.com
pcs at azizaz.com
Mon Nov 12 18:26:45 CST 2007
Darren, Try: Set Forms(strFrm).Recordset = rs where rs is the recordset you have created and strForm is a string variable holding the name of your Form Regards Borge ---- Original message ---- >Date: Tue, 13 Nov 2007 11:06:46 +1100 >From: "Darren D" <darren at activebilling.com.au> >Subject: Re: [AccessD] Getting Results from SQL SVR into a Continuous form >To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> > >Hi Arthur > >This sounds very efficient - Cool > >Now the tricky bit... > >How do I 'bind' a continuous form in access 2003 (NOT ADP) to a SPROC or view in >SQL SVR? > >Thanks > >Darren >-----Original Message----- >From: accessd-bounces at databaseadvisors.com >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller >Sent: Tuesday, 13 November 2007 10:53 AM >To: Access Developers discussion and problem solving >Subject: Re: [AccessD] Getting Results from SQL SVR into a Continuous form > >Why not eliminate both at once and instead create a sproc or view and use it >as the record source? > >A. > >On 11/12/07, Darren D <darren at activebilling.com.au> wrote: >> >> Hi team >> >> >> >> Access 2003 >> >> >> >> I am running select statements to get results from an SQL dB >> >> >> >> Then looping through the rs object and populating temp tables with the >> results - >> Then I am 'binding' my forms to these temp tables for display >> >> >> >> This all works fine - no Prob - I was just wondering if it is possible to >> cut >> out the middle man - >> >> >> >> I mean ditch the temp tables and somehow populate a continuous form with >> the >> various results straight from the rs object >> >> >> >> EG Select AccountNo, AccountName, ContactPerson from tblAccounts may >> return >> say.10 records each with 3 fields of data >> >> >> >> How then do I get these results from the rs object in code into a >> continuous >> form without populating a temp table first? >> >> >> >> Also - Are there any advantages doing it this way or is using a temp table >> perfectly reasonable? >> >> >> >> Many thanks in advance >> >> >> >> Have a great day >> >> >> >> Darren >> >> >> >> >> >> -- >> 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 > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com