Recent content by DaveCollins181

Thanks everyone for the answers detailed above. I will give these a try as soon as I get a chance. David :)

I have two tables. 1) Suppliers 2) Purchase Orders - Has order date field Suppliers is linked to Purchase orders via the Supplier ID field. I want to query all suppliers who have not placed an order in over 2 years. Can anyone assist with the query formula? Thanks, David.

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: Programs and Features Right‐click the Microsoft Office product you want to repair, and select Change. From the "How would...

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...

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

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.

The attached thread on Microsoft indicates there is a known issue. https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_win10/ms-access-2016-pop-up-tools-stuck-on-screen/de46a5a8-780c-463c-b52c-9f6f3b0ccf96

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.

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...

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...

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...

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...

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...

Thanks, I'll give that a try. I also tried print to PDF and that seems to work fine. Don't know what's gone wrong with the export menu, could be a windows update that has affected it?

The following problem has recently started occurring within my access database: I right click on a report and select Export I select PDF or XPS and publish to the desktop The export menu remains on screen and I cannot work with the database until I restart it? This has only started occurring...