Recent content by isladogs

OK thanks. My email address is below. All being well, I'll post the file back in the thread as a 64-bit ACCDE

Can you explain why the container count shows Forms = 0 in both screenshots for post #36 when there are clearly 2 forms visible in both cases. Also are you able to provide a 64-bit version of General.mde so I can look at this simple example?

The video of Adolph Dupré's presentation to the Access Europe User Group on Wed 3 Dec is now available on YouTube: I hope you enjoy it You can also download a PDF of the slides and the example app used in this presentation from https://www.isladogs.co.uk/aeu-46

If you do choose to look at the emulated split form, there is a newer version available on my website https://isladogs.co.uk/emulated-split-form/index.html For variations on the idea, see my companion article https://isladogs.co.uk/simulated-split-form/index.html

The tests do indeed shows that using "1" instead of "*" results in a slightly faster record count as @arnelgp stated. However, for some reason he omitted testing the indexed ID field so I added 2 more tests on that for comparison: Private Sub t() Dim s#, e#, r& s = Timer...

@xavier.batlle The reason why the second test doesn't become faster is that by referencing a non indexed field (Country), Access cannot make use of the indexing on the Region field or the primary key field (ID) The other two tests do make use of the indexing. Speaking of indexing, @arnelgp's...

I floated that idea as a possibility almost a year ago. See https://www.access-programmers.co.uk/forums/threads/dynamic-reusable-forms.333127/page-3#post-1948644. I didn't get a response to my post at the time. I was then, and remain now, unclear as to what exactly @Imb means when he describes...

Hi Tom Thanks for checking. I thought both came later. Although Monaco wasn’t in 2021, I’m confident having that enabled won’t be the problem. Nor would using newer types of modern chart.

If you ever ticked the large integer or extended date time options in 365, these will change the database structure permanently even if you later disable them.

???

Out of curiosity, as I can't recall myself, what was your username at UA and when were you active?

The song "She" was originally by Charles Aznavour and was covered by Elvis Costello for the rom-com film Notting Hill

Perhaps you were confusing @ColinEssex with myself. We are both from the UK but aren't the same person! I was banned from UA (my username at that time was ridders) around 2019. Apparently it was for questioning why the owner had censored some posts in a thread both by myself and the OP. The...

I last used this code around 2018 and can't remember the details of what I changed / added. I don't have the time to go through and check for differences. The reason I'm not sharing my code is that without spending time to check (which I don't have), I'm not sure whether that would undo the...

I've been away for a few hours. Yes I do have code that does all that and have used it in more than one commercial app with a time-limited evaluation version. However I've not published the system date check code online. What I will share is my notes from that code including the link that got...