[AccessD] Getting Results from SQL SVR into a Continuous form

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



More information about the AccessD mailing list