What is Me! and how is it used?

[newvision]

What is Me! and how is it used? I am trying to convert an Access db to
an OpenOffice.org Base. I am new to programming and do not know what
the 'Me' operator is for or how it is used let alone what it's
equivalent in OOo.org Base is. Can anyone shed some light for me?
Thanks

[Larry Linson]

<ne*******@swva.netwrote

What is Me! and how is it used? I am trying to convert an Access db to
an OpenOffice.org Base. I am new to programming and do not know what
the 'Me' operator is for or how it is used let alone what it's
equivalent in OOo.org Base is. Can anyone shed some light for me?

"Me" refers to the currently active object in VBA class module code (a
Form's code or a Report's code is a class module), thus for a Form named
frmYours, with a TextBox named txtYours, "Me.txtYours" in the form's module
is equivalent to "Forms!frmYours.txtYours".

Larry Linson
Microsoft Access MVP

[newvision]

Thanks - that is helpful

[David W. Fenton]

"Larry Linson" <bo*****@localhost.notwrote in
news:Nb8rh.2712$hi7.1795@trnddc08:

"Me" refers to the currently active object in VBA class module
code

I see my campaign to get everybody to answer this question correctly
has worked. ;)

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Keith Wilby]

"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...

"Larry Linson" <bo*****@localhost.notwrote in
news:Nb8rh.2712$hi7.1795@trnddc08:

>"Me" refers to the currently active object in VBA class module
code

I see my campaign to get everybody to answer this question correctly
has worked. ;)

Was there ever any other answer? ;-)

Keith.

[Larry Linson]

"Keith Wilby" <he**@there.comwrote in message
news:45**********@glkas0286.greenlnk.net...

"David W. Fenton" <XX*******@dfenton.com.invalidwrote in message
news:Xn**********************************@127.0.0. 1...

>"Larry Linson" <bo*****@localhost.notwrote in
news:Nb8rh.2712$hi7.1795@trnddc08:

>>"Me" refers to the currently active object in VBA class module
code

I see my campaign to get everybody to answer this question correctly
has worked. ;)

Was there ever any other answer? ;-)

Yes, the most practical answer for most posters: "Me refers to the Form or
Report in whose module this shortcut is used." <;-) <Note the dunce cap
on my smiley>

I know there are situations where class modules can be helpful, but I have
never written a class module in Access other than as an experiment or demo.
David and others find them more useful than I do, and he is absolutely
correct that it is "class modules" rather than "Forms and Reports" only. If
I were "immersed in the object view", I'd probably be more interested in
DotNet and some other platforms than I am.

Larry

[David W. Fenton]

"Larry Linson" <bo*****@localhost.notwrote in
news:PSArh.3788$E35.2745@trnddc02:

I know there are situations where class modules can be helpful,
but I have never written a class module in Access other than as an
experiment or demo. David and others find them more useful than I
do, and he is absolutely correct that it is "class modules" rather
than "Forms and Reports" only. If I were "immersed in the object
view", I'd probably be more interested in DotNet and some other
platforms than I am.

But the VBE changed the presentation model, in that the form and
report class modules show up in the list in the VBE, not just
modules and class modules. This makes it easier to see that these
are variations of the same thing, and it's something that most
anyone who is using "Me" would be exposed to.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[(PeteCresswell)]

Per ne*******@swva.net:

'Me' operator

Maybe I'm not getting all the posts in the thread, but from here it looks like
nobody has taken up the diff between Me! and Me. yet.

Or did I just miss that part?
--
PeteCresswell