Search results

I understand that I have not yet achieved the Expert classification here. However wouldn't coming into "my" (I am the OP here) thread and implying (at the very least) that I was doing this wrong be a slight? I had another poster suggest that I was perhaps unqualified to teach this subject...

I took out the quotes just for you @NauticalGent . ;) My meaning is still clear I suppose?

Having little or nothing to do with OpenArgs except it was a convenient place to test this stuff: ' 'I am making the value variant simply because I have no clue 'what variable type any given property might accept. ' Public Function fSetFormProperty(strPropertyName As String, varPropertyValue As...

A function to allow testing pushing OpenArgs into form properties. Many properties are only settable in design mode. In the immediate window perform the following: fTestOpenArgs "Caption=Hello;" More scary "Visible=False". Yes it hides the opened form. Function fTestOpenArgs(strOpenArgs...

The Book this is a link to my blog. The link there downloads the book and / or the demo database directly from GitHub into your downloads dir. For some reason, at least on my computer, the link is randomly opening to another blog post rather than to the blog post regarding the book. No se...

The Book I am sending you to my blog where links to the book and the db exist. I just tested this and it is working for me. And the book is even hotter than the banging!!!

My intent was to point out that "experts" were doing things not particularly expert nor helpful. I absolutely agree that both individuals are experts. But their suggested solutions were not particularly so. IMO of course. And this points out the problem I have with folks just jumping in to a...

Well that works. First I made the clsOpenArgs up in the form's header public so that I could see it from outside the form. Option Compare Database Option Explicit Public mclsOpenArgs As clsOpenArgs Of course the correct way to do this is to create a property in the form to expose the...

One of the things I played with long ago was intentionally passing in form properties values as OpenArgs. As an example the visible property can potentially be set as it opens. The x/y coordinates could be set to position the form on the screen. My class was designed to just test across all...

The link seems to work now. And I oh so wish the banging was hot! :ROFLMAO:

True. There are actually folks out there called wedding crashers who just enjoy crashing weddings. :ROFLMAO:

>>>I really don't understand why you're triggered when an expert tries to tell there are better ways. Well... an expert was proposing that you use a dictionary for "the better way". Scripting being deprecated No dictionaries needed to do what was being proposed. A dictionary is a neat tool...

LOL. I am writing an entire book. Which is free BTW. The book - Event Driven Programming in VBA A circular reference is where class A references class B which references class A. It is common, in fact it is entirely widespread. My clsFrm (read the book) grabs a pointer to the form and...

LOL, indeed. Look, I appreciate any effort anyone makes to teach this stuff. However I am getting banged with "why don't you just use a sql statement) or etc etc etc. There are literally a dozen ways any given problem can be approached. Do you honestly believe I am not capable of just using a...

As I have said dozens of times now, I am attempting to teach classes and frameworks. As I have said many times, there must be 50 ways to leave your lover. If I am not careful I can have a dozen developers chipping in how their (fill in the blanks) solution is so much better and why. Not the...

This is all true. It will continue adding in records until it hits a record "in the way" and then it will fail with an error. @Pat Hartman had very cool code to reset the counter to the last used +1. Obviously if one is recovering archived records, one can't just let the autonumber continue...

I designed a little form to demonstrate OpenArgs. Go to the debug window and type in: docmd.OpenForm "frmOpenArgsDemo",acNormal,,,,acWindowNormal,"OpenArg1=OpenArgVal1;CarVal=$12345.92;Color=Blue;" The code behind form shown above runs the show here. It isn't doing anything particularly...

LOL is this necessary? There must be 50 ways to leave your lover. I am teaching classes, not where clauses in SQL. Of course you can write your own posts demonstrating however you think would be better. I designed a framework. A framework allows every form to have behaviors. In my world...

I remember this from back in the early 2000s when I actually Access'd for a living.

BTW clsOpenArgs can just be dimensioned in any form header and used directly in that form. Option Compare Database Option Explicit Dim mclsOpenArgs As clsOpenArgs Private Sub Form_Close() Set mclsOpenArgs = Nothing End Sub Private Sub Form_Open(Cancel As Integer) Set mclsOpenArgs =...