Recent content by isladogs

Very clever. As you will know from our discussions, I thought it wasn't possible to interact with the message box contents after opening. I believed that as they are modal, the messages by definition could only be static. In the next couple days, I will be publishing my own example which uses...

OK so what version / build does it work in and which version / build broke it? Which update channel are you on?

Also have a look at this example by Neil Sargent: Horizontal Continuous Form The example was a modified version of an app by Karl Donaubauer demonstrated to the Access Europe User Group in Jan 2023: https://isladogs.co.uk/aeu-11/index.html

As stated in post #28, certain 'safe' autoexec macro actions will run even when databases are not trusted. In fact, safe actions still run even where all macros are disabled in Access options

@MajP has already answered the question that you asked me so I’ll focus on the autoexec macro. First of all you can have both an autoexec macro and a startup form. Several things arise from this. 1. Contrary to what many people believe the startup form runs before the autoexec macro. If you...

This lists the startup form name Sub ShowStartupForm() On Error Resume Next Debug.Print CurrentDb.Properties("StartupForm") End Sub To set a form as startup using vba Sub SetStartupForm(FormName As String) Dim db As DAO.Database Dim prp As DAO.Property Set db = CurrentDb...

I strongly recommend looking at the interactive Gantt charts created in Access by Aleksander Wojtasz. He demonstrated these to the Access Europe User Group on two occasions, most recently in 2024 https://isladogs.co.uk/aeu-31/index.html The video of both sessions are also on YouTube. This is...

It is indeed very sad news. Jack was one of the first developers I met when I joined various forums. Always kind and supportive, Jack brought out the best in other people whilst being very modest and self effacing about his own skills and achievements. In addition to AWF, Jack was also a...

You might find it worth reading my series of three articles on how relationships work and different ways of creating them This is the first in the series: https://isladogs.co.uk/relationships1/index.html

Thanks Tom I've retrieved the chat and saved it as a new page in the link above. It should now be OK

I asked CoPilot to extend Tom's comparison by also including the VBE_Extras Office add-in which I now use the most of all three tools https://copilot.microsoft.com/shares/pages/cJn38XMW6dtrCrxbr6xsD EDIT: Fixed link above

I also like the clipboard listener approach. It works well though I can see the table getting very large in just a short period of time. As nobody has mentioned it so far, I'll point out that Windows also has a built-in clipboard history feature that works for both text and images. You can...

I agree. Also consider reusability / transferability - if you want to reuse one or more of those API dependant functions / modules in another database, do you really want to transfer the entire monster API module (modWinAPI) or indeed check what is needed from that module However, that is a lot...

@mellamokb Good news. Microsoft have responded to the comments made by you & others on this issue. First of all, there is a new(ish) MSLearn article (last updated 2 Mar 2026) with additional information and guidance...

I agree with removing the old VBA6 #Else blocks which are now redundant. This should be done not just in API and variable declarations but also in function headers. Doing all this will simplify the code and make it more readable. However I would also advise abandoning the rest of your plan as...