Search results

You can change all the form & report icons to match the application icon However, that still doesn't provide individual icons for each tabbed document object As already mentioned, you could fake the effect but its not something I've ever found the need to do for tabbed documents as I don't...

There isn’t a built-in way of changing tab color in tabbed documents or indeed in the tab control. You could of course fake the effect if you really wanted to do so. As for your final comment, Access remains a major component in Office. It is still being actively developed with a steady...

Just to confuse matters, occasionally feature updates are also rolled out to versions that are out of support. That can be done as all C2R versions from 2016 onwards share the same code base but with some features disabled according to version. For example the new SQL query button will be...

For info, neither 2016 nor 2019 are still supported though obviously they will continue to work. The oldest supported version is currently 2021.

@AHeyne Following on from post #22, I have been in discussion with both @sonic8 and the Access team regarding timestamping a VBA project and run a number of successful tests. I can confirm that: By default, a timestamp is NOT added when a VBA project is signed The addition of several registry...

Clearly I only skim read the thread! No idea .... but I get no flicker with the use of the Detail_Paint event in my code / example app. I've been using that approach for 20+ years originally as a workaround for the then limit of 3 CF conditions

Although conditional formatting has a limit of 50 colours, a slightly different approach will allow an unlimited number of colours. Instead of using conditional formatting, all the colours are stored in a lookup table See my article and example app...

The next Access Europe User Group meeting will be on Wednesday 4 June 2025 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are very pleased to welcome a new presenter from the USA, Domenico Ruggiero (AKA The Software Maestro) who will be discussing...

What do you mean by a 'self-hosted runner'?

You should do this for yourself or you will learn nothing In design view, add a square command button where your photo will go. Go to the format ribbon and change its shape to circular. Adjust its size. Go to the property sheet and set the back style to transparent. If you want, set the border...

I don't have code to produce the dialogs from #7 but as already mentioned, both of the dialogs in post #9 are created using code.

That would only work if your circle was transparent! You might be able to get this to work by placing your image control behind a circular command button with a transparent background and a red coloured border. Here's a first attempt - adapt the idea to suit your needs

I hadn’t seen post #21 when I wrote this. I have now successfully added a timestamp to a file signed with a self cert. As that is valid until 2031, I have no means of checking it remains valid after expiry. However, as you have a valid certificate, you could easily test for yourself by...

The z-order was incorrect. In design view, select the photo then click Arrange. . . Bring to Front

Attached is the suggested solution from CoPilot which does indeed mention RFC 3161. I haven't tested the suggested solution with a self cert (in the absence of a current code cert,) but also have doubts about whether it will work For signing EXE files, I have been using a Sectigo time stamp

Although not identical, the custom color dialog created using VBA in my article allows you to select the color values using RGB or HSL https://www.isladogs.co.uk/show-color-dialog/index.html Or have a look at another of my articles: https://www.isladogs.co.uk/colour-converter/index.html

I do see the photo inside the circle Isn't that what you want?

As well as the color dialog that can be called using VBA - Show color dialog, there are several color dialogs including this from the property sheet: I assume you don't like that (or the VBA version) due to the standard colors section. But you can also use the more streamlined version from...

You've just raised the second major flaw with project signing Access files. Unlike adding a code signature to .exe files where I always add a timestamp, the code signing process within Access does not support timestamping and AFAIAA cannot be modified to do so when using certificates stored on...

The Access team haven't commented but suspect they would have responded if they disagreed with the consensus view. My code signing certificate expired recently and I haven't yet renewed it. You can download many signed files from my website e.g. from...