Видео

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!

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

What would you suggest now that Web Apps is deprecated?

Thank you, very informative Presentation.

Dale, been using your tool for several months and find it quite helpful. I notice that on the title bar of the tool, in different times in the video, that 2 versions are shown. One version is V1.01.03 (2/14/19) and the other version is V1.02.13 (4/1/24). At your website, the download available is the earlier version. If there is a substantial difference, could you update the download file available?

Great Video !

Thanks to Dale for a very interesting and informative session

Buena charla espero aportarles algo de mis conocimientos con Access y PostgresSQL. Un saludo desde Colombia

Buenas tardes, tengo una pregunta que no tiene que ver con el tema. La pregunta es, puedo usar un datagrid en Access, que no sea la vista hoja de datos? La idea es que con vista hoja de datos no me permite usar una conexión ADO desvinculada y había pensado quizás que con un datagrid sea más flexible. Muchas gracias.

Hola Samuel agradezco mucho tus vídeos. Sólo una par de cosas y es que no destruyes los objetos y eso es fatal en Access que provoca cierres inesperados. Quizás por simplicidad en los ejemplos tampoco hay gestión de errores que provocan roturas de la ejecución inesperados en cualquier parte. Entonces el uso de clases está excelente peeeero hay que saber como hay que destruir. Yo además trabajo con modelo basado en capas: entidad, acceso a datos, negocio y presentación. Pero lo dicho, la gestión de errores y la destrucción de objetos es súper importante. Un saludo desde Centelles (Cataluña)

Mi apoyo incondicional a Jesús. Yo también utilizo para mis desarrollos Access 2010. En cuanto al conector uno normalito MS SQL Server 2012

This is really nice. Good Work. I am a Logistics Manager for a Trucking company and i use access to capture all the trips done on a daily basis. The scheduling of the trips is still done on Excel and then we have to type the info over from excel to access because it is a visual scheduling board. This is exactly what i was looking to do in access. Where the techs are will be replaced by my trucks. And the Jobs will be replaced by Loads... I don't fully understand everything yet but i will work through everything and see if i can build my own system using this one as a guide.