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

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