want to come to an online user group meeting?

Join us for a fun time. I, for one, am intrigued by this technique.
 
Presentation about Drawing in Access ... maybe you haven't really used these capabilities?

On Thursday (or maybe early Friday), @GPGeorge George Hepworth's group had a meeting about the drawing features for Access reports ... maybe you haven't really used these capabilities like you could? There's a lot you can do! And data can drive it.

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, Print
  • Atoms with a set number of protons and neutrons in the nucleaus and electrons orbiting around -- Circle, Print
  • several reports showing examples of various uses for the LINE and CIRCLE methods (filter Navigation Pane for Line or Circle -- more objects in the download than at the time of this presentation) and the effects of various property settings like FillStyle, DrawStyle, and DrawWidth.

elements_small.png
atom.png

The download and more information is here:

Report Draw Reference and VBA Syntax​

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.

Below that is a whole lot of information ... 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 before Print.

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

Someone mentioned mapping -- Colin @isladogs would have some ideas about that ...

Here is the video from the presentation recording

AP: Drawing Shapes in an Access Report - Elements and Atoms

Please comments and share your ideas. ... and more, @jdraw (thanks for being there)
 
Last edited:
Word Automation Deep Dive

Word Automation from Access VBA Deep Dive
Here is the video from the presentation. Thanks to those of you who were there live :)


Just as the title suggests, this is a deep dive into automating Word from Access. Understand key concepts in Word such as Application, Document, Range, Bookmark, Selection, Table, Cell, Style, Paragraph, Character, Templates, Building Blocks, ... and see what Access can make Word do! ... some things you might not even know about yet about Word. Lots of VBA and handouts (links in video description) you can use to pattern after when you write programs.
 
Last edited:
Word Document Properties and Fields

Not a presentation, but I just posted an interesting video on YouTube about using document properties in Word to substitute data in documents that you might like if you do a lot with Word:

Word Document Properties and Fields (14:06)
 
Crystal / Pat
Thanks to both of you for the positive feedback on this session

Responding to the 2 points raised by Pat:
1. HAVING vs WHERE - Yes I agree with the comments. I believe this was discussed in some detail at around 11:33 & again at 51:44

2. INDEXING - whilst indexing is generally important, you are correct that it is possible to end up with 'duplicate indexes' on the same field. However I believe that is only the case where the index properties have different values - Primary (Yes/No), Unique (Yes/No), Ignore Nulls (Yes/No).
If you manually set the index properties to be the same as Access believes should the case, then Access does not create another index.
 
for those of you starving for an online user group meeting to attend for Access ... Mike Wolfe (nolongerset.com aka @NoLongerSet ) posts an article each week about Access that includes online user group meetings that are coming up, as well as what's come to his attention for the past week that folks have posted about Access or VBA.

Here's the current link:
https://nolongerset.com/week-in-review-2022-10-22/

I try to keep this thread especially updated with links to meetings presented by those who post on AWF that sound interesting ... and most of us love anything Access!!

Please comments and share your ideas

kind regards,
crystal
 
Last edited:
Pat Hartman said:
Updating it a few days before the meeting and including the meeting link would be very helpful although you shouldn't be responsible for doing this, the meeting organizers should:) I tried to join last weeks europe meeting but the link I had in my calendar didn't work and I couldn't find a current one.
Click to expand...
There wasn't an Access Europe meeting last week - perhaps you meant Access Lunchtime?

As the organiser of Access Europe, I always send out reminders & connection info about a week before each meeting which are held on the first Wednesday of each month at 18:00 UK time (currently UTC)

The next meeting is on Wed 2 Nov - see info here: Access User Group – Europe | Page 3 | Access World Forums (access-programmers.co.uk) and here: Access Europe – George Hepworth (Power Apps for Access Developers) – Europe – AccessUserGroups.org
 
This week, UK is on standard time and America is still on daylight-savings time (we don't switch till next weekend) ... so

for Colin's meeting Wednesday TODAY! if you're used to going and think it is the same time ... the time is 1 hour later in America. George is presenting
https://accessusergroups.org/europe/event/access-europe-2022-11-02/
EDIT: meeting over now -- will post a link to the video once it is available.

for George's meeting Thursday, the time is 1 hour earlier in London -- this time only, instead of 2:30 am, it is just 1:30 am (Friday morning, lol). It is 6:30 pm Pacific time
https://accessusergroups.org/pacific/event/257-2022-11-03/

@isladogs @GPGeorge
 
Last edited:
recently ... this may be of interest to many of you:

Using SQL Server with Access, by Maria Barnes (1:02:31) read video description for links
 
The video of George Hepworth's @GPGeorge excellent presentation to Access Europe on 2 Nov is now available on YouTube:
AEU: PowerApps for Access Developers (George Hepworth) (1:04:36)
 
Colin @isladogs did a presentation today for Access Europe about rendering Google maps in Access, and adding drawings. Every time Colin does a presentation, I am awed. He's a great teacher with a lot of knowledge to share. Being a participant of the meeting also provides camaraderie with others who love Access. Surprisingly, considering that many hours, days, and months went into creating it, he posted his demo database, which will be useful to see how the logic is implemented. He also shared lots of links to learn. Overall, it was brilliant! I will also watch the video on YouTube once its posted to glean even more -- and definitely Like it, and post link here too

Lovely to see @jdraw and @Minty there too ... and who else?
 
Last edited:
-- Upcoming AccessUserGroup meetings --

Access Lunchtime – Loop and Link CSV Files - crystal (strive4peace)
February 28, Tuesday, 12 noon Central, 6 pm UK
https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-02-28/

Access Europe – Optimizing Queries in SQL Server - Maria Barnes
March 1, Wednesday, 6 pm UK, 12 noon Central
https://accessusergroups.org/europe/event/access-europe-2023-03-01/

Access Pacific - Bad Data is Bad for Business - Pat Hartman
March 2, Thursday, 6:30 pm Pacific, 8:30 pm Central
https://accessusergroups.org/pacific/event/bad-data-is-bad-for-business-with-pat-hartman/
 
If you missed Colin's (@isladogs) recent presentation, or were there and want to watch the video to better absorb some of the great stuff he shared, here it is:

AL: Translation Tools using Access - Colin Ridington (isladogs) (1:10:34)

Tomorrow, Tuesday, I will be presenting for Access Lunchtime. Join us live!

Loop and Link CSV Files - crystal (strive4peace)
February 28, Tuesday, 12 noon Central, 6 pm UK
https://accessusergroups.org/lunch/event/access-lunchtime-4-2023-02-28/
 
-- Recent presentations posted On YouTube --

AL: Loop and Link CSV Files in Access using Queries, by crystal (strive4peace) (54:51)

AEU - Optimizing Queries in SQL Server, by Maria Barnes (51:38)

AP: Bad Data is Bad for Business with Pat Hartman (1:07:18)

@Pat Hartman , @isladogs, @GPGeorge
 
Last edited:
You must log in or register to reply here.

Similar threads

isladogs
Access Europe User Group - Wed 3 Dec: Using Twilio for texting from Access (Adolph Dupré)
Replies
1
Views
456
isladogs
isladogs
isladogs
Access Europe User Group - Wed 5 Nov: Using Power Automate with Office Apps (Ynte Jan Kuindersma)
Replies
2
Views
570
isladogs
isladogs
isladogs
Access Europe User Group - Wed 3 Sept: Version Control for the Sole Developer - Why it Matters (Adam Waller)
Replies
2
Views
511
isladogs
isladogs
isladogs
Access Europe User Group - Wed 1 Oct: High impact – Custom dialogs and mini-notifications (Marcus Dieterle)
Replies
2
Views
515
isladogs
isladogs
isladogs
Access Europe User Group - Wed 2 July: Faking ‘Non-Normal’ User Interfaces with Normal Data (Pete Poppe)
Replies
1
Views
692
isladogs
isladogs

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom