473,583 Members | 3,553 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

let and get

Can anyone explain me the joy of let and get. Once more, I read the
explanation in the help, but did not get much wiser.

I seem to learn best from examples, but I did not come across any good
ones...

Thank you Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
Nov 13 '05 #1
9 14642
Let is how you set the value of a property of a class, Get is how you pass
the value back.

In your class, you'd have something like:

Private mstrBlah As String

Public Property Let Blah(Value As String)
mstrBlah = Value
End Property

Public Property Get Blah() As String
Blah = mstrBlah
End Property

Then, in your code that's instantiated an instance of MyClass, you'd have
something like:

MyClass.Blah = "zxy"

to call the Let property to assign a value for Blah to the instance of the
class, and

strBlah = MyClass.Blah

to call the Get property to retrieve that value.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Oo******** ***********@new s.xtra.co.nz...
Can anyone explain me the joy of let and get. Once more, I read the
explanation in the help, but did not get much wiser.

I seem to learn best from examples, but I did not come across any good
ones...

Thank you Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

Nov 13 '05 #2
Let is how you set the value of a property of a class, Get is how you pass
the value back.

In your class, you'd have something like:

Private mstrBlah As String

Public Property Let Blah(Value As String)
mstrBlah = Value
End Property

Public Property Get Blah() As String
Blah = mstrBlah
End Property

Then, in your code that's instantiated an instance of MyClass, you'd have
something like:

MyClass.Blah = "zxy"

to call the Let property to assign a value for Blah to the instance of the
class, and

strBlah = MyClass.Blah

to call the Get property to retrieve that value.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Oo******** ***********@new s.xtra.co.nz...
Can anyone explain me the joy of let and get. Once more, I read the
explanation in the help, but did not get much wiser.

I seem to learn best from examples, but I did not come across any good
ones...

Thank you Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

Nov 13 '05 #3
Dear Doug

I read your email a couple of times to understand it all and I think I do.
However, what I do not understand is the big picture. I worked out, it is
similar to for example

Frm.Caption = "Input form" as a let statement

and Str = Frm.Caption as a get statement

but when and how do you use this sort of stuff and where, how and for how
long does access store the value???

I hope this does not sound stupid or ignorant.

Thank you

Nicolaas


"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:mR******** **********@news 01.bloor.is.net .cable.rogers.c om...
Let is how you set the value of a property of a class, Get is how you pass
the value back.

In your class, you'd have something like:

Private mstrBlah As String

Public Property Let Blah(Value As String)
mstrBlah = Value
End Property

Public Property Get Blah() As String
Blah = mstrBlah
End Property

Then, in your code that's instantiated an instance of MyClass, you'd have
something like:

MyClass.Blah = "zxy"

to call the Let property to assign a value for Blah to the instance of the
class, and

strBlah = MyClass.Blah

to call the Get property to retrieve that value.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Oo******** ***********@new s.xtra.co.nz...
Can anyone explain me the joy of let and get. Once more, I read the
explanation in the help, but did not get much wiser.

I seem to learn best from examples, but I did not come across any good
ones...

Thank you Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this

email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
Nov 13 '05 #4
This is done in conjunction with classes. You've got another fairly lengthy
thread about classes in this newsgroup that hopefully explains what a class
is and when you'd use it.

When you assign a value to a instantiated class, that value should last for
as long as the class remains instantiated.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:q3******** ************@ne ws.xtra.co.nz.. .
Dear Doug

I read your email a couple of times to understand it all and I think I do.
However, what I do not understand is the big picture. I worked out, it is
similar to for example

Frm.Caption = "Input form" as a let statement

and Str = Frm.Caption as a get statement

but when and how do you use this sort of stuff and where, how and for how
long does access store the value???

I hope this does not sound stupid or ignorant.

Thank you

Nicolaas


"Douglas J. Steele" <NOSPAM_djsteel e@NOSPAM_canada .com> wrote in message
news:mR******** **********@news 01.bloor.is.net .cable.rogers.c om...
Let is how you set the value of a property of a class, Get is how you pass the value back.

In your class, you'd have something like:

Private mstrBlah As String

Public Property Let Blah(Value As String)
mstrBlah = Value
End Property

Public Property Get Blah() As String
Blah = mstrBlah
End Property

Then, in your code that's instantiated an instance of MyClass, you'd have something like:

MyClass.Blah = "zxy"

to call the Let property to assign a value for Blah to the instance of the class, and

strBlah = MyClass.Blah

to call the Get property to retrieve that value.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Oo******** ***********@new s.xtra.co.nz...
Can anyone explain me the joy of let and get. Once more, I read the
explanation in the help, but did not get much wiser.

I seem to learn best from examples, but I did not come across any good
ones...

Thank you Nicolaas
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004


---
Please immediately let us know (by phone or return email) if (a) this

email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

Nov 13 '05 #5
Douglas J. Steele wrote:
This is done in conjunction with classes.


But let and get properties were enabled for standard modules in AC2K.
Nov 13 '05 #6
Yes, they were -- and are a useful way to wrap global variables. But their
primary purpose is for use in classes.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Lyle Fairfield" <ly***********@ netscape.net> wrote in message
news:2h******** ****@uni-berlin.de...
Douglas J. Steele wrote:
This is done in conjunction with classes.


But let and get properties were enabled for standard modules in AC2K.

Nov 13 '05 #7
another dumb question, further to this let and get discussion.

Would it not be much easier to store values in a (temporary) table???

this just seems a lot more tangible.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******@n ews.microsoft.c om...
Yes, they were -- and are a useful way to wrap global variables. But their
primary purpose is for use in classes.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Lyle Fairfield" <ly***********@ netscape.net> wrote in message
news:2h******** ****@uni-berlin.de...
Douglas J. Steele wrote:
This is done in conjunction with classes.


But let and get properties were enabled for standard modules in AC2K.


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
Nov 13 '05 #8
Hi Nicolaas,

The thread is incomplete so I may be missing the point of your post. Also,
the first part I see is a response to an email???

If all you want to do is store values then a table will do it better than
anything else. I seem to recall a thread originated by you in the last few
days about classes so I assume this discussion is still about that.

First, a confession: I've been so busy doing other things and nothing at
all that I haven't really gotten into classes and objects. But I do know
that they are great! A class module is a "cookie cutter" you design it to
have all of the properties and behaviors that you want the objects of that
class to have. You can then create any number of instances of objects (the
cookies). If you want to change something about the class, you change it in
the class module and thereafter all of the objects you create from that
class will have the new behavior or properties.

Ken Getz has included a chapter or so in the last several editions of The
Access [YourVersion] Developer's Handbook from Sybex. Deborah Kurata has
written a few books about Doing Objects in Microsoft Visual Basic
[YourVersion].

Storage is more of an issue than you might have imagined. Variable
information that must persist across sessions must be stored in a file or
table.

To directly address your question about Let and Get: You can validate the
argument passed in with the let and be sure it fits your paradigm. You can
also have the Let initiate some other process inside your object which would
be beyond the capabilities of an Access table. The same is true of the Get.
Also, you are not making the actual variables visible to the using program,
only the properties via your code.

There are snippets of information available all over the internet but I
recommend going for a good book first.

HTH
--
-Larry-
--

"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:Cw******** ************@ne ws.xtra.co.nz.. .
another dumb question, further to this let and get discussion.

Would it not be much easier to store values in a (temporary) table???

this just seems a lot more tangible.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:40******@n ews.microsoft.c om...
Yes, they were -- and are a useful way to wrap global variables. But their primary purpose is for use in classes.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Lyle Fairfield" <ly***********@ netscape.net> wrote in message
news:2h******** ****@uni-berlin.de...
Douglas J. Steele wrote:
> This is done in conjunction with classes.

But let and get properties were enabled for standard modules in AC2K.

---
Please immediately let us know (by phone or return email) if (a) this

email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004

Nov 13 '05 #9
Dear All,

I have really been doing a lot of reading here, thank you so much for all
your replies.

I know finally really understand this "let set get class module thing."
Great

Although I cannot really see where I should be using it, I definitely see
advantages. One of the biggest ones is the autocompletion (where you can
see all the methods and properties). That really simplifies working.

Thank you all once more for all your ideas.


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.690 / Virus Database: 451 - Release Date: 22/05/2004
Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
11194
by: William C. White | last post by:
Does anyone know of a way to use PHP /w Authorize.net AIM without using cURL? Our website is hosted on a shared drive and the webhost company doesn't installed additional software (such as cURL) on the server because of that. Our site will have an SSL certificate next week, so I would like to use AIM instead of SIM, however, I don't know how...
2
5789
by: Albert Ahtenberg | last post by:
Hello, I don't know if it is only me but I was sure that header("Location:url") redirects the browser instantly to URL, or at least stops the execution of the code. But appearantely it continues to execute the code until the browser send his reply to the header instruction. So an exit(); after each redirection won't hurt at all
3
22985
by: James | last post by:
Hi, I have a form with 2 fields. 'A' 'B' The user completes one of the fields and the form is submitted. On the results page I want to run a query, but this will change subject to which field is completed.
0
8455
by: Ollivier Robert | last post by:
Hello, I'm trying to link PHP with Oracle 9.2.0/OCI8 with gcc 3.2.3 on a Solaris9 system. The link succeeds but everytime I try to run php, I get a SEGV from inside the libcnltsh.so library. 354 roberto@ausone:Build/php-4.3.2> ldd /opt/php4/bin/php libsablot.so.0 => /usr/local/lib/libsablot.so.0 libstdc++.so.5 => ...
1
8558
by: Richard Galli | last post by:
I want viewers to compare state laws on a single subject. Imagine a three-column table with a drop-down box on the top. A viewer selects a state from the list, and that state's text fills the column below. The viewer can select states from the drop down lists above the other two columns as well. If the viewer selects only one, only one...
4
18236
by: Albert Ahtenberg | last post by:
Hello, I have two questions. 1. When the user presses the back button and returns to a form he filled the form is reseted. How do I leave there the values he inserted? 2. When the user comes back to a page where he had a submitted POST data the browser keeps telling that the data has expired and asks if repost. How to avoid...
1
6796
by: inderjit S Gabrie | last post by:
Hi all Here is the scenerio ...is it possibly to do this... i am getting valid course dates output on to a web which i have designed ....all is okay so far , look at the following web url http://www.mis.gla.ac.uk/biquery/training/ but each of the courses held have maximum of 8 people that could be
2
31368
by: Jack | last post by:
Hi All, What is the PHP equivilent of Oracle bind variables in a SQL statement, e.g. select x from y where z=:parameter Which in asp/jsp would be followed by some statements to bind a value to :parameter I dont like the idea of making the SQL statement on the fly without binding parameters as I dont want a highly polluted SQL cache.
3
23552
by: Sandwick | last post by:
I am trying to change the size of a drawing so they are all 3x3. the script below is what i was trying to use to cut it in half ... I get errors. I can display the normal picture but not the results of the picture half the size. The PHP I have installed support 1.62 or higher. And all I would like to do is take and image and make it fit a...
0
7894
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
8172
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8320
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7929
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8190
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5697
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5370
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3814
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1424
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.