Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / March 2007

Tip: Looking for answers? Try searching our database.

is [] needed?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
clara - 14 Mar 2007 19:56 GMT
Hi all,

Is [] needed in definition of parameter query.when is it supposed to used?

Clara

thank you so much for your help
Stefan Hoffmann - 14 Mar 2007 21:04 GMT
hi Clara,

> Is [] needed in definition of parameter query.when is it supposed to used?
You need the square brackets when your field names include special
characters like space or hyphen.

mfG
--> stefan <--
clara - 14 Mar 2007 21:30 GMT
Hi Stefan,

What does field really mean ? I know it might refer to field in a table, a
control on a form, and a parameter in a query. what else?

Clara
thank you so much for your help

> hi Clara,
>
[quoted text clipped - 4 lines]
> mfG
> --> stefan <--
Stefan Hoffmann - 14 Mar 2007 23:26 GMT
hi Clara,

> What does field really mean ? I know it might refer to field in a table, a
> control on a form, and a parameter in a query. what else?
You're right. You need them for any identifier containing special
characters.

mfG
--> stefan <--
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.