Search results

You're welcome. I loved the Reveal Codes feature in the old WordPerfect! Ah it was only 35 years ago or thereabouts.

I also wrote this up as a new article on my website today: https://www.isladogs.co.uk/tab-ctrl-page-caption-issue/index.html The priority given to fixing issues depends on the number of users affected and the seriousness of its impact. In this case it almost certainly affects very few users and...

@riktek For info, I've just reported this issue to the Access team but I doubt whether it matters enough for them to fix. As already stated, this is purely a display issue related to the original tab control with no themes. It looks odd but doesn’t affect functionality. There is also an easy...

If you need to store all previous names and date changes then a child table with a 1 to many relationship is required. However, it sounded like you were only saving the last name change.

Why not use a field PreviousName together with NameChangeDate in your main table? Both fields null unless a change has occurred

Agree that Philipp's contribution was very valuable. Its critical tone certainly made me question some of my earlier comments. Unfortunately, Microsoft do not appear to have any documentation for exactly what End should do in that error dialog I had searched for it unsuccessfully. Nor is it...

@sonic8 Whilst I think it better to wait for an official response, here are my initial thoughts on your post In fact it also happens in A97 - I didn't check back any further Agreed - not as clear as I had intended I meant that in older versions up to 2003, the form was able to unload...

OK hopefully you'll get a helpful response from Shane who will definitely know how each part of that dialog should behave.

Themes also affect the behaviour of the MultiRow Tab Control Header - see my article linked above for an explanation

I disagree and, so far, I see nobody else supporting your viewpoint Just to be clear, as I'm sure you are aware, the “End” button you're referring to is part of the standard VBA unhandled error dialog—not a VBA command being executed. When no structured error handling is present (On Error GoTo...

You can use labels or buttons to simulate tab controls or navigation style forms The main reason why I moved to the latter is because only one subform is ever loaded at a time whereas with tab controls, all objects are loaded into memory whether or not they are currently displayed There are...

OK, rather than go around the same points repeatedly, I've tested again in two older Access versions A2007: form stays open as in later versions A2003: form closes on clicking End. That means the End action wasn't correctly applied as code was allowed to run despite the fact that it should...

I hadn’t mentioned it in this thread but it is true that I now largely avoid tab controls for various reasons. These days I use my own home made simulated navigation forms (not the built-in version)

Sorry I missed the comment about using A2019. Whilst I don’t have that it’s basically the same code base as 2021/2024 and 365 Someone in the thread at UA suggested that turning themes on fixed the issue. Have you experimented with that? Also just a thought… are you experiencing the issue in...

As already stated, files only become blocked if downloaded from the internet or saved from an email attachment. Therefore the answer to both questions is No

Have a look at the code in the HTML email example in my CDO Email Tester app. https://www.isladogs.co.uk/email-tester/index.html

As the ACCDE file is created on your PC, you won't need to unblock it again. Indeed you won't see the Unblock text or checkbox in the Properties dialog. However if you distribute it via email or the internet, others will still need to unblock it

It seems this is just one of the many ways that Access has overall improved since the dim and distant days of A2007. Anyway, I don't know which version of Access that @riktek uses but I can't replicate the issue in the versions I used for testing.

I had a look at your example app but it demonstrated exactly what I had already tested in both 365 & 2010. My opinion remains unchanged - it is not a bug for the reasons I stated in post #10 In older versions of Access, certain code was allowed to run that no longer does so. Over the years...

A quick test would have shown that it doesn't fix it. As the unload event cannot complete, the form doesn't close. The point is that its neither new, nor is it a bug. Its just code error and easily fixed by adding error handling or moving the code to the close event or of course including the...