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

457 Recognized Expert Moderator Contributor

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.

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

2 Weeks Ago #1

Subscribe Reply

5114

isladogs

457

Recognized Expert Moderator Contributor

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

1 Week Ago #2

Similar topics

3201

Registry access denied using RegistryKey class

by: g82martin | last post by:

I am using the RegistryKey class to access the registry on remote machines. I only require read access. I am able to successfully read registry keys under HKLM\Software\Microsoft\Windows NT\CurrentVersion\HotFix but I get a permissions error when I try to access HKLM\Software\Network Associates\TVD\Shared Components\VirusScan Engine\4.0.xx....

C# / C Sharp

1326

connecting to a Access Database in a Class

by: molemoore | last post by:

Im trying to connect to an Access database using a class. I think I have been able to establish the connection but when trying to test it by pulling data from the database im getting the error: "An unhandled exception of type 'System.NullReferenceException' occurred in DB.exe Additional information: Object reference not set to an instance...

Visual Basic .NET

2128

class-based access control VS instance-based access control

by: xz | last post by:

Why C++ (as well as Java) adopts class-based access control instead of instance-based access control? I had never paid attention to whether an access-control is class-based or instance-based but only intuitively thought that the latter was the one being used. Since it does not seem to make sense to let an instance "a1" of Class "A" to...

C / C++

1826

Access 2000 help! Create form with table

by: Daniel B | last post by:

I would like to create a form, with a subform that shows data from several tables. Then I would like to be able to somehow click on one line of data, and it will take you to another form showing only the data from the line that was clicked on. I am not great with VB, so if there is a way to do this without using VB that would be awesome. I...

Microsoft Access / VBA

1661

The next Access Europe Meeting is on Wed 3 May 2023

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 3 May 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check World Time Buddy I am pleased to...

Microsoft Access / VBA

17229

The next Access Europe meeting is on Wed 5 July - Interactive Gantt Chart Scheduler in Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 5 July 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check...

Microsoft Access / VBA

8292

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check World Time Buddy In this...

Microsoft Access / VBA

1176

Access Europe meeting on Wed 6 Sept - Database Analyzer and other tools

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check...

Microsoft Access / VBA

19249

Access Europe Meeting - Wed 1 Nov - Using SQL Server skills to extend Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on Sunday 29 Oct, whilst the USA remains on Daylight Savings until mid November. The start time for this meeting is equivalent to 19:00 (7PM) in...

Microsoft Access / VBA

31675

Access Europe Meeting - Wed 3 Jan

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In this month's session, Ramachandran (APR) Pillai will be leading a presentation called Streamline Form Module Code in the standalone Class Module. For...

Microsoft Access / VBA

7185

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7417

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7588

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7551

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

4779

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3273

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...

Networking - Hardware / Configuration

3269

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1625

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

826

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP