[AccessD] Form Totals and SQL Recordsets

[David Emerson]

Thanks for the reply Gary,

Sounds like what I am ending up doing  (putting a subform in the Form Footer
which populates the fields based on a stored procedure which returns the
totals.)

Regards

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Gary Kjos
Sent: Thursday, 12 April 2018 11:08 a.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Form Totals and SQL Recordsets

Typical no information error code.  I would try to simplify what the
control is supposed to be displaying... Perhaps by a saved query or
maybe even a stored aggregate table just to take some other things
like naming conventions and dots verses bangs or Exclamation or
whatever BS has changed between Access versions.

On Wed, Apr 11, 2018 at 4:24 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:
> Hi Listers,
>
> I have an accdb which uses recordsets based on SQL stored procedures to
> populate forms.
>
> One form is set to "Continuous Forms" which has columns of numbers. In the
> form footer under each column are fields for column totals.
>
> The control source for the total fields look like this:
> =Sum(Nz([SLOPSOpeningBalance],0)).
>
> SLOPSOpeningBalance is the field name.  txtSLOPSOpeningBalance is the
> control name for the records.  txtSLOPSOpeningBalanceSum is the name of
the
> form footer control.
>
> The form footer control shows #Error.  The main records all show correct
> values and there are no nulls.  I am converting this database from an adp
> which worked fine (but the records came from the Record Source property)
>
> I haven't found a solution on the web for this.  The closest solutions I
> have come up with is to write code to populate the totals, or to put a
> subform in the Form Footer which populates the fields based on a stored
> procedure which returns the totals.
>
> Has anyone come across this before?
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com