Aug 03 2021 07:06 AM
Aug 03 2021 07:06 AM
Aug 03 2021 09:22 AM
Did you import the images to be image library?
This seems an unnecessarily complicated approach. Why not just use conditional formatting for the back colour of the text boxes containing the number values?
OR....if you really must use circles...then you could use circular command buttons of different colours. ..though this would only work in report view
Aug 04 2021 12:17 AM
Aug 04 2021 02:22 AM
The screenshot was done in Access 365 but the same functionality is in A2010 onwards:
Create a button and then go to the Control Formatting section in the Format menu
Select the ellipse shape and make the button width = height to create a circle. Use the Shape Fill to select the colour you want.
Its easy enough to do...but I still think its an overcomplicated approach. However its your choice!
Aug 04 2021 02:49 AM
Aug 04 2021 03:04 AM
Aug 04 2021 05:35 AM
Perhaps your boss thinks its quick and easy to do?
If he/she is really prepared for you to spend several hours getting this to work, then you will have to solve your original issue (error 2424) with making circular images visible/hidden or use circular buttons as described and in report view only.
Perhaps the error 2424 is just due to you incorrectly referring to the name of one or more images
It may be easier to manage if you import the images into the Image Gallery as below
If you do this, the images will be stored as attachments in a hidden, system table MSysResources.
However, only do so if the image file sizes are small (or you will bloat the database)
Aug 04 2021 05:54 AM
Aug 04 2021 06:13 AMSolution
One thing at a time if you don't mind...please post your crosstab query question in a new thread
I had a flash of inspiration based on something similar I've done in the past
So I have a solution for your report issue & I hope your boss is happy with the result!
It will work in report view or print preview
The coloured circles are in fact a Webdings character which is a solid black circle by default
I've then applied conditional formatting to these depending on the value of the number field
Chr(110) is in fact the letter 'n' in a standard font as you will see from the enclosed query
Aug 04 2021 06:19 AM
Aug 04 2021 11:58 PM
Aug 05 2021 12:07 AM
Aug 05 2021 01:16 AM
Aug 05 2021 03:07 AM