[AccessD] CDec behaviour in SQL and VBA

[Gustav Brock]

Perhaps I could address the issue here:

<quote>
Call us crazy (we are!) but we're excited to announce that we're going to attempt what has really never been done before - a live Customer Bug Bash.

On July 15th, join us in the new (temporary) public Yammer group and file your issues on Office 16 desktop apps on Yammer and see your bugs triaged in real time! We're getting to the end game and want to ensure that we've got good coverage on all aspects of the product.

We'll also be doing load testing in an attempting to bring down the new real-time co-authoring functionality by getting as many sessions going at a single time as we can!

The localization team in Ireland will also be present and are specifically looking for localization feedback especially in East Asian languages.

And, of course, there will be all kinds of SWAG to give away! We'll also share pics from the big room where we'll all be gathered!

Download the .ics and full details  here. We look forward to seeing you there!

Warm regards,
Office Pre-Release Programs Team
Beth, Linda, Renee, Steve, Tom, Wendy and Wynne
</quote>

The link is (requires Microsoft login): 
http://connect.microsoft.com/office/Downloads/DownloadDetails.aspx?DownloadID=58503

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Gustav Brock
Sendt: 10. juli 2015 15:00
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] CDec behaviour in SQL and VBA

Hi Jim

Thanks, but the link to the MS source seems to be broken.

Still, I cannot imagine what a second parameter of CDec could specify? 
Setting the count of decimals seems not to be the purpose as the result of the conversion always is zero.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD [mailto:accessd-bounces at databaseadvisors.com] På vegne af Jim Dettman
Sendt: 10. juli 2015 14:23
Til: 'Access Developers discussion and problem solving'
Emne: Re: [AccessD] CDec behaviour in SQL and VBA


 Found it:

http://rdsrc.us/Nmczv0

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Friday, July 10, 2015 08:00 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] CDec behaviour in SQL and VBA


 Yes and no.  When your using SQL, it runs through an expression service
while VBA does not.   The procedure calls in the expression service can be
different than what's in VBA and there have been minor differences over the years in that area (SQL vs VBA).

 I had a long drawn out thread with Bret Spalding on EE at one time. I'll see if I can't dig it out.

Jim.

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Friday, July 10, 2015 04:49 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] CDec behaviour in SQL and VBA

Hi all

Weird. I know Decimal is claimed to be buggy, but this is beyond "buggy", I
think:

http://stackoverflow.com/questions/31327402/cdec-in-access-sql-is-not-behavi
ng-the-same-as-when-used-from-access-vba

I can reproduce the described behaviour in Access 2013.

/gustav