By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,826 Members | 2,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,826 IT Pros & Developers. It's quick & easy.

What is Me! and how is it used?

P: n/a
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

Jan 16 '07 #1
Share this Question
Share on Google+
7 Replies


P: n/a
<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
Jan 16 '07 #2

P: n/a
Thanks - that is helpful

Jan 16 '07 #3

P: n/a
"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/
Jan 17 '07 #4

P: n/a
"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.
Jan 17 '07 #5

P: n/a

"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
Jan 18 '07 #6

P: n/a
"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/
Jan 18 '07 #7

P: n/a
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
Jan 19 '07 #8

This discussion thread is closed

Replies have been disabled for this discussion.