Video

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

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

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

Where can I find the data analytics episode from a week or two weeks ago?

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.

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?

```cs //code ``` change cs to the language you are posting, cs is for c#

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.

Great idea and a welcome tool for anyone adapting databases from early 2000's

Great presentation and info--- Thanks Kim and Tom!!!

Many thanks. Good idea.

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 had to view it after, as I forgot when it was on. Enjoyed it very much.

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.

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 for the wonderful tool "Access Shortcut Tool"

Excelente video, estoy interesado en el codigo como lo puedo obtener.? Saludos