UtterAccess.com
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
> UtterAccess Uav4 - Moving Day
Posted by DougY - Aug-5-20 - 4 replies
The big day is here. On Saturday, August 8th 2020, we will be moving to our new home, UAv4.

We will start the process at 4AM EDT (GMT-4) and expect to be done by 4PM (16:00) EDT. During the transition, the forums will be offline (there may be brief periods of us being online, but for all intents and purposes, we’re offline). We will post updates on our Twitter account (https://twitter.com/UtterAccess).
Read 271 times - Reply   print fwd
> Office Update Bug For Decimal Fields
Posted by jleach - Jul-1-20 - 3 replies
An FYI, from the Access Team's Ebo Quansah:

QUOTE
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:

QUOTE
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 1831 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 4582 times - Reply   print fwd
> Recommended sites and books
SitesBooks
Access Team BlogMicrosoft Access Small Business Solutions
Access Dev CenterProfessional Access 2013 Programming
Access 2013 Inside Out
> Online
908 users active in the past 60 minutes
Active Users897 guests, 11 members
ahrefs.com, AlbertKallal, bing.com, brandwatch.net, DougY, Google.com, grapeshot.co.uk, isladogs, javirafy, jleach, MadPiet, mail.ru, OCM, orange999, rfikes, sonarman, SSellers, webmeup-crawler.com, yandex.com
Custom Search


RSSSearch   Top   Lo-Fi    7th August 2020 - 03:38 PM