Search results

Perhaps its the snip & sketch app. Try pressing the Windows key + Shift + S. Is that what you see?

I'm not aware of an alternative application that can be automated using VBA. Why not just export directly to PDF from Access and omit the mid step of Publisher completely? Otherwise consider purchasing an older retail copy of Publisher

Just for clarification, I think you meant Office was out of date. The OS version shouldn’t matter. AFAIAA, all the RegEx functionality from the VBScript library was ported to the VBA library though I haven’t needed to use it much myself in the past year or so. I haven’t heard of any missing...

Yes indeed… but only since version 2508. This is indeed useful, but more importantly it solves the problems related to VBScript being deprecated at some point in the not too distant future

Starting with version 2508, RegEx was included in the VBA Llibrary, so the VBScript library is no longer needed and indeed should no longer be used. The problem you are describing may be because you have some users on 2507 or earlier whilst others have 2508 or later. See my article...

If you really need higher precision than whole seconds, you can use the date time extended datatype in Access itself. That can display to 7 d.p. (0.1 microseconds) but, as already mentioned, it does have limitations.

Thanks Xevi @KitaYama For info, the link was also given in the pinned comment below the video

@mloucel You're welcome There is a further update coming soon where an optional countdown can be added to the new style Fluent UI timeout messages. Many thanks to @xavier.batlle for providing the original idea for this further addition.

The video of Peter Cole's very detailed presentation on using vbWatchdog and his Unleashed utility which was given to the Access Europe User Group on Wed 1 Apr is now available on YouTube: I hope you find it useful. The video also includes a link to a special offer price for both vbWatchdog...

Hi PJ. What kept you....

The message shown in post #11 clearly states that the issue is mixed installation types (MSI & C2R) as explained by @Jason Lee Hayes in #10. All versions prior to 2016 were MSI. Everything after 2016 is C2R. However Office 2016 existed in both versions and you must have an early MSI release...

@KitaYama I guess you missed the last line of @MadPiet's post:

Although the easiest solution is just to link to all tables required (as you have now done), it is also possible to create queries to external databases without linking tables using syntax such as: SELECT Field1, Field2, Field3 FROM [Full path to external database].TableName; For example...

Perhaps I’m missing something here. I see no reason why you can’t install any version of Visio (including 2016) whilst you have Office 2016 installed. No need to remove /reinstall Office There are restrictions in what you can also install along with Office 2016. You can’t install 2016 Runtime...

Good point. However, Office 2016 and 2019 both reached end of life support on 14 Oct 2025. Although Visio isn't part of the MS Office suite, it has the same dates for end of life support. The only retail versions still in support are 2021 and 2024.

@NauticalGent Glad you found it useful. To be honest I had forgotten about this thread and didn’t look at the non-working code in post #1 before creating my solution. In fact most of the code was from 2022 but it had one issue that I wasn’t happy with and put it to one side. I originally...

The fourth Access Europe User Group meeting for 2026 will be on Wednesday 1 Apr (April Fool's Day) starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). Please note that the UK will have changed to summer time (UTC+1). For local times, please check World Time Buddy This will be...

Ah yes, you would get error 438 if ActiveX controls are disabled in Access Options. Its one reason why I avoid ActiveX controls as far as possible Having said that, I do use the MS Forms ActiveX scrollbar in a couple of apps and without needing the MS Forms reference. For example; Its useful...

One of the main points about the navigation pane is that its use should be straightforward. However, for those who have never got used to the nav pane, I created an add-in. Perhaps it will help you? https://isladogs.co.uk/nav-pane-helper-addin/index.html

The instructions are definitely clearer now but the functionality is unchanged for me. To start the server successfully I have to step through the code one line at a time. I'm still unable to stop the server - even when I step through that code, Access stops responding. As before, I'm having to...