MS Access 2010 - Right Click - Text Filters And Export Menu Remains On Screen

[DaveCollins181]

MS Access 2016 - Right Click In Field On Popup Form - Shortcut Menu Remains On Screen

I have an issue with my database which has just started in the last week. Our users often right-click in a field and select the Text Filters option or the Export To option in reports. The problem is that the menu remains on screen and the front end database has to be closed to make it go away. This is occurring on our new Windows 10 PC's. When I try from an older windows 7 PC it works fine. I guess a windows 10 update is to blame? I have tried compacting and repairing both the back end database and front end database but the issue remains. Has anyone else come across this problem?

 

[CJ_London]

I'm using win10 with access 2010 32bit and not experiencing any problems. Do you have any code which might be preventing the shortcut menu from closing when the control loses focus?

Something else to try is to decompile the front end to get rid of lots of rubbish (run access with the /decompile switch, then open the front end (preferably without running code). then compact and close. Then reopen normally and compile the code before compacting again.

 

[DaveCollins181]

Hi CJ, thanks for the reply. My database is very basic with not much code running in the background. I saved the company database and brought it home to try on my laptop which also runs windows 10. It works fine on the laptop. I'm intending to try a repair on MS Office 2016 tomorrow incase some other software or update has affected the main program. I have already tried logging out of malware bytes to see if that was the cause but it didn't fix the problem. I also left my work PC installing the latest windows updates before I left work this eve. Hopefully the repair will work tomorrow, I'll update this post. Thanks again. Dave

 

[DaveCollins181]

I spoke with our computer support company. It seems the issue is with Windows 10 and popup forms/reports. If I set the form or report property Popup to No, then the right click menu works fine within any field. So part solved but still need to find a solution as there are a lot of popup type forms/reports within the database.

 

[CJ_London]

well, all my forms are popups because I hide the database window, still don't get a problem. The only way I can replicate is set the form shortcutmenu property (on the other tab) to no.

 

[DaveCollins181]

Hi CJ, I see setting shortcut menu property to No stops the right click menu system altogether. What is strange is that it is only the 2nd level off the shortcut menu that causes the issue. If I right click in any field, I can select options off the immediate menu and the shortcut menu closes when I move away. If I click to the 2nd level like Text Filters>Contains, the shortcut menu remains on screen until I close the database.

 

[CJ_London]

if I right click on a text control, select say text filters, as soon as I select an option (e.g. begins with) both menus disappear and I get a custom filter box open to enter the parameter.

Have you tried decompiling the front end? and then compacting?

Other things to consider is whether you are using reserved words in table, field, control and function/sub names - they can have unexpected consequences.

Also does each user have their own copy of the front end? or are they all using the same one? If the latter, you may have introduced a small corruption.

 

[DaveCollins181]

Hi CJ - I just tried creating a new database and the Shortcut menu issue also occurs on that. The shortcut menu stays up on popup forms and reports when the 2nd level is selected from the menu. I'm thinking its a Windows 10 issue as our Windows 7 PC's are not affected. I have installed all the latest Windows 10 updates but the issue remains. It was all working fine until a week ago. I can workaround the search in other ways but its a shame as the shortcut menu worked well. Thanks for the assistance you have given in trying to resolve this.

 

[CJ_London]

sorry I couldn't be more help - but can't replicate your situation and can't find anything online from someone experiencing the same problem.

I've attached a very simple db with three forms - continuous, datasheet and single. All popup and all shortcuts work as expected on my system (win10, access 2010 32bit all updates up to date)

If you experience the same problem, agree this indicates something to do with your setup - might be access client settings, access/office implementation or win10, but I would be inclined to discount the latter since no one else seems to have a problem.

Suggest you talk to your computer support company and see what references they are referring to to make their claim that the issue is with Windows 10 and popup forms/reports.

 

[DaveCollins181]

Hi CJ. just done a test on your DB and it does the same thing (See Screenshot). I'll go back to our computer support company to see if they can run any other checks on our system. Thanks again.

 

[DaveCollins181]

The attached thread on Microsoft indicates there is a known issue. https://answers.microsoft.com/en-us...n-screen/de46a5a8-780c-463c-b52c-9f6f3b0ccf96

 

[CJ_London]

interesting, the first shortcut menu should open with top left at the mouse position.

 

[DaveCollins181]

MS Access 2016 - Right Click - Shortcut Menu Remains On Screen

Yes CJ, definitely something strange going on here. Hopefully Microsoft have an update fix shortly.

 

[CJ_London]

interesting it is affecting your setup, but not mine - but as you point out, a known issue - are you (or your support company) ATEC1? since the question was only posted today!

 

[DaveCollins181]

I'm not sure if our support company is ATEC1? I have not heard of ATEC1?, would this help if they were?

 

[CJ_London]

ATEC1 is the username of the person who asked the question

 

[DaveCollins181]

Re: MS Access 2016 - Right Click - Text Filters And Export Menu Remains On Screen

Sorry had my Friday afternoon head on with ATEC1 I posted my question on the Microsoft Community and received the same answer as ATEC1 (See attached). So I guess I'm stuck until they release the fix. On the plus side, work finishes in 1-hour and its the weekend

 

[DaveCollins181]

I managed to fix this issue by using a method submitted by a user on the Microsoft Community. His instructions were to carry out an online repair from the control panel:

1. Programs and Features
2. Right‐click the Microsoft Office product you want to repair, and select
3. Change.
4. From the "How would you like to repair your Office Programs" screen, select Online Repair to make sure everything gets fixed, and then select Repair.
5. Follow the instructions on the screen to complete.

This worked for me. Please make sure you have your office licence key to hand as you will have to activate your copy of office after the repair is complete. Hopes his helps others.

Regards, David.