Results 1 to 2 of 2
  1. #1
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,986

    Access Europe - Using VBA to create a class based on a table - Wed 1 May

    The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).



    In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
    He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
    Adolph will then demonstrate VBA code to create class modules from tables and use the class created to populate/navigate/update a simple unbound form.
    An example database will be provided containing all the code used for this presentation.

    I hope you will join us on May 1st for this session.

    Click image for larger version. 

Name:	CoverSlideMay24.jpg 
Views:	20 
Size:	145.7 KB 
ID:	51732

    For more details about the topic and speaker together with connection details for the meeting, please visit https://isladogs.co.uk/aeu-27/ or https://accessusergroups.org/europe/...pe-2024-05-01/

    For local start times, please check https://www.worldtimebuddy.com
    The meeting will again be held on Zoom. When the time comes, you can connect using Join Zoom Meeting.
    If you are asked, use: Meeting ID: 924 3129 5683 ; Passcode: 661210
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,986
    The video of Adolph's presentation to Access Europe on Wed 1 May is now available on YouTube. Hope others find it useful
    URL: https://youtu.be/qxxWmbpDzpc


    A significant part of the session explained how and why class modules can be very useful and showed how class module code can be generated automatically using VBA i.e. code to create code!
    A PDF of the presentation together with the example database used in the session is available from https://www.isladogs.co.uk/aeu-27
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Europe Meeting - Wed 7 Feb
    By isladogs in forum Access
    Replies: 2
    Last Post: 02-10-2024, 09:52 AM
  2. Access Europe Meeting - Wed 3 Jan
    By isladogs in forum Access
    Replies: 2
    Last Post: 01-12-2024, 07:40 AM
  3. Create a Class Instance by Name in Access VBA
    By RMittelman in forum Programming
    Replies: 4
    Last Post: 07-31-2023, 05:28 PM
  4. Replies: 1
    Last Post: 05-06-2023, 08:52 AM
  5. Replies: 2
    Last Post: 02-23-2016, 04:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums