HI:
I see the term "Me!" in a lot of Access statements, bit don't quite know what it means. In
the same contexts as wondering what the meaning if "is" is, I wonder what the meaning of
"Me!" is.
Can someone enlighten me?
Regards
John Baker 7 27186
John,
"Me" is the reference to the active form.
Some examples:
You can refer to the textbox on the form bound to the Customername field with
Me!Customer.
You can requery the form with Me.Requery
You can make the form not visible with Me.Visible = False
The key to using "Me" is that the form has to be the acyive object at the point
"Me" is used.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"John Baker" <Ba******@Veriz on.net> wrote in message
news:et******** *************** *********@4ax.c om... HI:
I see the term "Me!" in a lot of Access statements, bit don't quite know what
it means. In the same contexts as wondering what the meaning if "is" is, I wonder what the
meaning of "Me!" is.
Can someone enlighten me?
Regards
John Baker
Steve:
Thank you.
John
"Steve" <sp**@nospam.co m> wrote: John,
"Me" is the reference to the active form.
Some examples: You can refer to the textbox on the form bound to the Customername field with Me!Customer. You can requery the form with Me.Requery You can make the form not visible with Me.Visible = False
The key to using "Me" is that the form has to be the acyive object at the point "Me" is used.
RE/ I see the term "Me!" in a lot of Access statements, bit don't quite know what it means. In the same contexts as wondering what the meaning if "is" is, I wonder what the meaning of "Me!" is.
Can someone enlighten me?
It says that what comes after the exclaimation point is an object on the same
form that the code resides in.
You can also use Me. The dot notation has a couple of advantages:
1) Autocompletion. As soon as you type the dot, you get a popup list of
available objects.
2) Avoidence of runtime errors. If you misspell a name using dot notation, the
compiler will catch it. With the exclaimation point, it compiles but fails
when that line of code tries to execute.
--
PeteCresswell
On Sat, 13 Dec 2003 13:41:17 GMT, Steve wrote: "Me" is the reference to the active form.
.... and report.
Peter
--
No mails please.
"Peter Doering" <no****@doering .org> wrote... On Sat, 13 Dec 2003 13:41:17 GMT, Steve wrote:
"Me" is the reference to the active form.
... and report.
....and class.
--
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.
x@y.z ((Pete Cresswell)) wrote in
<ia************ *************** *****@4ax.com>: RE/I see the term "Me!" in a lot of Access statements, bit don't quite know what it means. In the same contexts as wondering what the meaning if "is" is, I wonder what the meaning of "Me!" is.
Can someone enlighten me? It says that what comes after the exclaimation point is an object on the same form that the code resides in.
You can also use Me. The dot notation has a couple of advantages:
1) Autocompletion. As soon as you type the dot, you get a popup list of available objects.
Ctrl-space gives you an autocomplete menu that works just as well
as the default autocomplete. Also, on a relatively slow computer,
it can be annoying to have to wait for the autocomplete list.
Another thing is that I don't need the autocomplete list all the
time. Ctrl-space will also complete automatically for you if you've
already typed enough characters for a unique match in the list.
2) Avoidence of runtime errors. If you misspell a name using dot notation, the compiler will catch it. With the exclaimation point, it compiles but fails when that line of code tries to execute.
It also has a downside, in that it depends on functionality that
you can't control (Access automatically creates hidden properties
to allow you to refer to controls with Me.), and it can lead to
corruption in certain limited circumstances.
I also think it sacrifices code comprehensibili ty, where ! makes
clear that you're referring to a control or field, rather than a
property or method of the form/report you're working in.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"Michael \(michka\) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
news:3f******** @news.microsoft .com: "Peter Doering" <no****@doering .org> wrote...
On Sat, 13 Dec 2003 13:41:17 GMT, Steve wrote:
> "Me" is the reference to the active form.
... and report.
...and class.
It is the last of these that is the real meaning of Me. Forms and Reports
are actually classes, and a sub/function within the code for a Form or
Report is really a method of the class. Me is not a reference to the
*ACTIVE* form/report; it is a reference to the form in which the function
appears. A form or report can be unfocused, minimized or even hidden yet
its code can still execute (e.g. a Timer event on a form, or a report
calling a method on a hidden form to retrieve a parameter value) , and to
the code being executed, "Me" is that (unfocused/minimized/hidden) form or
report where the code lives. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: mike420 |
last post by:
In the context of LATEX, some Pythonista asked what the big
successes of Lisp were. I think there were at least three *big*
successes.
a. orbitz.com web site uses Lisp for algorithms, etc.
b. Yahoo store was originally written in Lisp.
c. Emacs
The issues with these will probably come up, so I might as well
mention them myself (which will also make this a more balanced
|
by: KevinLee |
last post by:
I found that the STL.NET published with VS Beta2, but what is the meaning of
STL.NET.
Is it just a simple wrapper to replace the old std stl?
I can find nothing new but the keyword 'Generate' to replace 'Template',and
the keyword 'gcnew' to replace 'new'.
So, could you tell me what's the meaning of STL.NET.
I really think it is still very ugly.
|
by: Sueffel |
last post by:
Okay, I have my controls, and in each one's key_down even, I have:
Me.SelectNextControl(Me.ActiveControl,True,True,False,True)
All controls I need do have the TabStops and do have Index's set. I have
stuff that each control has to do(Validation) before it moves on, so the
Form.KeyPreview is out.
Thank,
Sueffel
|
by: yxq |
last post by:
Hello,
There are the C# codes£¬but i know a little about C#, i want to convert to
VB.NET, i have try the
url(http://authors.aspalliance.com/aldotnet/examples/translate.aspx), but
the converted codes will not work. Thank you!
char Source = new char
int n, hi, low, v;
|
by: Robert Seacord |
last post by:
The SEI has published CMU/SEI-2006-TR-006 "Specifications for Managed
Strings" and released a "proof-of-concept" implementation of the managed
string library.
The specification, source code for the library, and other resources
related to managed strings are available for download from the CERT web
site at:
http://www.cert.org/secure-coding/managedstring.html
| |
by: arnuld |
last post by:
i have just started to learn C++ from Bruce Eckel's book "Thinking in
C++ 2/e" & i am trying to understand the meaning of "j++". ++j is
pretty clear to me. i am using "g++" on my Debian Sarge.
here is the problem:
i = j = k = l = 0
++i ---i = 0 ;; OK, fine
|
by: stonemcstone |
last post by:
I've been programming in C for years, and never experienced troubles
until I started using the new RealC-32, a freeware C compiler from the
same company that makes RealPlayer and Quicktime. That's when the
trouble started. See, RealC-32 is like any other C compiler but with
one notable difference. Any time your code invokes undefined
behavior-- for example by dereferencing an uninitialized pointer--
rather than the usual segmentation...
|
by: emyl |
last post by:
Hi all,
here's an elementary question. Assume I have declared two variables,
char *a, **b;
I can then give a value to a like
a="hello world";
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |