Access User Group – Europe

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
 
Last edited:
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 video of Peter's excellent session is available on YouTube:
 
Last edited:
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!
 
isladogs said:
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!
Click to expand...

Towards the end, during the "quiz", the question was
Which is faster:
A. Saved Query
B. SQL Statement
C. QueryDef

What is the difference between A and C?

VERY impressive presentation, BTW.
 
Hi
I'm using query def to denote a query created temporarily for the purpose.
For example

Saved query:
Currentdb.Execute "qryAppendData"

Query def
strSQL = "INSERT INTO tblData ( a ) SELECT tblSource.a FROM tblSource;"
Set qdf = db.CreateQueryDef("", strSQL)
qdf.Execute dbFailOnError

Similar code is available using DoCmd as well

For more details, suggest you look at my article and the code used in accompanying example app:
www.isladogs.co.uk

Speed Comparison Tests 6

This article compares the use of saved queries, query SQL and query definitions. It is the sixth in a series of articles discussing various tests done to compare the efficiency of different approaches to coding. Example databases are provided so the tests can be done on your own workstations
www.isladogs.co.uk www.isladogs.co.uk

Thanks for the feedback. It seemed to go well
Will hopefully edit the video for uploading tomorrow or over the weekend

EDIT:
The files used are now on the AEU website (available to subscribers only) and on my own website (available to all) at
www.isladogs.co.uk

AEU-7: Optimising Queries and the JET ShowPlan

Colin Riddington demonstrated ways of optimising queries and the use of speed tests to compare performance. In addition, two tools were demonstrated: JET ShowPlan was used to show query execution plans and ISAMStats to measure disk reads
www.isladogs.co.uk www.isladogs.co.uk
 
Last edited:
The video of my Optimising Queries & the JET Show Plan presentation on 7 Sept is available on YouTube:


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

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:


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

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 (@GPGeorge) 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:


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

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 use the session to demonstrate ways of personalising 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!
 
Just a quick reminder that the Access Europe meeting is TODAY at 18:00 UK time (about 40 minutes from now

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

Hope to see some of you there!
 
you're welcome and thanks, Colin @isladogs -- most excellent presentation. You're a great teacher. Glad I was there to get my questions answered (amazing how small those static images are) -- and also nice for camaraderie with you and others who love Access. Happy you're sharing your demo database, that obviously many hours, days, and months went into 💕 -- it will be useful down the road, and enables folks to see how the logic is implemented. Also appreciate all the links. Overall, it was brilliant! I will also watch the video on YouTube once its posted to glean even more -- and definitely Like it

Lovely to see @jdraw and @Minty there too ... and who else?
 
Last edited:
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!
 
There are many conventions for naming forms & subforms.

Karl has chosen to use the form name frmContinuousForm followed by _sfrm and a suffix to demote the instance e.g. frmHorContinuous_sfrm04
Whilst I personally use frm & fsub, the important point is to be consistent and clear, which in my opinion, his approach is.

As Karl doesn't ever visit AWF, he won't ever see your opinions.
I suggest you make a comment on YouTube where he may see it and respond if he wishes to do so.
 
Sorry but I'm actually less clear what you are saying than before

Again there are several schools of thought.
Some people always use a different name for the subform control & the actual subform it contains
Others (including myself) always use the same name for both.

Both are valid in my opinion. Problems occur when developers aren't consistent in the approach used
 
Tony,

Can you list steps to use the database to see your intended results/demo?
If I click command0 on form1 I get error 2452 invalid reference to Parent??
Had to adjust
Code: 
For Each Ctrl In Me.Parent.Controls
to
Code: 
For Each Ctrl In Me.Controls  'Parent.Controls
to get past the err.

But maybe I'm missing your intent. I do recognize that Form1 does not have a Parent.

jack
 
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
446
isladogs
isladogs
isladogs
Access Europe User Group - Wed 5 Nov: Using Power Automate with Office Apps (Ynte Jan Kuindersma)
Replies
2
Views
566
isladogs
isladogs
isladogs
Access Europe User Group - Wed 3 Sept: Version Control for the Sole Developer - Why it Matters (Adam Waller)
Replies
2
Views
507
isladogs
isladogs
isladogs
Access Europe User Group - Wed 1 Oct: High impact – Custom dialogs and mini-notifications (Marcus Dieterle)
Replies
2
Views
514
isladogs
isladogs
isladogs
Access Europe User Group - Wed 2 July: Faking ‘Non-Normal’ User Interfaces with Normal Data (Pete Poppe)
Replies
1
Views
687
isladogs
isladogs

Users who are viewing this thread

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