want to come to an online user group meeting?

[strive4peace]

Microsoft Office 2024 Released - Daniel Pineault (13:12)

 

[strive4peace]

Dive into relationships and indexes in Access and SQL Server
Access Express Australia: Access and SQL Server Relationships + Indexes, bitwise AND (1:07:43)

 

[strive4peace]

the Monaco SQL Editor is now a default option unless you explicitely turn it off in Access Options, if you're using a version of Access its supported in and a trusted database. What are the benefits and disadvantages of Monaco?

AL: Monaco SQL Editor for Access with Maria Barnes (1:03:31)

 

[strive4peace]

thinking about migrating an Access back-end to SQL Server? Here are good considerations and things to do for planning.

Tip: something you can do in Access right now is use dbSeeChanges for options when you open a recordset in code or run action queries. It has no effect for Access, but must be used for SQL Server.

Also, realize that Access gets an Autonumber value right away but SQL Server only gets a value after a record is saved. So if you're getting the value in code, after you UPDATE, set rs.Bookmark = rs.LastModified and then grab it.

AEA: Migration Planning - Access to SQL Server with Kent (38:26)

 

[strive4peace]

AP: Creating Add-ins that run in Access and Office w/ Crystal Long & Geoffrey L. Griffith, hosted by George Hepworth @GPGeorge
Part I - Access Add-in (33:04)

 

[strive4peace]

AP: Creating Add-ins that run in Access and Office w/ Crystal Long & Geoffrey L. Griffith, hosted by George Hepworth @GPGeorge
Part II - COM add-in using VSTO (1:10:03)

 

[strive4peace]

Fun Access song with a good beat, great music and video. To see captions, click "CC" below the video. To change the language, click the settings cog icon to the right of "CC" and change language for "Subtitles/CC". Song is in Spanish but you can pick English for captions, or auto-translate to another language.
Access Hero, by Juanjo, Juan José Luna Aleixos

screenshot with CC and Settings cog below video:

English!

 

[strive4peace]

Access Lunchtime: Using Web APIs in Access by George Young (1:03:31)

 

[strive4peace]

2 user group meetings coming up about developing COM add-ins. First is Wednesday with Philipp Stiefel @sonic8 for Access Europe with Colin @isladogs -- then Thursday is George's @GPGeorge Access Pacific group with Geoff Griffith. Both are amazing.

Wednesday January 8

6 pm UK, 1 pm USA Eastern, 12 noon Central, 11 am Mountain, 10 am Pacific

Access Europe – Developing COM Add-Ins for Microsoft Access - Philipp Stiefel @sonic8

Access Europe - Philipp Stiefel (Developing COM Add-Ins for Microsoft Access) - Europe - AccessUserGroups.org

Please join us for our monthly Access Europe session on Wed 8 Jan 2025 at 18:00 (6:00PM) London time (UTC) NOTE: Rescheduled from Wed 1st Jan to Wed 8th Jan to avoid clashes with New Year celebrations. You can click the button below to download a small calendar (.ics) file and add the meetings...

accessusergroups.org

Thursday January 9

6:30 pm Pacific time, 7:30 pm Mountain, 8:30 pm Central, 9:30 pm Eastern
UK: 2:30 am Friday morning

Access Pacific - Creating Add-ins that run in Access and Office with Geoffrey L. Griffith — Part II

Creating Add-ins that run in Access and Office with Geoffrey L. Griffith - Part II - Pacific - AccessUserGroups.org

Please join us for our Monthly Chapter Presentation , at 6:30PM Pacific (UTC -8) In this follow up presentation, Geoffrey L. Griffith will lead us through the steps to create and deploy Com add-ins to enhance your Access relational database applications. NOTE: Let’s move this back a week to...

accessusergroups.org

 

[strive4peace]

Are you using JSON? Or do you want to know more about using Collections and Dictionaries? This is an excellent presentation by Maria Barnes, Neil Sargent, and Leo @theDBguy

 

[strive4peace]

Two great presentations on developing COM Add-Ins

Philipp Stiefel @sonic8 presents for Colin's @isladogs Access Europe group (1:11:51)

Geoffrey L. Griffith presents for George's @GPGeorge Access Pacific group (1:31:17)

 

[jdraw]

Crystal,
Congrats on getting your MVP again. (Just saw the info in the AUG JSON [Maria,Neil,theDbGuy] video in #168).
Jeez for a second I thought Musk was retracting MVP statuses randomly.

 

[strive4peace]

Data Types in Access and SQL Server
AEA: Data Types with Crystal and Kent (17:54)

 

[strive4peace]

Great knowledge for JSON!

part 1:
AL: Using Dictionaries and Collections to work with JSON in Access: Maria Barnes, Neil Sargent, Leo @theDBguy (1:03:47)

part 2:
AL: Parsing Data using JSON and VBA in Access, Neil Sargent and Leo @theDBguy (1:00:11)

 

[strive4peace]

adding on the the recent JSON presentations, this shows an Access application you can download to try for yourself and how to read AND write using a web API
AL: Get and Post with JSON using Microsoft Access and VBA by Neil Sargent (+Leo @theDBguy) (28:42)

 

[strive4peace]

Classes eloquently and simply explained by Anders (theSmileyCoder) for Access Europe hosted by Colin @isladogs

AEU38: Using Class Modules in the Real World (Anders Ebro)​

57:08

download the presentation incuded the elegant example database, and read the decription on Colin's site here:
Class Modules: How, Why and When To Use Them in the Real World (Anders Ebro)
https://www.isladogs.co.uk/aeu-38/

 

[strive4peace]

Breaking Access News - Zooming and Extending Form/Report Size Limits​

 

[strive4peace]

Leveraging SQL Server Stored Procs for Access, PowerApps and other interfaces. Can it be done?​

with George Hepworth @GPGeorge

 

[strive4peace]

AEA: Icons for Access using Metro, by Greg Regan (35:07)​

 

[strive4peace]

AEU39: Update, update . . . the company is in a state! (Karl Donaubauer)​

by Karl Donaubauer for Access Europe hosted by Colin @isladogs , about best practice in handling Office and Windows updates (1:04:53)