The meaning of "Me!"

[John Baker]

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]

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******@pcdatasheet.com
www.pcdatasheet.com

"John Baker" <Ba******@Verizon.net> wrote in message
news:et********************************@4ax.com...

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

[John Baker]

Steve:

Thank you.

John

"Steve" <sp**@nospam.com> 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.

[(Pete Cresswell)]

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

[Peter Doering]

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.

[Michael \(michka\) Kaplan [MS]]

"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.

[David W. Fenton]

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 comprehensibility, 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

[Ross Presser]

"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.