Only One Button code works on this form - troubleshoot help requested

[davegri]

So that is better? Or is it just different?

As I mentioned, an alternate.

[Micron]

NOW I get the cat reference. At first I thought it was one-upper statement!

[davegri]

NOW I get the cat reference. At first I thought it was one-upper statement!

Well, don't get me wrong - I would never do that!

[moke123]

Those concepts still hasn't clicked for me ....... (1 of many concepts)

It's one of those things you try and fail on, get frustrated by, and give up on, many times.

But then there's that one snippet of code you come across....

edit: I just looked back at the thread where it clicked for me. I thought it was a long time ago, but I guess not.
https://www.access-programmers.co.uk...ntrols.309240/

[Welshgasman]

Another requirement I believe for classes, is you have to look far ahead to see what you need to build.?

Bit like having preconstructed modules to build a house, rather than brick by brick.?

[orange]

RE: Classes
I'd still like to find a video(youtube) that deals with Access class modules with some examples. Starting with some discussion of concepts and "why/where" classes could/should be applied. Followed by a step by step development of a few examples from very simple to increasingly complex.
If you know of such video(s), or good reference materials please add links.

[Micron]

Another requirement I believe for classes, is you have to look far ahead to see what you need to build.?

Bit like having preconstructed modules to build a house, rather than brick by brick.?

I don't have enough experience with custom classes to say whether or not that is accurate for any case. As for the user class I referred to, if you found that you needed another property it would be a simple matter of adding Property Get and Let procedures, so about 6 lines of code and it's done. Maybe that's not always the case.

[Welshgasman]

I don't have enough experience with custom classes to say whether or not that is accurate for any case. As for the user class I referred to, if you found that you needed another property it would be a simple matter of adding Property Get and Let procedures, so about 6 lines of code and it's done. Maybe that's not always the case.

That is the beauty of classes, but to construct them, I still think you need to think ahead as to what you will require.? If you build a set of classes for all your objects, users, transactions, locations, etc, then life would be good.? It is knowing that you need them up front, and then have the capability to create them.

I know the theory, but have never created any, used a few, and unlikely to ever need one now. :-)

[moke123]

RE: Classes
I'd still like to find a video(youtube) that deals with Access class modules with some examples. Starting with some discussion of concepts and "why/where" classes could/should be applied. Followed by a step by step development of a few examples from very simple to increasingly complex.
If you know of such video(s), or good reference materials please add links.

I agree. Thats part of the problem is that there seems to be so few good practical examples. Very hard to find.

One reason I use them, in some cases, is to have full control over all the events and input.
Another reason is for portability. I have custom classes for datepickers, timepickers, navbars, and more.
The final, most important reason is I have fun fiquring them out and I learn something new almost everytime. (I really need a life )

Heres one for a picklist. It only requires about 3 lines of code in your form to function.

[Amyfb]

Amyfb,

If you are looking for tutorials on specific topics, I highly recommend these youtube series by

Steve Bishop
Richard Rost

Here are many articles and tutorials on Database Planning and Design and more.

I am binge watching Steve Bishop and really enjoying his presentations.
Richard I had skimmed through, and I look forward to drilling into the link of many articles and tutorials that you shared.

thanks!

[Amyfb]

Classes, collections, modules and the rest of it , for me, has a lot of similarities to business modeling - starting at the 30K foot view and drilling deeper into the granularities.

I’m working backwards from my business model to help define all the different objects I am going to want. I’ve got a bit of basics on one hand, an intellectual grokking on the other and a strong desire to absorb a pattern in the construction of it all.

Keeping track of the same variable as it moves from one object to another is the part that I’m battling the most. And here I ‘m sure there must be a mnemonic or pattern or something that I can use….. or not….maybe it’s just alot of practice makes progress and nothing else.

It’s interesting challenge that I like.

[Micron]

Keeping track of the same variable as it moves from one object to another is the part that I’m battling

That must mean something different to me than you because - it never happens the way I interpret that.

The closest parallel I can draw from that is variables being passed to functions either via ByRef or ByVal. Or maybe you need to delve into variable scope if you're really "passing them around".

I suppose if you explain we might be able to help one way or the other.

[Amyfb]

That must mean something different to me than you because - it never happens the way I interpret that.

The closest parallel I can draw from that is variables being passed to functions either via ByRef or ByVal. Or maybe you need to delve into variable scope if you're really "passing them around".

I suppose if you explain we might be able to help one way or the other.

I guess it’s about the way the same data point has a different name(variable) depending on where it came from, where it is now, where it is going, and how it’s going to get there, and where it might stop on the way. Not sure if that is any better an explanation for how I’m trying to process and organize all this information.

[Amyfb]

I want to report back to say that further study of materials I'd breezed through has been a big help. My naming conventions were sloppy, and that was most of the trouble. Practice makes progress; I'm getting there. Thanks for all the input; I like how this site gives me lots of good stuff to think about.
cheers,