Q. Why isn't there an expression builder in the Visual Basic Editor?

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Hi.

Can someone tell me why the Visual Basic Editor doesn't have an
expression builder, to help me utilize the code I need ?

If there is, how do I go about "building" my code, while in the editor
?

Thanks,
Jim
 
Jim said:
Can someone tell me why the Visual Basic Editor doesn't have an
expression builder, to help me utilize the code I need ?
Click to expand...

I doubt it. The people that made that decision (10 years
ago) are mostly long gone. They probably figured that by
the time you understand the VBA language, you would also
have a rudimentary understanding of the Access Object Model,
but who knows?

If there is, how do I go about "building" my code, while in the editor?
Click to expand...

One cool aid that has been added is the IntelliSense
feature. Once you type an object name followed by a dot, it
presents a list of the object's properties and methods that
can be used with the object. It's not perfect, but it is a
real help.

If your question is not really about the expression builder,
which was removed in A2K, but more a question of how to
write VBA procedures, then I suggest that you get a book on
the subject from your local library.
 
I doubt it. The people that made that decision (10 years
ago) are mostly long gone. They probably figured that by
the time you understand the VBA language, you would also
have a rudimentary understanding of the Access Object Model,
but who knows?



One cool aid that has been added is the IntelliSense
feature.
Click to expand...

Yes, I use it often, just to automate the simple things:
ex. DoCmd.Maximize etc.
Once you type an object name followed by a dot, it
presents a list of the object's properties and methods that
can be used with the object. It's not perfect, but it is a
real help.

If your question is not really about the expression builder,
which was removed in A2K, but more a question of how to
write VBA procedures, then I suggest that you get a book on
the subject from your local library.
Click to expand...

That's proven to be as helpful as purchasing a factory Toyota
automobile repair manual to aid me in diagnosing and fixing my car's
problem. The problem is: I drive a different make of car altogether.
That's how useful I see those books.

Only one book like that ever helped me. It was by Wrox, on
Assembler language. Compete examples, Excellent explanations, and
they didn't write in that microscopic font.

I don't know about these author's that write the garbage they do, but
when I was a kid going to school, the way we learned was very
structured. Clarity as well as complete sentences were stressed,
including having to learn the breakdown of the different parts of
sentences, in English grammar.

I was never the brightest bulb in the room, but I did well.

I read newly published computer books (over the last few years)
that appear to me to have been written by people who probably have
trouble speaking the language.

So, to reply to your suggestion, yes I have not only visited my local
library, but EVERY book store in the area in search of that
well-written book.

When I do find that book, I'll go back and pay that store clerk an
extra $100.

Jim
 
Good computer books are very difficult to find. Many are written by hacks.
It is not like the classic textbooks one used in school written by eminent
authorities with years of training and a keen mind honed by years of
thinking.

Visual Basic is not theoretical physics.
Do expect to find jewels in a low rent slum.
Often the best resource I can find is the reference manual.
 
Back
Top