View Full Version : fieldname with blanks, how to access them


Bruno
03-01-2006, 03:23 PM
Hi there,

within VBA, how can I access a table with fieldnames, containing blanks like
first field
second field

select first field, second field from table

I tried
select "first field", "second field" from table
but it did not work on my 2002 Access installation

thanks for any help

Bruno

Jan De Messemaeker
03-02-2006, 02:12 PM
Hi,

Maybe a newsgroup dealing with Access matters is better suited to help you.
This group deals with VBA on Microsoft project.
Greetings,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Bruno" <bruno_storz@gmx.de> schreef in bericht
news:4405b227$0$13127$8fe63b2a@news.disputo.net...
> Hi there,
>
> within VBA, how can I access a table with fieldnames, containing blanks
like
> first field
> second field
>
> select first field, second field from table
>
> I tried
> select "first field", "second field" from table
> but it did not work on my 2002 Access installation
>
> thanks for any help
>
> Bruno
>
>