X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Microsoft Access Help Forums
The premier Microsoft Access help forum with Visual Basic, SQL Server, Office and more! Members are able to post questions and help others with problem solutions. UtterAccess has been seen in over 160 countries, recording over one billion hits to date. Microsoft Access Tables, Queries, Forms, Reports, Pages, Macros, Modules...you'll find all the free samples and answers here!

Registered members have access to all the file attachments that UA is pleased to provide. An added bonus along with many other features such as Access sample databases, professional Access code samples, file uploading, private messaging and forum subscriptions...all this for those who take a moment to sign up...(Your personal information is kept completely confidential and everything is truly free of charge!)

Over 250,000 members have signed up at UA to enjoy well over 2,500,000 posts - proving UtterAccess.com is the only source for help with Microsoft Access...and more!
> Additional UA Navigation
Discussion ForumsCode Archive Table of ContentsThe Microsoft Access WikiNewcomer's Reading List
Today's Active TopicsHow to post a good questionContact UADifferences in Access Versions
> Office Update Bug For Decimal Fields
Posted by jleach - Jul-1-20 - 3 replies
An FYI, from the Access Team's Ebo Quansah:

Very soon, we will ship a new data type, known as Date & Time Extended, which enhances syntax compatibility with SQL while increasing accuracy & level of detail in date & time records.

While the feature is not yet enabled in Current Channel builds, most of the code for the feature is in the product in an inactive state. Nonetheless, we are aware of a problem that currently exists with this new code. As of today, if you are on version 2005, build 12827.20010 or greater, and you manipulate Decimal fields (Access DataType=Number/FieldSize=Decimal, or SQL DataType=Decimal) using DAO (Data Access Objects), you might have identified your app crashing. If you hover a variable with the type in VBA code, you may see that the field is not being displayed properly; either reading as ‘?????’ or giving a Type Mismatch error, or Access may crash.

We are very sorry for the inconvenience this causes in your Access app. The Access team is working on resolving this issue as soon as possible, and we will report back to you once this error has been fixed. In the interim, we’d recommend for you to roll back to a previous version (https://support.microsoft.com/en-us/help/2770432/how-to-revert-to-an-earlier-version-of-office-2013-or-office-2016-clic), or switch to a slower channel (e.g Monthly Enterprise Channel, or SemiAnnual Channel), until the issue is fixed in Current Channel. The issue only impacts Decimal types so if avoiding DAO code that manipulates Decimal types is possible, we’d advise this as a short term solution.

Thank you,

Ebo Quansah

As per usual, Daniel has collection some information and references here: https://www.devhut.net/2020/06/08/access-ve...using-problems/

And, a fix/workaround posted by MS here: https://support.microsoft.com/en-us/office/...en-us&ad=us

As of 6/24:

This is now fixed in all affected channels.

For Current Channel, version 2005, the issue is fixed in build 16.0.12827.20470. You may need to force a manual update to get the new version.

For Current Channel (Preview), version 2006, the issue is fixed in build 16.0.13001.20198.
Read 1681 times - Reply   print fwd
> Update On V4 Software
Posted by jleach - May-11-20 - 9 replies
Hi all, I hope everyone's staying healthy and sane of mind through these interesting times.

A while back I posted about some planned updates to UA, and wanted to recap on that. We had planned to have a beta release of the v4 software by the end of Q1 this year. Of course, March and April brought some unexpected challenges for many people, and our timeline for this project suffered a bit due to it.

As of now, testing and refinement of the new software is picking back up, and we'll shortly be inviting people that want to help with beta testing in a closed environment. I don't currently have a target release date in mind, but expect that it will be some time in June.

Stay safe and be well.
Read 4514 times - Reply   print fwd
> Access Devcon 2020 - Virtual Conference
Posted by DougY - Apr-16-20 - 1 replies
Access DevCon Vienna 2020 is now a virtual event. The event includes sessions and presentation by various Access developers from Europe and the USA. Ebo Quansah, the Access Dev PM will be presenting in the conference.
The conference if free to attend, but you must register, and there is a max of 250 attendees.

Access DevCon takes place on Thursday and Friday, April 23 and 24, 2020. Sessions will start at 7:00 a.m. PST until 12:00 noon PST on both days.

For more details, and pictures from prior events go to http://www.donkarl.com/devcon/virtual2020.htm
Read 5341 times - Reply   print fwd
> Recommended sites and books
Access Team BlogMicrosoft Access Small Business Solutions
Access Dev CenterProfessional Access 2013 Programming
Access 2013 Inside Out
> Online
808 users active in the past 60 minutes
Active Users794 guests, 14 members
ahrefs.com, Alexander, bing.com, brandwatch.net, Brepea, cheekybuddha, DanielPineault, DavidG3276, DougY, FrankRuperto, Google.com, grapeshot.co.uk, GroverParkGeorge, isladogs, kfield7, MadPiet, mail.ru, mrdrjay, Ranks, theDBguy, webmeup-crawler.com, yandex.com
Custom Search

RSSSearch   Top   Lo-Fi    4th August 2020 - 06:13 PM