473,320 Members | 1,804 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

'!' vs. '.'

Is there an advantage to using the '!' notation to represent form/
control relationships? (eg. Me!text1 vs Me.text1)

I am currently using the '.' notation exclusively (for code completion
in the VB Editor), but much of the high-quality code that I've seen
(in Duane Hookom's Query-by-Form db, for example) uses the other.

Apr 6 '07 #1
4 1960
Here's one opinion for you: http://doc.advisor.com/doc/05352

robert.waters wrote:
>Is there an advantage to using the '!' notation to represent form/
control relationships? (eg. Me!text1 vs Me.text1)

I am currently using the '.' notation exclusively (for code completion
in the VB Editor), but much of the high-quality code that I've seen
(in Duane Hookom's Query-by-Form db, for example) uses the other.
--
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200704/1

Apr 6 '07 #2
Here's my $0.02 worth on this.
I tend to copy the notation style and naming conventions that I see being
used in the Help files.

That would be Me![text1] for a control on a form. I am of the belief that
this notation explicitly refers to a control itself rather than a field in
the form's recordset.

Here's an example:
I have a parts inventory app that uses a "Line" code, which is usually a
3-character abbreviation for a brand name, and is the name of both the field
name and the bound text-box control on many of my forms. Because the word
"Line" is one of those not-quite-a-reserved-word things ... so Access can
get confused and pissy if I don't wrap it in square brackets.

The "[Square Brackets]" format also allows for control names that may have
spaces in them. (Not that I am in the habit of doing that.)
Another benefit (to me anyway) is that I am so used to using this format
that I do it by habit, so control references in my code really "stand out".

Like you, I will often allow the supplied "." format from the code editor to
get the spelling right (lazy), but then I go back and change it to the "bang
and brackets" style before compiling.
--
--
HTH,
Don
=============================
E-Mail (if you must) My*****@Telus.net

Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code samples are also Access97- based
unless otherwise noted.

================================================== ========================
"robert.waters" <ro***********@gmail.comwrote in message
news:11**********************@n76g2000hsh.googlegr oups.com...
Is there an advantage to using the '!' notation to represent form/
control relationships? (eg. Me!text1 vs Me.text1)

I am currently using the '.' notation exclusively (for code completion
in the VB Editor), but much of the high-quality code that I've seen
(in Duane Hookom's Query-by-Form db, for example) uses the other.

Apr 6 '07 #3

I don't feel there's an advantage, just preference. Some feel the
Intelisense is an advantage, but for me, I prefer refering to any
control on a form, from that form, using the '!'. When refering to
form controls from other modules, I think the '.' is a required
method. I've also heard arguments about increased likelyhood of errors
or corruption using one over the other, but I haven't come across that
happening yet.

Apr 6 '07 #4
On Apr 5, 10:12 pm, "Don Leverton"
<leveriteNoJunkM...@telusplanet.netwrote:
Here's my $0.02 worth on this.
I tend to copy the notation style and naming conventions that I see being
used in the Help files.

That would be Me![text1] for a control on a form. I am of the belief that
this notation explicitly refers to a control itself rather than a field in
the form's recordset.

Here's an example:
I have a parts inventory app that uses a "Line" code, which is usually a
3-character abbreviation for a brand name, and is the name of both the field
name and the bound text-box control on many of my forms. Because the word
"Line" is one of those not-quite-a-reserved-word things ... so Access can
get confused and pissy if I don't wrap it in square brackets.

The "[Square Brackets]" format also allows for control names that may have
spaces in them. (Not that I am in the habit of doing that.)
Another benefit (to me anyway) is that I am so used to using this format
that I do it by habit, so control references in my code really "stand out".

Like you, I will often allow the supplied "." format from the code editor to
get the spelling right (lazy), but then I go back and change it to the "bang
and brackets" style before compiling.

--
--
HTH,
Don
=============================
E-Mail (if you must) My.N...@Telus.net

Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code samples are also Access97- based
unless otherwise noted.

================================================== ========================

"robert.waters" <robert.wat...@gmail.comwrote in message

news:11**********************@n76g2000hsh.googlegr oups.com...
Is there an advantage to using the '!' notation to represent form/
control relationships? (eg. Me!text1 vs Me.text1)
I am currently using the '.' notation exclusively (for code completion
in the VB Editor), but much of the high-quality code that I've seen
(in Duane Hookom's Query-by-Form db, for example) uses the other.- Hide quoted text -

- Show quoted text -
IMHO one should NEVER name a control the same as a field in the
datasource. Poor naming convention. In fact in my convention, all
controls are prefixed with a 1 or 2 letters that describe the type of
control followed by the field name so that a text box that displays a
field called Address1 would be called tbAddress1. I rarely if ever
'reuse' a name.

Apr 6 '07 #5

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

Similar topics

3
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)...
2
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...
3
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...
0
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. ...
1
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...
4
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...
1
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 ...
2
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...
3
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.