![AccessUserGroups.org](/img/default-banner.jpg)
- 450
- 868 943
AccessUserGroups.org
United States
Registrace 19. 02. 2015
AccessUserGroups.org purpose is to foster and support virtual Microsoft Access User Group chapters throughout the world, from beginning user groups to advanced topics such as SQL Server. Chapters can be organized around a language, such as Spanish, a region, such as Europe or a topic of interest, such as Access functions.
Start your own Microsoft Access User Group by going to accessusergroups.org/ !
Start your own Microsoft Access User Group by going to accessusergroups.org/ !
AP: Adding & Removing Items (Immediately) to and from the Ribbon using VBA with Adrian Bell
It is generally believed that the Ribbons can only be updated by the user via the interface provided - or can be updated offline by tweaking the embedded XML data file stored within the AccDB.
Adrian Bell, long-time Access MVP, showed a technique based on the original Office CommandBar (CB) objects that allows CommandBarButtons (CBBs) to be added & removed on the fly - which show up for the user as a button on a specific Ribbon called Add-ins. If you have one showing already the new CB & its CBB(s) will be added to what’s there. Otherwise it appears & disappears when you add & delete the first/last CBB.
Links in the video:
AUG Website - accessusergroups.org/
Microsoft Access Roadmap - www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access
Discord Server for Access Developers
discord.com/channels/1222492597646262332/1222492597646262335
Access Talk coffee break link discord.gg/F25QZmVA?event=1235586796809879695
Invitation to join: discord.gg/ayHNDpd7Ga.
Adrian Bell, long-time Access MVP, showed a technique based on the original Office CommandBar (CB) objects that allows CommandBarButtons (CBBs) to be added & removed on the fly - which show up for the user as a button on a specific Ribbon called Add-ins. If you have one showing already the new CB & its CBB(s) will be added to what’s there. Otherwise it appears & disappears when you add & delete the first/last CBB.
Links in the video:
AUG Website - accessusergroups.org/
Microsoft Access Roadmap - www.microsoft.com/en-us/microsoft-365/roadmap?filters=Access
Discord Server for Access Developers
discord.com/channels/1222492597646262332/1222492597646262335
Access Talk coffee break link discord.gg/F25QZmVA?event=1235586796809879695
Invitation to join: discord.gg/ayHNDpd7Ga.
zhlédnutí: 176
Video
AEU30: Using Treeviews with Access (Pete Poppe)
zhlédnutí 845Před 28 dny
In this presentation, Pete Poppe introduced the Treeview control and demonstrated when it can greatly benefit the display of certain types of data within Access applications. In particular, treeviews provide a means of showing hierarchical data in a compact but expandable form. Access does not have a native Treeview control but there are Active X and third-party versions. The presentation inclu...
AP: DBeaver -- A Better, free cross-platform database tool
zhlédnutí 938Před měsícem
The adage “a picture is worth a thousand words” aptly captures the essence of an Entity-Relationship Diagram (ERD). Similar to this metaphor, an ERD provides a visual depiction of the intricate relationships among entities within a database. If you’ve ever crafted an ERD in Access or SQL Server, you might agree that a significant portion of those “thousand words” might lean towards the concise,...
ESP: La Moviola. Revisamos las mejores jugadas
zhlédnutí 209Před měsícem
¿Eres un apasionado de Microsoft Access y no quieres perderte ninguna oportunidad para mejorar tus habilidades? Entonces, ¡este evento es para ti! Te invitamos a un webinar en directo, gratuito y lleno de conocimiento: "La moviola: Revisamos las mejores jugadas". ¿Por qué debes asistir a este webinar? Si alguna vez te has encontrado perdido en una explicación o necesitas aclarar algún detalle s...
AP: What is a Framework and Why Would Access Developers Use One? with John Colby
zhlédnutí 646Před měsícem
-Classes store all of the code and data about an object in one place. We usually store classes in the Front End accdb we develop it in. But what happens when we need to re-use a class in several project FEs? We can do that with a library. However, normally classes cannot be seen outside the container in which they reside without specifically and intentionally exposing them. In this presentation...
AEU29: Improved, Enhanced Message Box (Olaf Nöhring) & Enhancing Access Forms (André Minhorst)
zhlédnutí 861Před 2 měsíci
In this session, we had two presenters from Germany. Olaf Nöhring demonstrated his improved version of the free Enhanced Message Box tool originally created by Renaud Bompuis. André Minhorst then introducd two exciting enhancements for Access applications (amvCalendar & amvExplorer). These are designed to streamline and enhance user experience. Times: 00:00 Welcome from Colin 00:28 Olaf's intro...
ESP: Malas prácticas en Access. Lo que no repetirías.
zhlédnutí 353Před 2 měsíci
En este video volvemos a enfrentar a los mejores programadores de Access para que nos cuenten su experiencia entorno a una temática dada. Malas prácticas en Access ¿que no repetirías? Sumérgete durante hora y media en aquellas técnicas por las que seguro que más de uno hemos pasado y con los años nos hemos dado cuenta de que no son las mejores a la hora de crear nuestras aplicaciones.
AL: Data Analysis Tips and Techniques with Luke Chung
zhlédnutí 624Před 2 měsíci
Access Lunchtime; use data tips and techniques shared by Luke Chung to structure and analyze data using Access. 0:00 introduction by Maria Barnes 3:36 Overview by Luke Chung 4:18 Record Sampling 9:05 Frequency Distributions 14:44 Not-In Queries 21:07 Union Queries 25:35 Crosstab Queries 29:12 Crosstabs for Reports 35:48 Temporary Tables and Databases 38:53 Data Cleaning for Analysis 46:54 Moder...
AP: Trouble-Shooting Access Applications
zhlédnutí 441Před 3 měsíci
You all know this story-you’ve lived it. Your Access relational database application has been working “fine” for a long time. And then one day it doesn’t. What happened? Why did it happen? Where do you even start to look? Ben offers strategies he uses to track down and correct bugs as well as those out of the blue problems we all experience. This presentation is packed with ideas for quickly an...
AEU28: IMEX DataTask Specifications and Extended File Properties (Colin Riddington)
zhlédnutí 382Před 3 měsíci
Colin Riddington demonstrated 2 separate items (for all links, click More below) 1. IMEX Data Task Specifications Prior to 2007, import/export (IMEX) specifications saved in 2 system tables. Only for text files XML based system of IMEX Data Tasks added in 2007. Simple to use. Works for a wider range of files including Excel & Access. Ease of use has led to greater obscurity in how it works. Col...
SA: Selling Access with SQL Server Jobs
zhlédnutí 452Před 3 měsíci
For our last meeting before our summer break, we talked about how to make money as an Access consultant . Juan shared his 30 years of experience: Finding customers Closing deals Answering objections Creating proposals If you’re thinking about starting a consulting practice or wish to improve your sales, this is the session for you!
ESP: Firma digital y protección de PDFs con Access
zhlédnutí 353Před 3 měsíci
¿Alguna vez has querido firmar digitalmente un PDF, pero también necesitabas aplicar una contraseña de apertura? Suena sencillo, ¿verdad? Pero en realidad, es un desafío complejo que ha dejado a muchos desarrolladores mordiendo el polvo. ¡Prepárate para una aventura de ingenio y creatividad! En este webinar gratuito y en directo, un grupo de expertos curtidos en el desarrollo de Access te revel...
AL: Learn how to chat with other Access developers on Discord with Jim Dettman and Doug Yudovich
zhlédnutí 367Před 3 měsíci
Jim Dettman and Doug Yudovich introduce us to a new Access developers forum on Discord. Explore, get general advice on how to use the Discord platform, and learn how you can interact with other developers in a modern voice, video, and chat environment. 0:00 Access Talk on Discord Welcome Jim Dettman and Doug Yudovich Crystal, Colin, and Adrian filling in for Maria, who is off to the Kentucky De...
AP: Trouble-Shooting with Tom van Stiphout and Kim Young
zhlédnutí 331Před 4 měsíci
Tom and Kim draw on decades of experience creating and troubling-shooting Access applications. Learn what you and should be doing to avoid problems and deal with them if they occur. They explain principled approaches to avoiding, identifying , and resolving problems. Numerous examples of real-world incidents are scattered throughout the presentation. Links in the video: DISCORD SERVER & Invitat...
AEU27: Using VBA to create a class based on a table (Adolph Dupré)
zhlédnutí 1,1KPřed 4 měsíci
In this session, Adolph Dupré discussed some powerful techniques for using class modules. He explained when you may want to use classes instead of User Defined Types (UDT). For example to manage the data in unbound forms. Adolph then demonstrated VBA code to create class modules from tables and use the class created to populate/navigate/update a simple unbound form. A PDF of the presentation to...
AL: Unravelling Constraints, A Case Study developing with Access by Steve Schapel + Jack Drawbridge
zhlédnutí 604Před 4 měsíci
AL: Unravelling Constraints, A Case Study developing with Access by Steve Schapel Jack Drawbridge
SA: Managing SQL Server Migration Projects with Juan Soto
zhlédnutí 353Před 4 měsíci
SA: Managing SQL Server Migration Projects with Juan Soto
ESP: Buenas prácticas en el desarrollo de aplicaciones de Access
zhlédnutí 505Před 4 měsíci
ESP: Buenas prácticas en el desarrollo de aplicaciones de Access
AP: SQL Server Audit Tables with Kent Gorrell
zhlédnutí 408Před 5 měsíci
AP: SQL Server Audit Tables with Kent Gorrell
AEU26: Working with CommandBars, the Access Shortcut Tool and a simple Audit Log (Dale Fye)
zhlédnutí 803Před 5 měsíci
AEU26: Working with CommandBars, the Access Shortcut Tool and a simple Audit Log (Dale Fye)
AL: Access Tab Control, Unicode, Format (Excel too), by crystal
zhlédnutí 795Před 5 měsíci
AL: Access Tab Control, Unicode, Format (Excel too), by crystal
AP: Sharing Data Outside Your Local Network with Linda Ewen
zhlédnutí 351Před 5 měsíci
AP: Sharing Data Outside Your Local Network with Linda Ewen
AEU25 - Better Access Charts - The Next Generation (Thomas Moeller)
zhlédnutí 688Před 6 měsíci
AEU25 - Better Access Charts - The Next Generation (Thomas Moeller)
Apuntate al evento Presencial de AUGE en Valencia del 9 al 12 de Mayo
zhlédnutí 88Před 6 měsíci
Apuntate al evento Presencial de AUGE en Valencia del 9 al 12 de Mayo
AL: 2024 Plans for Access, by Maria Barnes
zhlédnutí 1,4KPřed 6 měsíci
AL: 2024 Plans for Access, by Maria Barnes
SA: Interview with Book Author Alessandro Grimaldi: Access on Steroids
zhlédnutí 588Před 6 měsíci
SA: Interview with Book Author Alessandro Grimaldi: Access on Steroids
ESP:Así TRABAJAN los Profesionales de ACCESS
zhlédnutí 873Před 6 měsíci
ESP:Así TRABAJAN los Profesionales de ACCESS
AEU24: Top 10 Advanced Features of MZ-Tools (Carlos Quintero)
zhlédnutí 788Před 7 měsíci
AEU24: Top 10 Advanced Features of MZ-Tools (Carlos Quintero)
ESP: Inteligencia emocional en las finanzas
zhlédnutí 195Před 7 měsíci
ESP: Inteligencia emocional en las finanzas
You've got gorgeous kids.....
John, An excellent presentation! I'm sorry I missed the meeting because I found myself shouting with frustration at the CZcams screen over the confusion where one viewer was repeatedly asking the same question over and over. "how does your code library access the user configuration table in the application?". You kept saying "it opens the table, it copies the skeleton table from the library as a starting point but the user fills in the data in the application table, it uses a recordset". And the viewer would then ask the same question again. Like you, I have been using code libraries for over 20 years and we now take for granted one of the fundamental principles that was not explained: BY DEFAULT A CODE LIBRARY USES THE PARENT APPLICATION'S WORKSPACE TO ACCESS ITS DATA AND OBJECTS. So if code in a library opens a table, query, form or report, the object that gets opened is in the application database, rather than the library database. If you want to open an object in the application database in DAO, use CurrentDb() to get the Database object If you want open an object in the code library database in DAO use CodeDb() to get the Database object instead DoCmd uses CurrentDb(), rather than CodeDb(). So all standard access functions work with the application's database objects, rather than the library's database objects. I know it's a bit late to make this contribution, but I hope it helps. Kr Neil Sargent
Very cool. Sorry I missed the original presentation. Just for giggles, I connected it to my Lightroom 6.1 database/catalogue, and it seemed to work flawlessly.
Unfortunately, this takes about four times as long then just uninstalling and reinstalling the correct bit version. Not to mention, your computer won't even work after altering Windows and Office!
Muchas Gracias Pete, un gran trabajo
Glad you liked it!
Many thanks to Pete Poppe for an ezcellent presentation to Access Europe - the clearest explanation of when & how to use treeviews successfully that I've seen
Commented before seeing, thanks
Come back & tell us what you thought after watching it!
excelenete
This tool is useful for exporting tables from Access to SQL Server or MySQL. The problem is that it misses keys, indices, and some field definitions. It is quite laborious to export like that (but better than redefining the tables).
Shout Out to John W. Colby! I've been using your concepts in MS Access development since Nov 2002. I have created so many class modules since then with your code dated from 28 May 2001 and 6 Dec 2001 !! It has enabled me to develop my own frameworks and resulted in some really stable systems - so thank you for your revelation 22 years ago and for sharing your code. Since then I have used your technics to build a framework that drives completely unbound Access forms - I no longer need ODBC links, all is done with ADO recordsets to SQL Sever. My classes, based on John's framework, along with boiler plate CRUD procedures, do all the heavy lifting to get data into and out of forms. I have even replaced the Access data grid with Exontrol's Ex2gantt (NB I'm a subscriber to Exontrol, no affiliation!). I could not have done any of this without John's input - thank you!!! FindControls, HookControlEvents!
jwcolby.blogspot.com/?view=sidebar
Excelente aporte Samuel. Cómo podría acceder al archivo para que me sirva de guía. Mil gracias
Here are some key time indexes that you can go straight to for specific details: 1. **Defining a Framework (**0:00** - **2:14**)** - Introduction to the concept of a framework. - Definitions and examples to clarify the concept. 2. **Introduction to John Colby (**2:14** - **3:04**)** - Introduction of John Colby and his background with Access development. 3. **Why Use a Framework in Access (**3:04** - **8:18**)** - Explanation of the reasons for using a framework in Access. - Analogies with Microsoft Windows to explain the layering of frameworks. 4. **Implementing Classes in Access (**8:18** - **14:21**)** - Discussion on creating classes for common tasks. - Examples of how classes can be used to standardize functionality across forms. 5. **Loading Framework Components (**14:21** - **20:05**)** - Detailed explanation of how the framework components are loaded when an application starts. - Specifics on initializing classes and collections for various controls. 6. **Using the Framework in Access (**20:05** - **29:10**)** - Practical examples of using the framework in Access. - Examples of iterating through controls and loading specific classes based on control types. 7. **Loading Data and Security (**29:10** - **1:02:58**)** - Discussion on loading data into the framework. - Explanation of lightweight security and how it integrates with the framework. - Practical example of managing user permissions and access controls. 8. **Specific Example of a Class (**1:02:58** - **1:26:02**)** - In-depth walkthrough of a specific class (CSVars) and how it is implemented. - Code examples and explanation of how the class interacts with tables and collections. 9. **Questions and Further Clarifications (**1:26:02** - End)** - Q&A session addressing specific questions from the audience. - Additional clarifications on the implementation and use of the framework and classes.
CUANDO CREARAN EL CURSO DE PAGO PARA APRENDAR A USAR LAS CLASES?
Excelente explciacion, a implimentar
Hello, in ms access is there a way to upload a pdf file to a external api using multipart/form-data? Thanks.
cuando daras el curso de clases?
Thank you to Olaf and Andre for two excellent presentations. I hope others find them interesting. The host had some internet connection issues but luckily this didn't affect the actual presentations
Gracias por el video, muy interesante los puntos charlados.
Muchas gracias por compartir vuestra experiencia. Como novato, tiene un valor incalculable.
Gracias a todos por compartir su tiempo y conocimiento. Saludos!
Excelente charla que debería repetirse con más prácticas que no se deberían repetir.
es increible, un tema tan importante ya con tan pocos comentarios, practicamente es un framework te felicito excelente aporte
El primer vídeo que encuentro donde realmente saben plantear el tema de los módulos de clase. Excelente
Vaya! Defininivamente en Access si que saben hacer uso de módulos de clase, no asi en VBA/Excel.
Thanks to all of you for the excellent presentation. And for the code. I am still a bit lost with the suggestions of making the update function more versatile for other platforms: Could one of you present a small code example? I guess it could then also be used on tables that don't have an autonumber as ID?
Great presentation, Colin, thanks. IMEX good review since like you, I wrote a tool. Extended File Properties more interesting for me. Very nice that you've analyzed properties for different file types, store values in tables, and make them accessible
Glad you found it interesting. Wasn't aware you had an IMEX tool of your own
Where can I find the data analytics episode from a week or two weeks ago?
that will be posted around June 24 or so
gracias por tu gran explicación, pero no consigo echarlo funcionar en sysnology, me da ERROR: bootstrapSystemDataDirectories failure HRESULT 0X8007005, Server falided copying system data file c:\templatedata\master.mdf to /var/opt/mssql/data/master.mdf, acceso denegado, sabrías o podrías ayudarme
Hola superinteresante, y de mucha actualidad. Podriais facilitar pdf.sign ya que me está resultando complicado de encontrar. Gracias de antemano por vuestra labor y entusiasmo. Saludos.
Excelente muchas gracias
Thank you for sharing your fascinating and lengthy story of what you had for dinner, and what time dinner was, where you traveled, etc. Totally relevant and highly useful information.
Great presentation.
Thank you. Good luck with your Access consulting career.
Gracias a ustedes maestros cada vez aprendo más y me doy cuenta de la útil que es Access, tengo una aplicación más o menos bien elaborada y todo lo he realizado con tutoriales y videos. Saludos desde Ecuador.
La verdad esto es ejecutar access por medio de escritorio remoto..
Is there still demand for access devs?
Yes, according to some, there is more work available for qualified Access developers than there are qualified Access developers to do it. The bigger problem is finding each other.
@@AccessUserGroups indeed!
```cs //code ``` change cs to the language you are posting, cs is for c#
thanks, good to know!
Jim, fantasic overview of what anyone would want to know about Discord, whether they are an Access Developer or not. DougY, excellent showing us more and answering even the difficult questions. Great comments from others too! I look forward to seeing the success of Access Talk. Thanks to Colin and Adrian to help things run more smoothly -- and Maria will be back for the May meeting :)
Tengo un problema igualmente: Tengo un formulario dónde tengo un cuadro combinado y 2 cuadros lista. Tengo los 2 cuadros lista relacionados automáticamente con el cuadro combinado. Mi problema es que cuando después de ingresar la primera fila de datos, y intentó introducir un nuevo valor del cuadro combinado, se actualiza la fila de datos previamente introducidos. Requiero que cuando se valla a introducir o cuando cambié el cuadro Combinado solo se actualicen los valores de los cuadros lista del cuadro combinado seleccionado.
Hi, excellent video.
Thank you. Please join us next month for a follow up presentation on handling problems after they have already occurred.
Great idea and a welcome tool for anyone adapting databases from early 2000's
Great presentation and info--- Thanks Kim and Tom!!!
Thank you.
Many thanks. Good idea.
Glad you enjoyed it.
Thanks Adolph and Colin. I enjoyed the presentation and look forward to reviewing the code in the sample database. I like the idea of using code to generate code -- a time saver.
I agree. Its a very powerful technique that I've used in several apps, though in my case to create standard module code
I used it atleast 5 times last week. Saved Numerous hours.
I had to view it after, as I forgot when it was on. Enjoyed it very much.
Glad you enjoyed it. You could download the calendar file from the website. It will create an Outlook appointment for each meeting
Hope you make the next one.
Many thanks to Adolph for an interesting presentation using code to create code! This was a very easy way for those unfamiliar with class modules to understand how and why they are very useful.
Glad to have presented to my fellow programmers.
fascinating topic and interesting solution, thanks, Steve. Also thank you very much for adding depth, Jack. Great comments from Colin, Ade, Ben, Neil, Jim, Jerry, Duane, Maria, and others -- the side discussions were stimulating too. excellent summary, Adrian! Indeed, you were paying great attention. Like Steve said, you are a master with words.
Great fun meeting, and really great job done by Crystal putting the video together - especially with all the links in the description.
thank you, Ade :) it was indeed a fun meeting!
Thank you for the wonderful tool "Access Shortcut Tool"
Hi Sam. On behalf of Dale . . .Glad you find it useful
Excelente video, estoy interesado en el codigo como lo puedo obtener.? Saludos