Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-21-2017, 05:49 AM   #46
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,038
Thanks: 78
Thanked 1,996 Times in 1,944 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Access OOP examples wanted

There is a lot of info re OOP and Access and Interface in this thread by jLeach

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
The Following 2 Users Say Thank You to jdraw For This Useful Post:
jleach (12-21-2017), Uncle Gizmo (12-21-2017)
Old 12-28-2017, 10:08 PM   #47
Leo_Coroneos
Newly Registered User
 
Leo_Coroneos's Avatar
 
Join Date: Nov 2017
Location: Albany, Western Australia
Posts: 110
Thanks: 19
Thanked 1 Time in 1 Post
Leo_Coroneos is on a distinguished road
Re: Access OOP examples wanted

Quote:
Originally Posted by jdraw View Post
This is an outstanding link, a brilliant exposé of OOP and the principles behind it.

I don't know who posted the WithEvents link, but that one is even more awesome.

Geez, I feel like a kid in a candy store, only the candy is programming concepts, and my brain--which assimilates them--is equivalent to my greedy mouth licking and gnawing the candy.
__________________
Database Design Solutions
Databases for the 21st Century
Leo_Coroneos is offline   Reply With Quote
Old 07-25-2018, 07:07 PM   #48
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,038
Thanks: 78
Thanked 1,996 Times in 1,944 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Access OOP examples wanted

Just wanted to add a link to a class and related info from MarkK

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Old 02-10-2019, 08:27 AM   #49
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 12,038
Thanks: 78
Thanked 1,996 Times in 1,944 Posts
jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light jdraw is a glorious beacon of light
Re: Access OOP examples wanted

Here is a youtube video by PDTech describing his routine/class module to adjust and resize form controls.
His code is available as mentioned in the video.

I also want to highlight this link by Mile-O on a user authorisation/login class. I think this may have been the original question by spikepl that spawned this thread. Anyway, I am including the link since if provides the code and description.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
Old 02-10-2019, 09:40 AM   #50
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,688
Thanks: 27
Thanked 510 Times in 483 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Access OOP examples wanted

Here is one I did recently that demonstrates a lot of concepts. Capturing multiple events from multiple objects, raising cutom event, and trapping custom events. I replaced an Active X spinner control with a class.

https://www.access-programmers.co.uk...84&postcount=7

This has features that make it more flexible than a real spinner.
MajP is offline   Reply With Quote
Old 07-25-2019, 02:40 AM   #51
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 6,336
Thanks: 158
Thanked 1,699 Times in 1,670 Posts
Minty is a jewel in the rough Minty is a jewel in the rough Minty is a jewel in the rough
Re: Access OOP examples wanted

I'm at the start of learning a bit of C# online and totally coincidentally picked up on this article. https://medium.com/codeiq/object-ori...F-92a4b666c7c7

In the opinion of those far more knowledgeable than me is this actually pretty true ?
Personally I have always thought that whilst OOP looks like it could be nice, it seems to add complexity to simple tasks?
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 07-25-2019, 03:29 AM   #52
MajP
Newly Registered User
 
Join Date: May 2018
Location: USA baby
Posts: 1,688
Thanks: 27
Thanked 510 Times in 483 Posts
MajP will become famous soon enough MajP will become famous soon enough
Re: Access OOP examples wanted

Quote:
Personally I have always thought that whilst OOP looks like it could be nice, it seems to add complexity to simple tasks?
For me I would say the other way around. It makes a complex task simple.
I am not familiar with some of the very modern languages that are non OOP, so would have to learn about those, but there are things I have coded that I could not imagine how it could be done without OOP.

MajP is offline   Reply With Quote
The Following User Says Thank You to MajP For This Useful Post:
Minty (07-26-2019)
Old 07-25-2019, 04:51 AM   #53
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,113
Thanks: 81
Thanked 1,603 Times in 1,487 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Access OOP examples wanted

Like all endeavors, OOP is a "pay me now or pay me later" type of activity.

When done well, it makes use of that object class almost trivial. When done poorly, you find it harder because (perhaps) the class is missing some important methods or properties that have to be done outside of the class context. This is true in any language that supports the concept of OOP. It is still only as good as the programmer.

The decision to go "object oriented" leads to a project for which all of the normal rules and guidelines apply - lay it out beforehand, do a thorough analysis of required functionality and the data needed to support same, test it to a fare-thee-well. That's the same advice we give to so many here. The fact of it being OOP doesn't change the fact that it is a programming project of some complexity for which there is a cost and there is a benefit.

So does OOP add complexity to simple tasks? It could. Does OOP make complex tasks simpler? It could.

The fact remains that any truly compiled language can do anything that any other compiled language can do. But that doesn't mean every language presents the same difficulty in doing so. C variants and Pascal variants are pretty good about structuring. BASIC and FORTRAN, less so. Let's NOT bring up COBOL for OOP. Visual Basic is the attempt to overcome BASIC's primitive structuring capabilities. It becomes possible with VB and its VBA bastard child to have a language that supports methods and properties, but even something so clunky as P/L-1 allowed language extensions to support OOP.

As always, the focus should remain on the goals and the process by which you reach them. Pay now, pay later. We've all seen it.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
Minty (07-26-2019)
Old 07-25-2019, 10:52 AM   #54
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,870
Thanks: 404
Thanked 270 Times in 236 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: Access OOP examples wanted

Quote:
Originally Posted by Minty View Post
I'm at the start of learning a bit of C# online and totally coincidentally picked up on this article. https://medium.com/codeiq/object-ori...F-92a4b666c7c7

In the opinion of those far more knowledgeable than me is this actually pretty true ?
Personally I have always thought that whilst OOP looks like it could be nice, it seems to add complexity to simple tasks?
Interesting that you of all people would post that Minty! Assuming that Class Modules ARE OOP, then the rest of my post is accurate, if not then it would not be the first time I ran my mouth needlessly...

It was YOU Minty that made me aware of what a Class Module can do:

https://www.access-programmers.co.uk...d.php?t=294107

FMS has a very robust error handling Class that is a bear to retro-fit but once you get all the bugs ironed out, there is no going back.

MarKK’s User Module (discusses earlier in this thread) comes in handy as well.

All that being said, not being a true programmer, I cannot argue for or against OOP. But the ability to do what little it does (that I’m aware of) makes it worthwhile for me.

__________________
- Ciao, John
NauticalGent is offline   Reply With Quote
The Following User Says Thank You to NauticalGent For This Useful Post:
Minty (07-26-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 resource database help wanted. Doogle General 0 06-18-2009 06:29 AM
Access Query not displaying everything I wanted dubsdj Queries 3 03-25-2009 05:14 AM
[SOLVED] Access Guru Wanted safgan General 1 08-22-2005 05:40 PM
Need Access Help. onsultant Wanted Tonight. robjordan General 1 10-07-2004 09:12 PM
Access Database Examples Trinb37 General 1 03-05-2004 11:13 AM




All times are GMT -8. The time now is 10:56 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World