want to come to an online user group meeting?

[GPGeorge]

The video from the July 3rd meeting of Access Pacific is available now on YouTube:

Geoffrey L. Griffith shared and demoed two Access add-ins he created for the Access community. After the demo, the group participated in a live round of testing and the inevitable debugging which followed. It's a case study in developing quality software.

The download links for Geoff's add-ins are on Github.


Database Property Editor tool: https://github.com/Access-Abraxas/Access-Database-Property-Editor-Addin
Access Add-In Helper tool: https://github.com/Access-Abraxas/Access-Add-In-Helper

 

[strive4peace]

Using Domain ActiveDirectory Security Features from within Access (01:07:25) with Adrian Bell

 

[strive4peace]

From Access to PowerApps: Modular Logic using UDFs in PowerApps (17:56)
by George Hepworth @GPGeorge

 

[GPGeorge]

PowerApps now has User Defined Functions (UDF) that accept parameters, perform calculations, and return results.

Not quite VBA, but moving in the right direction.

 

[strive4peace]

Leveraging ChatGPT for Incremental Development in Microsoft Access (01:11:23): with John W Colby
hosted by George Hepworth @GPGeorge

 

[strive4peace]

New and Forthcoming Features in Access (01:18:34) with Colin Riddington @isladogs

 

[strive4peace]

Access Europe with Colin @isladogs
Version Control for the Sole Developer - Why it Matters (01:07:40): with Adam Waller

 

[strive4peace]

Access Pacific with George Hepworth @GPGeorge
Updated Control Tip Text (01:14:13): with Greg Regan

 

[strive4peace]

Colin Riddington [Isladogs] (YouTube channel)

• Add Marker Lines to Modern Charts (14:47)

 

[arnelgp]

you tried to resize the form, but the chart did not resize with the form and so does the marker
also the position of the marker is predefined and not dynamic.

 

[isladogs]

Perhaps try watching more of the video .
The first of 6 forms had a fixed line. The other 5 forms use combos to set the positions of the marker lines at runtime.

 

[arnelgp]

The other 5 forms use combos to set the positions of the marker lines at runtime.

yes, i saw the film today, oh boy...
but the position is already defined in the table, so it is not dynamic.
try, resizing the chart, if your line will also follow when the form/chart resize?

 

[NauticalGent]

yes, i saw the film today, oh boy...

 

[AccessBlaster]

Good one

 

[strive4peace]

recent meeting on YouTube. Microsoft Graph has nothing to do with charting. It's a means of getting at the Microsoft data for users, mail, calendar events, folder structure, and many other varieties of data.

The reason for this presentation is to present a way to get information from Outlook without using COM.

• Update on calling Microsoft Graph API from VBA (01:02:27): with Maria Barnes

 

[strive4peace]

new custom dialogs: myMsgBox, myInputBox, myComboBox, and myNotification

AEU44: High impact – Custom dialogs and mini-notifications (Marcus Dieterle) (54:11)

 

[strive4peace]

Explore expressions: what they are, how to build them, and where they are used -- and where built-in and custom functions can be used.

VBA applies to Word, Excel, Powerpoint, and more. VBA Function Reference including syntax and return data type.

VBA Function Reference

VBA Function Reference

msaccessgurus.com

What's the difference between the different ways to process? VBA vs SQL vs Access? Dive in.
AL: Expressions, Custom/Built-in Functions, Processing deep dive,VBA,Access,SQL - crystal, Adrian Bell (1:02:36)

 

[strive4peace]

Error Handling in VBA -- from the basics and well-beyond. Discover things you didn't know.

AEA: VBA Error Handling with Adrian Bell and Kent Gorrell (38:10)

 

[strive4peace]

Light-weight Auditing in Access Databases with 3 Mouse Clicks (+ a little VBA) (01:20:18): with George Hepworth

 

[strive4peace]

Using Power Automate with Office Apps (01:14:51): with Ynte Jan Kuindersma