Re: [MSAccessProfessionals] drawing with Access

That was a fantastic presentation, Crystal – thank you!!  I also appreciate all the hard work and research you put into the reference page.  I'm sure that will be a very useful resource for many, no matter what their level of expertise.

 

I really dived deep into report drawing about 20 years ago when I wrote a database app for a client that used engineering tables to design steel buildings based on customer parameters.  The design part (e.g. choosing the appropriate gauge of beam depending on the span) was difficult enough, but then they decided they wanted scale drawings to be produced of the building plan and all the elevations.  How on earth was I going to do that in little ol' Access???  Anyway, I finished up producing very satisfactory drawings using all the tools you described in your presentation.

 

You said you would welcome some feedback.  I have just a couple of suggestions stemming from some points raised in the Q&A – both to do with chemistry rather than Access:

1. As was pointed out, the number of neutrons in the nucleus is often not the same as the number of protons (the atomic number).  In fact, the atomic weight is the average total of protons plus neutrons across all isotopes.  Therefore you can get an average number of neutrons from:
   CInt(AtomicWeight) - AtomicNumber
2. Someone (I think his name was Paul) was asking about how you filled the orbitals (shells) for transition elements.  There is a very good page here that might help you to represent it more realistically:
   https://chem.libretexts.org/Bookshelves/Inorganic_Chemistry/Supplemental_Modules_and_Websites_(Inorganic_Chemistry)/Descriptive_Chemistry/Elements_Organized_by_Block/3_d-Block_Elements/1b_Properties_of_Transition_Metals/Electron_Configuration_of_Transition_Metals

 

Thank you once again – I love your work! 😊

 

Cheers,
Graham

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of crystal (strive4peace) via groups.io
Sent: Sunday, 12 June 2022 08:56
To: MSAccessProfessionals@groups.io
Subject: [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