Random "unhide this form" prompt

[CedarTree]

Hello. I am getting a seemingly out of the blue issue where Access prompts me to unhide a specific form ("tmpAccMonacoHwnd"). It happens when I close other forms generally. I tried importing all Access items into a new DB and still getting the issue. If I click Cancel, no harm (but annoying). If I click OK, Access crashes. Help!?!? Thanks!!!

 

[CJ_London]

I presume your firm is open but hidden. Have you got code in your other forms triggered when they close to set focus or reference that form?

 

[cheekybuddha]

("tmpAccMonacoHwnd")

Is that something to do with the new query editor?

Just a guess because of the form name.

 

[CedarTree]

That's the thing - the name of that form is completely new/mysterious to me. Could my Access install be corrupted?

 

[CJ_London]

Possibly - what happens with a form that has no code?

 

[xavier.batlle]

Try disabling the Monaco editor.

 

[CedarTree]

Try disabling the Monaco editor.

That seems to be it! Clearly an MS Access bug. Thanks!!!

 

[isladogs]

I’ve not experienced or heard of this issue. Can you upload an example database showing this effect. If I can reproduce the problem I will report it to the Access team

 

[CedarTree]

I will try when I come up for air!

 

[JohnC1939]

It has happened only today, when closing a small membership database, not accessible outside my network.

I have noticed a change in the SQL view of a query lately - is that related?
I just disabled the Monaco SQL editor (File/Options/Currentdatabase) and it no longer appears.
I don't mind the new look, but this is a definite bug, when no query windows are open.

 

[The_Doc_Man]

Whatever it is, Google & Gemini don't know about it yet.

 

[isladogs]

@JohnC1939
What is this change in Monaco query SQL view that you are referring to? Can you provide a simple repro database that shows the unhide window problem?

 

[Dave_D]

CedarTree, you are not alone!
We have a commercial Access front end linking to SQL, so, unfortunately I can't post that front end here. The system is install on probably north of 100 computers. Most are behaving correctly, we do however have a small number of clients who have reported issues of the past week(ish) and the issue in question? Unhide Window tmpAccMonacoHwnd. The way we've dealt with it is to just disable the Monaco SQL Editor.

 

[isladogs]

@Dave_D
Welcome to the forum.

Yours is now the third report of this bug which so far I have been unable to replicate.

Does it only happen with one Access front end or with several? Does it only happen with a SQL Server BE?
What is your Access version, build, update channel and bitness?

i am willing to report this as a Monaco bug to the Access team but so far details needed to get it fixed are lacking.
Are you able to supply a simple cut down repro database which shows the issue but without any sensitive data?

 

[sonic8]

Access prompts me to unhide a specific form ("tmpAccMonacoHwnd")

Just for the records...
I've recently seen the tmpAccMonacoHwnd window (not form!) in a window list on my computer*. I assume, it is perfectly normal that this window exist. However, the dialog asking to unhide that window makes absolutely no sense, as this window is not a normal Access object window but an internal thing that usually would never be displayed.

* For clarification: A window list in Spy++ not any build in window list of Access.

 

[Dave_D]

@Dave_D
Welcome to the forum.

Yours is now the third report of this bug which so far I have been unable to replicate.

Does it only happen with one Access front end or with several? Does it only happen with a SQL Server BE?
What is your Access version, build, update channel and bitness?

i am willing to report this as a Monaco bug to the Access team but so far details needed to get it fixed are lacking.
Are you able to supply a simple cut down repro database which shows the issue but without any sensitive data?

The front end is linked to both a back-end mdb and SQL database, most tables etc are SQL based. The front end is deployed to individual computers or multiple different profiles if running on an RDS server. The affected machines are 32 bit Office, not sure of the exact version numbers, though probably 365. My pc uses 365, 64 bit, Version 2510 (19328.20158) however, I've not yet seen it on my set up. When I get chance to connect through to an affected client, I'll get proper details about build etc.

 

[Dave_D]

Stop Press!
Just forced an update to Office on my PC and I've got the window.

I'll do some digging, see if I can get anything more useful

 

[Dave_D]

I can force the window to appear. The sample code below is part of a much larger routine that closes any open forms, reports, queries - everything in fact. The code hasn't changed or been updated since 2007! Now the code triggers the window.
The cut down example code to trigger the window is

Public Sub ShowMeMonaco()
If SysCmd(acSysCmdAccessVer) > 11 Then
DoCmd.SelectObject acForm, "", True
DoCmd.RunCommand acCmdWindowUnhide
End If
End Sub

Call the routine from the immediate window

 

[isladogs]

Thank you. I can replicate that in A365 Version 2512 Build 19504.20000 Beta 64-bit and have informed the Access team.
I suspect that the hidden window is used by the Monaco speedy loading feature.

UPDATE
I got a response from the Access team within a few hours. The issue is being investigated