[mso] Re: Starting Access Project (naming fields)
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Thu, 5 Dec 2002 10:10:31 -0800
Linda (and Kay),
Spaces affect quite a bit in Access. They require a bit of additional work
when you start to get a little more advanced. A lot of the stuff that
Access does for you automatically are thwarted by spaces. For instance,
when you reference another field in a query or form, Access generally adds
the necessary brackets for you. However, if you have spaces in your field
names these brackets are inserted in the wrong places. Additionally, when
writing VBA code or if you want to try writing a query in SQL (Which is
necessary for some more advanced queries like Union queries) you will run
into slight problems of having to allow for the spaces. It is not a huge
problem but as you get more and more fields it becomes a bigger issue. So
yes, it is primarily a VBA issue, but also an SQL and convenience issue for
newer users.
I hope that clears that up a little.
James La Borde
South Western Federal Credit Union
-----Original Message-----
From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, December 05, 2002 9:44 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Starting Access Project (naming fields) :VSMail MX3
To add to what Peter said, James wrote an article for ABC on Leszynski's
naming conventions that's really helpful in understanding this....I'd
recommend you read it, Pam:
http://personal-computer-tutor.com/abc2/v9/james9.htm
I'm snowed in here and have nothing to do, so I'm having fun following
this thread and playing around in Access.
KAY...I hope you are reading this (Kay asked me in class last nite,
what happens if you put spaces in field names and I wasn't real
sure....I just knew you shouldn't....now I see that it really comes into
play when VBA steps in...thanks Peter)
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Peter Chiavaro
Sent: Thursday, December 05, 2002 12:19 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Starting Access Project (naming fields)
Good Morning Pam,
The advise of James La Borde in his previous post should be
followed to the "T". Of course you are one tiny step ahead since
you've already put together your first table.
To summarize Jame's post. You should always DRAW your database
design on paper before you start. That is the absolute first thing
you need to do.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
