<

Bar Graphs in an Access Query

Posted on
6,434 Points
234 Views
2 Endorsements
Last Modified:
Published
Experience Level: Beginner
7:10
crystal (strive4peace) - Microsoft MVP, Access
Love empowering people by teaching and helping them develop applications.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.

Hopes this gives you ideas on visualizing your data in new ways ~

Video Steps

1. Create a calculated field in a query

2. Use Cint to convert to integer for the number of repititions

3. use ChrW(9600) for the Unicode upper half block character

4. use String to repeat a given character a number of times

5. Color the graph by setting the column Format to something like [Blue]@


   colors: Black, Blue, Green, Cyan, Red, Magenta, Yellow, or White
   @ signifies that the value is text
2
0 Comments
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. To get started, learn the basics.
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA. In this part: Encryption.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month