Please No Space!!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kennykee - 04 May 2005 07:38 GMT

How to type a control source or field or a form where they have spaces
between the words in vba?

eg codes and product

if
Me!codes and product ==>error
Me!customer details ==>error

Any solution?

Thanks in advance

Kennykee

Reply to this Message

'69 Camaro - 04 May 2005 08:21 GMT

Hi, Kenny.

> How to type a control source or field or a form where they have spaces
> between the words in vba?

Smile and thank these folks who created the Access database for keeping you
gainfully employed for years to come while you find work-arounds for all of
the software application problems they created. If there are spaces or
special characters in the names of tables or fields (any identifier, really),
or if key words or reserved words are used for these identifiers, place
brackets around the name and Jet and Access will parse the identifier
correctly in an expression. Keep in mind that non-standard identifiers can't
be parsed within most database servers, so upgrading a database application
full of these non-standard identifiers will be quite time-consuming and keep
you (or your successor) employed in this era of I.T. downsizing.

Example syntax:

Me![codes and product]

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are Ripley@CASInternet.Net and scott@ripleysoftware.com

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.

> How to type a control source or field or a form where they have spaces
> between the words in vba?
[quoted text clipped - 10 lines]
>
> Kennykee

Reply to this Message

Klatuu - 04 May 2005 14:24 GMT

LOL,
How right you are. I have been surviving off the stupidity of others form
many years. Sometimes its like being the guy who cleans outhouses.
Interestingly enough, the guy who first hired me and taught me my first
programming language (COBOL) told me that it is not hard in this business to
look like the knight in shining armour because there are so many dragons to
be slayed.

In this case, where there are so many bad naming convention problems, I
would use Speed Feret to zoom through the database and make better names.
Oh, and a litte testing afterward would not be a bad idea.

> Hi, Kenny.
>
[quoted text clipped - 50 lines]
> >
> > Kennykee

Reply to this Message

'69 Camaro - 04 May 2005 23:49 GMT

Hi, Klatuu.

> I have been surviving off the stupidity of others form
> many years.

Inexperienced and uneducated in how computers work doesn't mean that these
computer users are stupid. They can be experts in other fields that benefit
immensely from the automation and speed of calculations computers can
provide. And if you think these people are stupid, these folks catch on to
you very quickly -- even if you never say a word about it.

> the guy who first hired me and taught me my first
> programming language (COBOL)

Was that at Northrop or at Grumman? Or at one of your company's more recent
acquisitions, like Litton?

> told me that it is not hard in this business to
> look like the knight in shining armour because there are so many dragons
> to
> be slayed.

Having people squeal with delight, jump up and down, hug me and kiss me,
screaming, "You fixed it! You saved my job!" does have a certain appeal, I
have to admit. It's one of the fringe benefits of being in the hero
business. ;-)

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are Ripley@CASInternet.Net and scott@ripleysoftware.com

> LOL,
> How right you are. I have been surviving off the stupidity of others form
[quoted text clipped - 74 lines]
>> >
>> > Kennykee

Reply to this Message

Klatuu - 05 May 2005 14:17 GMT

Sorry you misunderstood me. I was not denigrating users at all. I was
refering to some of the so call IT "experts" that create more problems than
solutions. What I meant was there is so much bad software in the world,
fixing or replacing it will keep me busy for as long as I want to work.

Don't mistake that I think I am better or know more than anyone else. There
are some real pros and I have had the good fortune to work with and learn
from them.

I have not been at Northop Grumman very long. I first leaned programming
in 1977 working for a small company that assisted taxing authorities collect
unpaid property taxes. From there I went into Banking where I worked
interfacing Mini computers (remember them) DEC and Tandem to the mainframe.
And as minis died away, I got into the PC world. First with a language that
was ported from Basic4 to DOS called Business Basic, then Dbase, Foxpro, and
now, for the last 5 yrs, Access.

And finally, yes, I like being an adored rock star :)

> Hi, Klatuu.
>
[quoted text clipped - 111 lines]
> >> >
> >> > Kennykee

Reply to this Message