[MSAccessProfessionals] drawing with Access

in case you want to learn about drawing with Access, or get a refresher, here's the link to the presentation about that for George Hepworth's last Access Pacific meeting

AP: Drawing Shapes in an Access Report - Elements and Atoms (1:20:28) by crystal (strive4peace)
https://youtu.be/FVJx2BGrKu8

The sample data is basic chemistry -- the elements that compose all matter. It doesn't matter what the data is -- Access is great at managing any kind of information!

Access draws

    The Periodic Table of the Elements (standard data set or a specialized one) -- Line and Print
    Atoms with a set number of protons and neutrons in the nucleaus and electrons orbiting around -- Circle and Print
    several reports showing examples of how to use the LINE and CIRCLE methods (filter Navigation Pane for Line or Circle -- more sample in the download than at the time of this presentation) and the effects of various property settings like FillStyle, DrawStyle, and DrawWidth.

You can download the ACCDB here:

http://msaccessgurus.com/VBA/ReportDraw_Reference.htm

Near the top is Downloads and Documents where you can get the ACCDB database and see examples of things Access drew in various images and documents.

This web page has my rewritten and simplified explanation* of syntax for drawing methods such as Line, Circle, and Print. It might seem like you can't do much with just a few methods --- oh but you can!

* please, if you notice where something is said wrong or should be clarified, let me know.

There is information for other drawing methods such as points (PSet), and using TextWidth and TextHeight so you can calculate, for instance, where the middle of text will be so you can position CurrentX and CurrentY to its beginning location for Print.

There is information for several properties you can read and write when drawing, useful functions, order of events, about syntax used, units of measure, and more.

Please comments and share your ideas, thanks

kind regards,
crystal

On 6/2/2022 7:09 PM, crystal (strive4peace) via groups.io wrote:

hi Bill,

thanks for your kind reply. It will be recorded! And free for all to watch on YouTube.

AD has a beautiful soul, and posted many awesome things for Access. I'm certainly humbled to be compared with him in some way ~

kind regards,
crystal

On 6/2/2022 6:08 PM, Bill Mosca wrote:

Hi Crystal

 

I saw your announcement in LinkedIn. What a cool presentation this is going to be! I've done some interesting things with reports using VBA. AD Tejpal (http://www.rogersaccesslibrary.com/forum/tejpal-a-d_forum45.html ) Showed us quite a lot of ways to push Access reports. Your presentation certainly will rank right up there with his work, I have no doubt.

 

Unfortunately, I won't be able to attend. Any chance of this being recorded for our members?

 

Regards,

Bill Mosca

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Thursday, June 2, 2022 3:23 PM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] free in a few hours? Want to learn about drawing with Access?

 

hi everyone,

I'm giving a presentation tonight on drawing with Access on reports.

meeting link:

https://accessusergroups.org/pacific/event/257-2022-06-02/

Access Pacific online user group

DATE: 2 June 2022, Thursday (today!) -- Friday for those down-under

TIME: 6:30 pm Pacific, 7:30 pm Mountain, 8:30 pm Central, 9:30 pm Eastern, middle of the night for Europeans, ...

Drawing an Access Report

You're probably familiar with reports that use controls to contain text and other objects such as lines and boxes, but how do you create a report on a blank canvas with no controls?

Learn how to create an Access report where everything is drawn and written using VBA.

Use the Line Method to draw lines and rectangles, which can be filled with any color, and have any color for the border.

Use the Circle method to draw circles, ellipses, and arcs (open and closed). Like Line, any color can be used to fill closed shapes.

Use the Print method to write text. Do you want to add a shadow? Simply print the shadow text, then offset the starting coordinate and print the main text.

Hope you can make it!

Everyone is welcome.

kind regards,
crystal