Access World Addiction Anonymous

[MajP]

ok Maj, I already told you that custom classes can be substituted in an easier way. any beginner in this industry isn't gonna pay your food bill to receive a product they don't understand. maybe I should just write that FAQ on class modules.

maybe I should just write that FAQ on class modules..

Oh my god, that is rich. I am standing by for enlightenment. Dude give it up. A hair on my ass has more knowledge on Access and VBA then you will ever have. Put up or shut up. I have not seen you drop a piece a viable code, it is a bunch of blah, blah, I think, blah. Look, I try to like you Adam and be on your team. seriously. But do not F with me. You will have to call the United Nations to get a binding resolution to keep me from destroying you. Besides that I am totally on your team and we are cool. I am Yoda and you are Skywalker so just listen.

 

[NauticalGent]

I am Yoda and you are Skywalker so just listen

Only SkyWalker knew when to close his mouth and open his eyes and ears. VBA_PhP has yet to learn that and I daresay he never will.

 

[vba_php]

Oh my god, that is rich. I am standing by for enlightenment. Dude give it up. A hair on my ass has more knowledge on Access and VBA then you will ever have. Put up or shut up. I have not seen you drop a piece a viable code, it is a bunch of blah, blah, I think, blah. Look, I try to like you Adam and be on your team. seriously. But do not F with me. You will have to call the United Nations to get a binding resolution to keep me from destroying you. Besides that I am totally on your team and we are cool. I am Yoda and you are Skywalker so just listen.

it wasn't a dig on you Maj! OK then I'm listening. you can say whatever you want and my ears are open. or rather, my lightsaber is lit.

 

[Jon]

We don't allow offensive weapons on the forum, except the mouth.

 

[vba_php]

We don't allow offensive weapons on the forum, except the mouth.

both of ours right?

by the way, if anyone with authority is reading this, will I ever have any privileges to post a faq in the appropriate place around here? I suppose it's about time to put something up worth while, at least to satisfy all the thousands of my critics around here.

 

[Dreamweaver]

Privlileges are earnt

 

[Jon]

Words are violence.

 

[The_Doc_Man]

my lightsaber is lit.

Per Jon's advice, no weapons. So instead of light sabers, show us your true brilliance. Because all too often, you hide your light under a bushel and as a result, your bulb looks dim.

 

[moke123]

both of ours right?

by the way, if anyone with authority is reading this, will I ever have any privileges to post a faq in the appropriate place around here? I suppose it's about time to put something up worth while, at least to satisfy all the thousands of my critics around here.

 

[GinaWhipp]

Hmm, just bring wine or beer, no weapons.

 

[Dreamweaver]

Your so easy One beers all it takes @GinaWhipp

 

[vba_php]

show us your true brilliance. Because all too often, you hide your light under a bushel and as a result, your bulb looks dim.

well how do I do that? is that what moke's post means?

 

[MajP]

maybe I should just write that FAQ on class modules....

PLEASE do not. If anyone should it would be me. You could, but do you really think there is anyone who posts more about this than I do. If the plethora of code I have posted does not prove that, then have at it. I am sure it will be a enlightening. Take a look here. Make a treeview in one line of code. Is this in your skillset..

Hierarchical Data, Recursion, Tree-Views, and a Custom Class to Assist

I have had some people ask questions on working with Hierarchical data and Tree Views, which often involves using recursion. If not familiar with recursion this is where a procedure repeatedly calls itself until hitting a condition where it is told to stop. This is used often where you have to...

www.access-programmers.co.uk

Here is the thing, we all have a skillset, but Access and VBA is not yours. It is mine. I have no idea about php so I would not even try. So stay in your swim lane. this is mine.[/QUOTE]

 

[Dreamweaver]

I spent 3-4 years with PHP when I was running my other site 12ish years ago though

 

[Jon]

What was your site about Mick?

 

[vba_php]

but Access and VBA is not yours. It is mine. I have no idea about php so I would not even try. So stay in your swim lane. this is mine.

don't take this the wrong way Yoda, but do you realize that all programming languages are nothing by hierarchial patterns? that's exactly why the corporate people of the world will be able to automate code writing in the future, and thus turn the programmers into button clickers. I was sure you would've figured that out by now. no? but any FAQ that I post would certainly not be anything as complicated as a tree like that! I don't work with anyone that would understand even 10% of what you posted. I do have a custom-class example in PHP but I'd have to find the code to post it. but to give you an idea of the parallelism between 2 languages, how about this? (javascript and vba, no PHP here):

int x; (js).....dim x (vba)
int x = 1; (js).....const x = 1 (vba)

a js function:

function retVal() {
   int x;
   int ret;
      for (x = 1; x <10; x++) {
         ret = ret + x }
   return ret;
}

and the VBA equivalent of it:

function retVal as integer
   dim x as integer
   dim ret as integer
      for x = 1 to 9
         ret = ret + x
      next x
   retVal = ret
end function

does that help "enlighten" you, Maj? I hope I got all that right!

<edit>
maybe that should have been:

int x; (js).....dim x as integer(vba)
int x = 1; (js).....dim x as integer (vba)
            .......... x = 1 (vba)

 

[Dreamweaver]

What was your site about Mick?

Same name as now but was a music Chart Site I used to create charts in Access upload to mysql with Vb I got ill so had to stop but that was a long time ago
I used a free forum that at that time was free and edited it to my needs I'll see if theres an archive of it

 

[vba_php]

oh and hey Maj, when it comes to things like recursion and other engineering concepts I did not go to school for...the way I sort those out, if I indeed need to explain it to someone, is to write it down step by step and put it in common sense terms and relate it to a concept in real life that every human who is non-technical understands. I am one of very few people I would assume that can do such a thing. per my faq, which is pretty much finished:

if you want to think about a custom class and it's properties, think about a mother and 3 children living in her household. without the mother, the children cannot survive and have no purpose in terms of who they can "follow" and get guidance from. same is true of a class and it's properties. without the class object in existence, properties are completely pointless and serve no purpose because they do not have a parent

feel free to correct my "lack of knowledge" if there is any there. remember, I'm not schooled in this!

 

[The_Doc_Man]

For one thing, your mother/child and class/property analogy is terribly flawed. The properties are not merely pointless if the class has not been instantiated... the properties don't exist at all. Attributes of things that require instantiation just DON'T EXIST until instantiation.

A child can exist (once born) even if the mother dies and thus ceases to exist. A property of a class simply DOES NOT EXIST outside the class, before it is created or after it is destroyed.

As to "not schooled in this" ... yes, we can tell.

 

[vba_php]

For one thing, your mother/child and class/property analogy is terribly flawed. The properties are not merely pointless if the class has not been instantiated... the properties don't exist at all. Attributes of things that require instantiation just DON'T EXIST until instantiation.

A child can exist (once born) even if the mother dies and thus ceases to exist. A property of a class simply DOES NOT EXIST outside the class, before it is created or after it is destroyed.

As to "not schooled in this" ... yes, we can tell.

that's a great explanation Richard. and that's a pretty good education you gave me. but to a young person that knows nothing about programming, I'm pretty sure my way would work better than yours in terms of relating to the individual. but to make my words better and more on-point regarding the theoretical nature and thought process of our work, I should probably re-word what I said after adopting some suggestions from you.

regarding you comment of ""a property does not exist until instantiation""....if you said that to a newbie who was 18 years old and knew nothing, you would more than likely lose the poor soul immediately and they'd walk away from you feeling stupid. I've seen that a countless number of times. a great example is the young man I'm talking to who's going through the process of being confirmed as a catholic with me. he told me that his professor at his community college asked him what a library was. and he told me that his response was: "it's a variable, isn't it?" So you see, someone like that, if they talked to someone like you or the rest of the "pros" here, would walk away from you right away because you've just done something you accuse me of all the time => putting the cart before the horse. so I guess we could both learn something from this, huh?

in terms of his confusion, would I be accurate in my statement if I told him that the following was the definition of library in Python?

a PY or PYD file is nothing more than just a set of structural entities, or "structs" that can do any number of things. but the baseline purpose of it is to provide you, the programmer, the low-level resources you need to build a program in the python language

what do you think Richard? The same is true in any language, isn't it? for instance, VBA has COMs, DLLs, OLBs and OCXs. Per my website (partial images):