Access Europe – Adrian Bell (Custom Ribbons Using Command Bars)

Please join us for our monthly Access Europe session on Wed 4 Dec 2024 at 18:00 (6:00PM) London time (UTC)

You can click the button below to download a small calendar (.ics) file and add the meetings to your Outlook calendar.  This will add a recurring appointment to the first Wednesday of each month.

Outlook Calendar (.ics)

Topic outline:

Building on his recent presentation for the Access Pacific User Group in Sept 2024, Adrian will demonstrate how to create custom ribbons using command bars.

The video of the earlier session is available in the Access Pacific channel on YouTube.

Adrian will first demonstrate a technique based on the original Office CommandBar (CB) objects that allows CommandBarButtons (CBBs) to be added & removed on the fly without needing to restart Access. These buttons appear on a ribbon called Add-ins. If you already have an Add-Ins ribbon, the new CB & its CBB(s) will be added to what’s there. Otherwise, it is created & removed when you add & delete the first/last CBB.

Next, using ideas demonstrated by Geoff Griffith at the earlier meeting, Adrian will show how to add other types of CommandBar controls, and use some of the many possible FaceIDs for the corresponding images.

Finally, time permitting, he will show a ribbon using CommandBar objects which allows users to run several external apps from Access.

Bio:

 

Adrian Bell is based in the UK and has been a Microsoft MVP for Access almost continually since 2014.

The MVP award was mainly due to his community contributions on Bytes.com forum where he posts as NeoPa.
His user name originated from his gaming days in an earlier epoch, or early this millennium anyway.

Adrian has worked in IT, covering coding, app design, systems, support & pretty much everything else over the years since starting work in 1978.

Adrian’s website is http://AccessConsultantUK.co.uk

======================================================================

IMPORTANT NOTE

All sessions will be recorded and later uploaded to the AccessUserGroups channel on YouTubeAccessUserGroups.org – YouTube.

If you do not wish to be part of the recording, please ensure your webcam and microphone are both switched off.

======================================================================

We use Zoom as our meeting application.

Please click the link below to download Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link or phone number

Join Zoom Meeting

If you are asked:

Meeting ID: 924 3129 5683
Passcode: 661210

Dial by your location:
+1 669 900 9128 US (San Jose)
+1 253 215 8782 US (Tacoma)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 346 248 7799 US (Houston)
+1 646 558 8656 US (New York)
+43 12 535 502 Austria
+32 1579 5132 Belgium
+359 3 257 1633 Bulgaria
+385 1300 0988 Croatia
+420 5 3889 0161 Czech Republic
+45 32 70 12 06 Denmark
+358 9 7252 2471 Finland
+33 1 7037 9729 France
+49 69 7104 9922 Germany
+30 211 198 4488 Greece
+36 1 779 9126 Hungary
+353 1 653 3898 Ireland
+39 069 480 6488 Italy
+352 2786 4277 Luxembourg
+356 2778 1288 Malta
+31 20 241 0288 Netherlands

+48 22 307 3488 Poland
+351 308 810 988 Portugal
+40 31 630 1088 Romania
+421 233 418 515 Slovakia
+386 1600 3102 Slovenia
+34 917 873 431 Spain
+41 43 210 71 08 Switzerland
+46 850 539 728 Sweden
+44 203 481 5240 United Kingdom
+44 208 080 6591 United Kingdom

Meeting ID: 924 3129 5683
Passcode: 661210
Find your local number: https://zoom.us/u/a4d0JdR88