Wrapping controls WithEvents in classes (2 Viewers)

[Gasman]

I think I might change my way of working, and just work through the book, BUT, go to your DB to review the code, instead of creating the demo dB, as too much is changing all the time?
So as long as the book matches to the db, that process should be more reliable?

 

[GPGeorge]

This strikes me as being somewhat akin to signing up for the Microsoft Office beta channel. You get to see the newest stuff all the time, but sometimes you're not quite ready for it.

Seriously, though, feedback is tremendously important to a work in process like this.

 

[jwcolby54]

This strikes me as being somewhat akin to signing up for the Microsoft Office beta channel. You get to see the newest stuff all the time, but sometimes you're not quite ready for it.

Seriously, though, feedback is tremendously important to a work in process like this.

Yes, and @Gasman has been a real trooper struggling to keep me in line.

 

[jwcolby54]

I think I might change my way of working, and just work through the book, BUT, go to your DB to review the code, instead of creating the demo dB, as too much is changing all the time?
So as long as the book matches to the db, that process should be more reliable?

I just spent all morning out in the demo database itself fixing naming convention errors, and adding a pCtlName property in every control wrapper class. I pushed those back into the book, though only 4 of the dozens of controls / control classes from the demo database have made it into the book so far. The nice part of doing such in the db is that a compile instantly tells me when my cut and paste has introduced an issue. I can just fix it. The book doesn't give me this feedback.

 

[jwcolby54]

This strikes me as being somewhat akin to signing up for the Microsoft Office beta channel. You get to see the newest stuff all the time, but sometimes you're not quite ready for it.

Seriously, though, feedback is tremendously important to a work in process like this.

It strikes me as signing up to rewrite the demo database included in Access. That had to be even worse. And sometimes it is not ready to be seen?

 

[GPGeorge]

It strikes me as signing up to rewrite the demo database included in Access. That had to be even worse. And sometimes it is not ready to be seen?

And now I'm doing it in PowerApps too.

It's going to be ready to be seen in about <mumbled> months.

 

[jwcolby54]

And now I'm doing it in PowerApps too.

It's going to be ready to be seen in about <mumbled> months.

Are you related to Elon by any chance?

 

[jwcolby54]

Are you related to Elon by any chance?

Or maybe PowerApps is his missing piece?

 

[jwcolby54]

LOL, going back and reading my own blog posts from 2013 is interesting. I was 12 years closer to my old work back then...

 

[jwcolby54]

I learned a lot tonight. I did a presentation on C2DbProperties on Access Pacific zoom call. The devs on that zoom are first rate and we had a brisk discussion about a lot of different stuff including GitHub and Git.

I have been writing my book EventDrivenProgrammingInVBA in LibreOffice using a format called .odt. It is not Git / GitHub friendly. I pinged ChatGPT about this and ended up deciding to switch to .fodt. Apparently .Odt is a big zip file full of directories, each full of stuff. Or some such. As such GitHub treats the entire file as a big binary, which it kind of is. What that means is that the internals simply cannot be diffed or anything like that. And so version control is mostly off the table.

.fodt is straight XML, with the sole exception of images which are essentially a blob of some sort. Since XML is essentially text at the end of the day, GitHub can handle that. Conversion of the book was simply save as .fodt. Done. Commit to GitHub. Done.

Then I had to decide on how / whether I wanted a compare widget. I settled on Meld. That was a royal PITA, lots of editing GIT files and creating batch files and setting registry keys and creating right click menu stuff and... This is not my forte and it took hours! But ChatGPT is a patient tutor and it all worked in the end.

So I now have Meld working from a "send to" right click menu, and it will open any two (text) files, selected in Explorer, and perform a compare in side by side windows.

Which means that I am now more or less ready to move on to more extensive use of GitHub and Git. To this point I have just been treating it as a big backup system. Now I can start trying to use it as a version control system. Not that I know how to do that yet.

 

[jwcolby54]

Another thing I discovered in the zoom call tonight is that the links I am creating to files out in GitHub are not what I thought. The book PDF is being opened directly in a browser directly in the GitHub repository. If a reader wants it on their computer they have to do a download manually.

The example database however... the browser doesn't understand how to open that and so it automatically downloads the database to the downloads directory. Which is convenient.

So much to know, so little time.

 

[Gasman]

Nope. In Chrome, it downloads it. At least on my Chrome it does.

 

[dalski]

book on the subject which can be found on my blog about the subject.

Thanks for this, I'm close to finishing Andrew Couch's 'Access 2010 VBA Programming Inside Out'; an excellent book! But I still have not fully grasped events fully as the e.g's in the book were hooked into native Access events. So I'm unclear if all clsEvents need to be hooked or they can be their own-type-events. Looking forward to reading yours now.

 

[MajP]

@dalski,
Here is a pretty succinct discussion on events.

What You Need to Know About Access Events

There is often a lot of confusion about Access Events and often answering questions posed here is difficult because of inaccurate terminology. People often say "Event" when it is unclear if they mean the actual event that takes place, the event procedure, or the event property. This thread...

www.access-programmers.co.uk

 

[dalski]

Thanks Pete

@dalski,
Here is a pretty succinct discussion on events.

Thanks Pete

 

[jwcolby54]

@dalski,
Here is a pretty succinct discussion on events.

What You Need to Know About Access Events

There is often a lot of confusion about Access Events and often answering questions posed here is difficult because of inaccurate terminology. People often say "Event" when it is unclear if they mean the actual event that takes place, the event procedure, or the event property. This thread...

www.access-programmers.co.uk

@MajP I chuckle at your signature every time I read it. It does leave in question whether "your things" are a cut or more above good (my impression), or below good.

 

[NauticalGent]

I chuckle at your signature every time I read it. It does leave in question whether "your things" are a cut or more above good (my impression), or below good.

Do NOT go down that rabbit-hole. Once seen, it cannot be unseen...

 

[jwcolby54]

Nope. In Chrome, it downloads it. At least on my Chrome it does.

Interesting. I was on a zoom last night over at Access Pacific group and I was asking about this subject, specifically because there have been complaints or mutterings that my links weren't working. So we were testing. I use firefox and when I open the pdf for the book it happens more or less instantaneously, and the "path" of the document in the browser points back to GitHub. For a user who wants to read the thing offline, they need it to download. I could force it to download by opening it and hitting a little download button in the browser in the upper right corner below the address bar.

But it was decidedly not a download without additional effort. I am trying to make it that.

More stuff for me to figure out.

 

[MajP]

I chuckle at your signature every time I read it. It does leave in question whether "your things" are a cut or more above good (my impression), or below good

There is even a song to go with it. But I realize now I typed the quote wrong and should read "I've got mine"

And yes as @NauticalGent pointed out, super creepy and disturbing.

 

[cheekybuddha]

But I realize now I typed the quote wrong and should read "I've got mine"

Don't change it now - I always thought the mis-quote was funny (and intentional!)

Edit: actually, listening to the song again, both versions are used!