[AccessD] CDec behaviour in SQL and VBA

[Gustav Brock]

Hi Shamil

That could be the case. The link is from an e-mail.

Would this work for you:

    https://connect.microsoft.com/office/Downloads/

A login to Microsoft Connect seems to be needed.

/gustav

________________________________________
Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af Salakhetdinov Shamil <mcp2004 at mail.ru>
Sendt: 10. juli 2015 22:35
Til: Access Developers discussion and problem solving
Emne: Re: [AccessD] CDec behaviour in SQL and VBA

 HI Gustav --

I have logged in to MS Live but the link you posted ( http://connect.microsoft.com/office/Downloads/DownloadDetails.aspx?DownloadID=58503 ) didn't work for me:

<<<
Page Not Found

The content that you requested cannot be found or you do not have permission to view it.

If you believe you have reached this page in error, click the Help link at the top of the page to report the issue and include this ID in your e-mail: 9c9f1b64-3817-48ce-bb13-e64b65c2f026

Microsoft Connect welcome page.
>>>

Does it need any special privileged MS Live login?

Thank you.

-- Shamil

>Friday, July 10, 2015 2:42 PM UTC from Gustav Brock <gustav at cactus.dk>:
>
>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-behaving-the-same-as-when-used-from-access-vba
>
>I can reproduce the described behaviour in Access 2013.
>
>/gustav