Shortcut Menu 923 not working

[Dave47]

I have a right click shortcut menu which works well. All options work except ControlButton Id 923 which does nothing.
It works on other Databases. Have done lots of comparisons between between them and and now am lost as to where to go next.
I am using Office 365 on Windows 10 and 11.
Help!!!

 

[Pat Hartman]

ID923 is a pretty high number. Are you possibly reaching the control count limit for a form and running into a problem of corruption. There is a fixed number of controls you can add to a form. Access keeps count even when you delete a control you don't need. I've never gotten anywhere near this high a generated number but then I've never added/deleted that many controls to a form - ever.

 

[isladogs]

@Pat Hartman
Whilst your comments about control limits on a form are correct, they are irrelevant here.
The OP is referring to FaceIDs not the number of controls

@Dave47
Are you sure the 923 value is correct for the intended purpose on your current version of Access?
Perhaps you could supply a reference link for this value.

 

[Dave47]

Thanks for the replies.
I am using the correct references (Office Object Libraries 16.0).
I open a various reports in print preview and use the right click menu to close them.
I copied the code from other databases that work perfectly as does the 923 ID.
All the other ID's in the code work.

 

[isladogs]

I assume you mean Microsoft Office 16.0 Object Library reference.
Once again, can i ask you to explain where you got 923 from?

 

[Dave47]

Found a few years ago at:
"access-programmers.co.uk/forums/attachments/accesscontrols-xlsx.67523/"

Although the symptoms point to an incorrect ID, 923 has worked for a long time and still does, just not on this database.
I do not think the coding or references are wrong as the other ID's on the "Right Click Menu" work.

 

[Isaac]

per https://bettersolutions.com/vba/ribbon/face-ids-2003.htm it does not appear face id 923 is a valid one ?

 

[Josef P.]

Tested: ID 923 (not FaceId) will only work in Print Preview not in Report View.

 

[Dave47]

Thanks for the replies.
I have knocked up a very small, crude database which is attached to which shows that the code works.
If one of you is really bored then you could have a quick look to see what the end result should be.

I can only assume that there is something else stopping it in the main database.
I created a new one and copied everything in to it and got another failure.
I might now create a blank database and import a few bits at a time to see if I can find where the problem is.

 

[arnelgp]

test this you can use the shortcut on Report View and Print Preview.

 

[Dave47]

Thanks arnelgp.
It does the job and gets me out of trouble.

I will still have to find why the "Close Report" option works on other databases and why just that one option on the menu does not work.
Self imposed punishment but we don't like to be beaten.