[mso] Re: Starting Access Project (naming fields)
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 05 Dec 2002 17:49:28 -0500
Thanks James. I hope Kay read that and can report it to the rest of the
class next week. LOL
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 James LaBorde
Sent: Thursday, December 05, 2002 1:11 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Starting Access Project (naming fields)
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
*************************************************************
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:
