Search results

If you are interested in the above SQL <=> VBA converter, please note that the versions in that thread date back to 2018. The latest version is available as a free add-in from: https://www.isladogs.co.uk/sql-to-vba-back-again/index.html

No I'm not 100% certain whether its 60 or 64. I've seen both quoted in articles over the years UK mains frequency is 50 Hz (averaged over time depending on load and again subject to fluctuation) but numerous tests I've done with various timers show intervals in apparent multiples of 0.016...

I tested a variety of timers several years ago including the high resolution timer. Unfortunately, though it is precise to at least 0.1 microseconds, it is less accurate than several other timers which have a theoretical precision of 1 millisecond. In reality most timers are subject to the...

Yes I realise that but you could use a lookup table to get the value you want from each command button. Or just use a similar naming convention for buttons and field names e.g. FieldName and cmdFieldName.

When you check for version / build info, use the values next to the About Access button Do NOT use the info seen when you click on the button as that is often different and refers to the mso.dll library rather than Access itself. The only info that you want from there is the Office bitness...

You are doing an excellent job at evangelizing! I was just trying to encourage you to potentially double your audience 😎 I wish I had the time to be fully involved in the excellent work you are doing but at the moment that isn't possible for me due to my other commitments. However, I am trying...

Oops. I am well aware of this but obviously must have tested in the default report view. My bad! Here is the moderm chart report in the MDB file with an unexpected issue in the Chart Title! 😏

Adam will also leading a presentation for Access Europe User Group in September where his focus will be on how source code control can also be very useful for sole developers My reason for suggesting a 64-bit VM is to give you time so you can convert all your code to work in both 64-bit and...

REMINDER - Access Europe User Group meeting - WED 4 JUNE @18:00 UK time Our presenter is Domenico Ruggiero. See post #1 for full details and connection info

That's one reason why I didn't convert it as I can't keep up with your prolific postings!

Agree with @DHookum that the code should be in the Report Detail_Format event but also that the code doesn't do anything in that event either I believe there are limitations with report code but am not aware of any changes in 2019/2021 When I said my not all my example charts would work in...

@AHeyne Thanks for converting the APIs. Were many changes needed in Type statements and variable declarations in procedures? @jwcolby54 Although you should check for yourself you must be running 32-bit Office as you would be getting compilation errors yourself in 64-bit. My advice would be to...

Modern charts do work on reports and since March 2025 (Current Channel) now have full VBA support . . . in A365 ONLY Have a look at my article and example app at: https://www.isladogs.co.uk/modern-charts-code/index.html The modern charts code included will work in reports as well as forms but...

I would say you are putting off potential readers by being 32-bit only - not just me! The proportion of developers using 64-bit is increasing all the time and surveys at Access DevCon etc suggest its now probably the majority. Whilst those who need it may be willing to do the conversion...

Correct. That can be useful or a nuisance depending on what you are trying to do. I use transparent buttons for many purposes. For example, see https://www.isladogs.co.uk/paint-me-transparent/index.html @ClaraBarton One way of getting the name of any control, including hidden or transparent...

@jwcolby54 Your example app is 32-bit only. There don't seem to be many declarations needing conversion. What about variable definitions in procedures and type statements which I haven't checked

Clever but I think it would be very distracting. So I agree, that, although possible, it wouldn't be a good idea. Of course, the active tab is already highlighted with a red line at the top - does it really need anything more?

@Thales750 It’s available from the link in post #1 https://isladogs.co.uk/aeu-30

I knew I had been involved in a similar discussion before The thread below was started in 2007 and the last post (by me) was in 2019 https://www.access-programmers.co.uk/forums/threads/change-icon-next-to-form-caption.123449/ In short, it is possible to set individual form icons in overlapping...

@strive4peace Crystal Link was incorrect. It should be: