|
|
Use VBA to draw gadgets that respond to your data on Access reports. Reports don't have to be boring lists with lots of numbers. Visualize.
Objects can be modified by specifying colors and angles. Graphs are drawn differently depending on the data.
Gadgets are scaled for the available space and positioned where desired. This is a compilation of VBA code you can look at, learn from, and use in your Access projects.
live presentation for Access DevCon 2023
Go to Report Draw Reference for VBA syntax and help for drawing on Access reports.
The link for each gadget has VBA code. You can also download a zipped ACCDB Access database with code for lots of gadgets. DrawGadgets_s4p__ACCDB.zip
Remember to unblock the ZIP file, (remove Mark of the Web) before extracting the file(s). Here are steps to do that: https://msaccessgurus.com/MOTW_Unblock.htm
Links to pages with information and VBA code
Graphs Goto Top |
|||||||
Dial |
Draw Dials with a needle point to a fraction or percentage value.
|
||||||
Gantt chart |
Gantt chart to be released in the future It is still in progress. The Project tables it needs to store data, as well as main/subform is done. Also done is the report menu form to launch the Gantt report -- it just isn't hooked up yet. Check my website in the future for a working Gantt chart. |
||||||
Meter |
Meters are great to visualize fractions and percentages. Choose colors, font size, send value.
|
||||||
Stoplight |
Stoplights with green, yellow, or red (or nothing) lit up.
|
||||||
Objects Goto Top |
|||||||
Flag |
American Flag
|
||||||
Moon |
Draw a Moon given the fraction of light and whether it is waxing or waning. Movement goes from right to left then down and right to left again.
|
||||||
Rainbow |
Draw full rainbow, or partial rainbows from start to end angles
|
||||||
Rounded Rectangle |
Set outline color, draw width, and amount of rounding for corners — drawn with 4 lines and 4 arcs. When the arc radius is bigger than the shape dimension, you get some interesting effects.
|
||||||
Snowflake |
Set snowflake and background colors, specify angle to rotate
|
||||||
Snowman |
Set colors for body, hat, buttons, eyes, and outline.
|
||||||
Solstice |
Draw Earth on its orbit around the sun as its positioned for the December Solstice
|
||||||
Tree |
easy tree types to draw
|
Report Draw Reference for VBA syntax and help for drawing on Access reports.
VBA drawing code with links to more pages with code to draw on your Access reports. If you can imagine it, Access can do it!
I'm fascinated with the power that Access has for drawing on reports ... and it's lots of fun! So this is for all the dreamers that love beautiful things.
Here's the link for this page in case you want to copy it and share it with someone:
https://msaccessgurus.com/presentation/Report_Gadgets.htm
or in old browsers:
http://msaccessgurus.com/presentation/Report_Gadgets.htm
Let's connect and team-develop your application together. I teach you how to do it yourself. My goal is to empower you.
While we build something great together, I'll pull in code and features from my vast libraries as needed, cutting out lots of development time. I'll give you lots of links to good resources.
Do you want your reports to be more creative and visual?
I'd love to help you.
Email me at training@msAccessGurus
~ crystal
the simplest way is best, but usually the hardest to see