[AccessD] [EXTERNAL] Re: Bug in Access 365

Shane Groff shaneg at microsoft.com
Fri Apr 9 17:28:14 CDT 2021


Thanks for the report, Borge.

-----Original Message-----
From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com> On Behalf Of Jim Dettman via AccessD
Sent: Friday, April 9, 2021 1:53 AM
To: 'Access Developers discussion and problem solving' <accessd at databaseadvisors.com>
Cc: Jim Dettman <jimdettman at verizon.net>
Subject: [EXTERNAL] Re: [AccessD] Bug in Access 365

Borge,

    I will pass it along.

Jim.

-----Original Message-----
From: AccessD On Behalf Of Borge Hansen
Sent: Thursday, April 8, 2021 11:36 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: [AccessD] Bug in Access 365

Hello everyone,
Since I know some of you have direct communication to the MS Access developer team I am sharing this reproducible bug (?) we came across for further examination. Perhaps there is a plausible explanation as to why Access crashes?

Create a Form - Popup and Modal - and link to a table with some text On Timer event remove the Access Window so only the Form is visible using Dev Ashish's fSetAccessWindow function...

With the Form open and Access Window hidden and focus on the text control, do a Shift-F2 to view the text in the text control in the  "Zoom window".
Now on the "Zoom Window" click on "Font..." to modify either font type or size... well you won't get far - as MS Access immediately crashes.

I have created a small test app, downloadable here:

https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2F1drv.ms%2Fu%2Fs!AuEUskPv7jG8hV3kBHOHtpb4Wi3E%3Fe%3DmuChhl&data=04%7C01%7Cshaneg%40microsoft.com%7Cd6e8256e3aa741e6bc0308d8fb34e9a2%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637535551983736067%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=p80HPkvQCGqeg1XQjMJJe3Xnr5wGN%2BobhH4hoHrCATY%3D&reserved=0

With Shift Key down you can open and examine the form and code behind.
Otherwise the accdb opens frmTest on startup.

I came across this anomaly when comparing our app on a MS Access 2016 platform versus MS Access 365. The Zoom Window on the newer version of MS Access can now be resized, whereas in MS Access 2016 you cannot resize it.

We are using Dev Ashish's fSetAccessWIndow code and were modifying the ShowWindow api call for 64bit:

Global Const SW_HIDE = 0
Global Const SW_SHOWNORMAL = 1
Global Const SW_SHOWMINIMIZED = 2
Global Const SW_SHOWMAXIMIZED = 3

Declare PtrSafe Function apiShowWindow Lib "user32" _
  Alias "ShowWindowAsync" (ByVal hWnd As LongPtr, _
  ByVal nCmdShow As Long) As Long

'20210409 bsh deprecated
'Private Declare Function apiShowWindow Lib "user32" _
    Alias "ShowWindow" (ByVal hWnd As Long, _
          ByVal nCmdShow As Long) As Long

The text on the frmTest is also from Dev Ashish's website - !

Have a great day,
/borge
--
AccessD mailing list
AccessD at databaseadvisors.com
https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatabaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=04%7C01%7Cshaneg%40microsoft.com%7Cd6e8256e3aa741e6bc0308d8fb34e9a2%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637535551983736067%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=9nGSfmhKwZwxAjlqi4INC1altKg4fnTx2djerRrQtcQ%3D&reserved=0
Website: https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.databaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7Cd6e8256e3aa741e6bc0308d8fb34e9a2%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637535551983741057%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=AO07rUCTo%2Fs%2B9FJf%2FUG67syK2PhXllUcLMtncf%2Bqp9U%3D&reserved=0

--
AccessD mailing list
AccessD at databaseadvisors.com
https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatabaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=04%7C01%7Cshaneg%40microsoft.com%7Cd6e8256e3aa741e6bc0308d8fb34e9a2%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637535551983741057%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=BYAETGwRtS1QzgCfBwh22Ucs4R7m2%2Bmqka%2BIIx74U%2F4%3D&reserved=0
Website: https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.databaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7Cd6e8256e3aa741e6bc0308d8fb34e9a2%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637535551983741057%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=AO07rUCTo%2Fs%2B9FJf%2FUG67syK2PhXllUcLMtncf%2Bqp9U%3D&reserved=0


More information about the AccessD mailing list