Draw Dials, Stoplights, and Rounded Rectangles on Access Reports
draw dials, stoplights, and rounded rectangles in Access

Draw Dials, Stoplights, and Rounded Rectangles on Access Reports

New gadgets you can use on Access reports to visualize your data! All gadgets can be sized and positioned. Many have colors you can change and some are dynamic to graphically display values.

Access can draw complex objects using a few simple methods. Get the VBA code and databases with sample reports.

Dial

https://msaccessgurus.com/VBA/Draw_Dial.htm

Draw Dials that range in color from red to orange to yellow to green with a needle pointing to a fraction or percentage value that you send.?

Stoplight

https://msaccessgurus.com/VBA/Draw_Stoplight.htm

Draw Stoplights showing green for 1, yellow for 2, red for 3, or nothing lit for anything else.

Rounded Rectangle????

https://msaccessgurus.com/VBA/Draw_RoundRectangle.htm

Draw a Rounded Rectangle. While you might draw rounded rectangles on their own, more often they would be part of another drawing, such as part of the stoplight housing. Drawn with 4 lines and 4 arcs. When the arc radius is relatively large, you get some interesting effects.

DevCon

Thursday + Friday, April 27 + 28, 2023

Today, Tuesday 25 April, is the last day to register for DevCon, a huge annual Access conference open to the world. It's organized by Karl Donaubauer with help from Peter Doering and Philipp Stiefel . Join me, Access experts, and developers who love Access. I'm presenting Draw Gadgets on Access Reports, hope you can come. It's virtual, so you can join from anywhere!

DevCon Speakers: https://www.donkarl.com/devcon/agenda.htm

Register for DevCon: https://www.donkarl.com/devcon/register.htm

If you can imagine it, Access can do it. Contact me for one-on-one remote training.

kind regards, crystal


#dial #stoplight #msaccess #microsoftaccess #dev #developer #office365 #m365 #creative #draw #mvp #mvpbuzz #mstips #programming #elearning #tutorial #accesstips #Database #report #visualization #vba #data

要查看或添加评论,请登录

crystal (strive4peace)的更多文章

  • Use Access to Show or Hide in Word

    Use Access to Show or Hide in Word

    I put the things that I show or hide most when I'm using Word on an Access form. This saves time and frustration…

    4 条评论
  • Change 365 Version for Office

    Change 365 Version for Office

    I recently had an issue with 365 forgetting who I am (it had the wrong account) and also the January 7 rollout (which I…

    4 条评论
  • Monaco SQL Editor for Access

    Monaco SQL Editor for Access

    The long-awaited Monaco SQL Editor to help you visualize your queries is rolling out for Microsoft Access. Those on 365…

    1 条评论
  • Dive into, and Document, Access Relationships and Indexes

    Dive into, and Document, Access Relationships and Indexes

    Relationships define how tables are joined. A common method is to join an AutoNumber primary key in the parent table…

    7 条评论
  • Valuable Video Vessel

    Valuable Video Vessel

    Videos help you visualize and learn. When you find a great channel on YouTube and want to play all their videos, how do…

    4 条评论
  • Write Access Query to Word Bookmark

    Write Access Query to Word Bookmark

    See an Access query in a Word document, written after a bookmark in a pretty table. Download the code from…

    2 条评论
  • How Does Sorting Work with VBA?

    How Does Sorting Work with VBA?

    How does sorting a list of values work? It's easier than you might think. Bubble Sort is a simple method.

  • See your Queries better

    See your Queries better

    Get a list of all the query names in your Access database, along with what type of query each is. Do you ever want a…

    17 条评论
  • Visualize Access Relationships with Words

    Visualize Access Relationships with Words

    The relationships diagram in Access is a great way to see what's in your database, but how can you get a list of the…

  • Make Access Tab Control Pages come alive

    Make Access Tab Control Pages come alive

    Tab Controls are a great way to organize information on your busy Access forms. They have Pages where you can place…

    6 条评论

社区洞察

其他会员也浏览了