SOLVED

Access User Group – Europe

MVP

Access Europe (AE) is a new online chapter of AccessUserGroups.org. Further details are available from https://accessusergroups.org/europe/

All meetings will be on the first Wednesday of each month from 18:00-19:00 (UK time – currently UTC/GMT) and will be co-chaired by Alessandro Grimaldi & myself (Colin Riddington)

Whilst Access Europe is intended to be at a time suitable for residents of European countries, the meetings are both free and open to all

The first meeting on Wed 2 March will be used to introduce ourselves and explain the purpose of the group, explain how to use the various tools on the Access User Groups website and provide more details about the group as a whole.

We hope you will join us for our first meeting and help ensure the new Access Europe chapter is a success

https://accessusergroups.org/europe/event/access-europe-2022-03-02/

It is intended that Access Europe will largely focus on innovative and lesser-known features in Access.

During the first meeting, there will be short presentations by both Alessandro and Colin as a ‘taster’ of what to expect from future meetings. The session will also provide an opportunity for those attending to suggest possible topics of interest for subsequent meetings.

 

We already have an exciting range of speakers and topics booked for the coming months, starting on Wed 6 April with Chris Arnold who will be demonstrating his new and very powerful Access Studio application.

Please sign up to get notified about details of future events

19 Replies
best response confirmed by isladogs (MVP)
Solution

The thread is for information and, as such, has been posted in several locations.

Many thanks for your 'support'.

Connection details for the meetings are now available on the Access Europe website:

https://accessusergroups.org/europe/event/access-europe-2022-03-02/ 

 

Just a reminder that the first Access Europe session is tomorrow :

Wed 2 March @ 18:00 UK time (UTC).

 

The meetings will be held on Zoom.
You can connect using: Access Europe Connection Info

 

If you are asked:
Meeting ID: 924 3129 5683
Passcode: 661210

 

I hope you will be able to join us!

The video of the first meeting has now been published on YouTube:
https://youtu.be/pHUZrdOKwFA

Please register if you want to be notified about future events.
Next meeting: Wed 6 April @ 18:00 UK time (UTC+1). Chris Arnold will be demonstrating his Access Studio app

A reminder that the next Access Europe meeting will be on Wednesday 6 April from 18:00-19:00 UK time (currently UTC+1)

The session will be presented by Chris Arnold who will be demonstrating his new and very powerful Access Studio application.

For more details, see:
Access Europe – Chris Arnold (Access Studio) – Europe – AccessUserGroups.org

The meeting will again be held on Zoom. You can connect using:
Join our Cloud HD Video Meeting

If you are asked:
Meeting ID: 924 3129 5683
Passcode: 661210

I hope you will be able to join us!

The video of Chris Arnold's Access Studio presentation to last week's Access Europe meeting is now available at: https://www.youtube.com/watch?v=d3LITmaqc10

The next Access Europe meeting will be on Wednesday 4 May at 18:00 (6PM) UK time (currently UTC+1).
This is equivalent to 19:00 (7PM) in Central Europe / CEST (UTC+2) and 10AM in Seattle / PDT (UTC-7)
For other local times, see https://www.worldtimebuddy.com/

The session will be presented by Crystal Long who will be comparing Classic vs Modern Charts in Access.

CoverSlide.PNG

Here is one of Crystal's example charts: 

chart_ClusteredColumn_Category_Line_Total.png

For more details about the event, see:

https://accessusergroups.org/europe/event/access-europe-2022-05-04/


The meeting will again be held on Zoom. You can connect using:
Join our Cloud HD Video Meeting


If you are asked:
Meeting ID: 924 3129 5683
Passcode: 661210

I hope you will be able to join us!

 

 

The video of Crystal's presentation to last week's Access Europe meeting is now available on YouTube: https://youtu.be/iTryE5nUSC8

The next Access Europe meeting will be on Wednesday 1 June at 18:00 (6PM) UK time (currently UTC+1).
This is equivalent to 19:00 (7PM) in Central Europe / CEST (UTC+2) and 10AM in Seattle / PDT (UTC-7)
For other local times, see https://www.worldtimebuddy.com/

The session will be presented by Alan Cossey who will be demonstrating his Standard Module Object Generation utility (SMOG)

For more details (and clear the SMOG!), see: Access Europe – Alan Cossey (SMOG) – Europe – AccessUserGroups.org

The meeting will again be held on Zoom. You can connect using: Join our Cloud HD Video Meeting

I hope you will join us!

The video of Alan Cossey's excellent presentation to last week's Access Europe meeting is now available on YouTube: 

https://www.youtube.com/watch?v=gTRt-fxwAJA 

 

The Standard Module Object Generation (SMOG) add-in and supporting files are also now available free to all Access Europe subscribers from: 

https://accessusergroups.org/europe/member-dashboard/ 

The next Access Europe meeting will be on Wednesday 6 July at 18:00 (6PM) UK time (currently UTC+1). This is equivalent to 19:00 (7PM) in Central Europe / CEST (UTC+2) and 10AM in Seattle / PDT (UTC-7). For other local times, see https://www.worldtimebuddy.com/

The session will be presented by Mike Wolfe who will be demonstrating how to Build Ribbon Interfaces in Code. For more details, see: Access Europe – Mike Wolfe (Building Ribbon Interfaces in Code) 

The meeting will again be held on Zoom. You can connect using: Join our Cloud HD Video Meeting. I hope you will join us!

NOTE:
As a taster to whet your appetite for the AEU session, Mike has also written several articles recently on this topic at his No Longer Set website.
Have a look at the 5 articles from last week dated June 20 through to June 24

The video of Mike Wolfe's excellent session on Building Ribbon Interfaces in Code which he presented to last week's Access Europe meeting is now available on YouTube: https://www.youtube.com/watch?v=MS2yfOXsa-c

The sample app and PDF of his presentation are also now available free to all Access Europe subscribers from: https://accessusergroups.org/europe/member-dashboard/


These can also be downloaded from https://nolongerset.com/ribbon/

The next Access Europe meeting will be on Wednesday 3 August at 18:00 (6PM) UK time (currently UTC+1).
This is equivalent to 19:00 (7PM) in Central Europe / CEST (UTC+2) and 10AM in Seattle / PDT (UTC-7)
For other local times, see https://www.worldtimebuddy.com/

The session will be presented by Peter Cole who will be demonstrating how to do 32 to 64 bit conversion in Access. For more details, see: Access Europe – Peter Cole (32 to 64 bit conversion)

The meeting will again be held on Zoom. You can connect using: Join our Cloud HD Video Meeting
I hope you will join us!

 
 

 

 

The next Access Europe meeting will be on Wednesday 7 Sept at 18:00 (6PM) UK time (currently UTC+1).
This is equivalent to 19:00 (7PM) in Central Europe / CEST (UTC+2) and 10AM in Seattle / PDT (UTC-7)
For other local times, see https://www.worldtimebuddy.com/

 

This month, I will be doing a presentation on Optimising Queries and the JET ShowPlan
For more details, see: Access Europe – Colin Riddington (Optimising Queries and the JET ShowPlan)

 

The meeting will again be held on Zoom. You can connect using: Join our Cloud HD Video Meeting
I hope you will join us!

The video of my Optimising Queries & the JET Show Plan presentation to Access Europe on 7 Sept is now available on YouTube:
https://www.youtube.com/watch?v=mVe3InnJaAE

-------------------------------------------------------------------
The next Access Europe meeting will be on Wednesday 5 Oct at 18:00 (6PM) UK time (currently UTC+1).
This is equivalent to 19:00 (7PM) in Central Europe / CEST (UTC+2) and 10AM in Seattle / PDT (UTC-7)
For other local times, see https://www.worldtimebuddy.com/

 

This month, my co-chair Alessandro Grimaldi will be doing a presentation on Cataloguing and searching emails with Access
For more details, see: ​https://accessusergroups.org/europe/event/access-europe-2022-10-05/

 

The meeting will again be held on Zoom. You can connect using: Join our Cloud HD Video Meeting
I hope you will join us!

The video of Alessandro Grimaldi's presentation to Access Europe on 5 Oct is now available on YouTube:

https://www.youtube.com/watch?v=x0ddewwT358

-------------------------------------------------------------------

The next Access Europe meeting will be on Wednesday 2 Nov at 18:00 (6PM) UK time (UTC)

IMPORTANT: Clocks in the UK and Europe revert to winter-time this coming weekend but those in the USA do not

So this will be equivalent to 19:00 (7PM) in Central Europe / CEST (UTC+1) and 11AM in Seattle / PDT (currently UTC-7)

For other local times, please check https://www.worldtimebuddy.com/

 

This month, we are pleased to have ex-MVP George Hepworth (@GroverParkGeorge) leading a presentation on PowerApps for Access Developers.

It promises to be a very interesting and innovative session covering areas that many access developers may not be familiar with

For more details, see: https://accessusergroups.org/europe/event/access-europe-2022-11-02/

The meeting will again be held on Zoom. You can connect using: Join our Cloud HD Video Meeting

I hope you will join us!

The video of George Hepworth's excellent presentation to Access Europe on 2 Nov is now available on YouTube:

https://www.youtube.com/watch?v=3n63LllshIg

-------------------------------------------------------------------

The next Access Europe meeting will be on Wednesday 7 Dec at 18:00 (6PM) UK time (UTC)

This is equivalent to 19:00 (7PM) in Central Europe / CET (UTC+1) and 10AM in Seattle / PDT (UTC-8)

For local times, please check https://www.worldtimebuddy.com/

 

This month, I will be running a presentation on Annotating Google Maps in Access

I will demonstrate ways of personalise downloaded maps for your clients. Topics to be covered will include the use of:

  • marker points e.g. to mark client locations or nearby places
  • lines joining 2 or more points e.g. to indicate routes between locations
  • circles around a location e.g. to show places of a specified type within a specified distance from a set location
  • boundary shapes e.g. to show postcode or regional boundaries
  • feature styles e.g. to mark major & minor roads and points of interest

All annotations are added as additional map layers using code as part of the URL used to generate the map.

The session will also explain how to overcome issues caused by the 2083-character URL limit using the current web browser control based on IE (whilst we continue to wait for the new Chromium Edge browser control). An example database will be provided in conjunction with the session

For more details, see: https://accessusergroups.org/europe/event/access-europe-2022-12-07/

The meeting will again be held on Zoom. You can connect using: Join our Cloud HD Video Meeting

I hope you will join us!

The video of my presentation to Access Europe on 7 Dec is now available on YouTube:

AEU: Annotate Google Maps in Access (Colin Riddington) - YouTube

 

The next Access Europe meeting will be on Wednesday 4 Jan 2023 at 18:00 (6PM) UK time (UTC)

This is equivalent to 19:00 (7PM) in Central Europe / CET (UTC+1) and 10AM in Seattle / PDT (UTC-8)

For local times, please check https://www.worldtimebuddy.com/

 

I am very pleased to announce that Karl Donaubauer (long time MVP, organiser of Access DevCon and the Access News videos) will be running a presentation called A baker’s dozen of tips, tricks and tools in 60 minutes

 

As the topic title indicates, the session will be used to demonstrate about a dozen of Karl’s favourite tips, tricks and tools. It may also be 14 or 16…

 

Anyway, if you think you already know everything about Access, you’ve come to the right place.
Karl is constantly collecting techniques, tools, solutions and explanations that you don’t hear and read everywhere. This time for example:

• Access/VBA settings overlooked for decades
• how to program Access properties in VBA that don’t exist in VBA
• how to get return code (exit code) from external programs
• finally, the horizontal continuous form
• a tool to generate & integrate QR codes at the push of a button
• a tool that generates professional related test data
• context menus without right mouse, colours in combo and list boxes… and other small stuff

 

For more details, see: https://accessusergroups.org/europe/event/access-europe-2023-01-04/ 

The meeting will again be held on Zoom. when the time comes, you can connect using: Join Zoom Meeting
I hope you will join us!

The video of Karl Donaubauer's excellent presentation to Access Europe is now available on YouTube

A collection of 15 tips, tricks and tools for Access in 60 minutes.

Even if you think you already know everything about Access, this video is guaranteed to show you something completely new or that you've forgotten.

https://www.youtube.com/watch?v=k9jgkzG2IaU

 
 

 

 

This month's session was led by long time Access developer and MVP, Karl Donaubauer and was used to demonstrate 15 of Karl's favourite tips, tricks and tools. Karl is constantly collecting techniques, tools, solutions and explanations that you don't hear and read everywhere. This time for example:
1 best response

Accepted Solutions
best response confirmed by isladogs (MVP)
Solution

The thread is for information and, as such, has been posted in several locations.

Many thanks for your 'support'.

View solution in original post