Re: Are TempVars Good or Evil?
- From: "david" <david@xxxxxxxxx>
- Date: Tue, 11 Nov 2008 12:12:01 +1100
Very few experienced people here use Macro's to code
their applications.
This is partly because many of the people here have long
experience, and new features like Access 2007 TempVars
are new.
And partly because many of the people here have long
experience, and have already worked out that VBA is
more powerful and flexible.
Macros will do
all of what all people want most of the time,
all of what most people want all of the time,
most of what all people want all of the time,
but not all of what all people want all of the time, and once
you have the VBA there isn't any point in also having Macro's.
From your point of view, one of the effects of this is that manyof the most helpful people here don't actually have much experience
with Macro's and don't have an opinion about TempVars.
(david)
"Kari" <Kari@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:96994928-75C2-44E2-BE34-E9CEE515477E@xxxxxxxxxxxxxxxx
Not so long ago when I was just learning Access, I found some code
somewhere
that helped me open a report with criteria set on a form. The code used a
Temporary Variable to collect the info from the form (via a textbox) and
filter the query.
Now I'm revisiting the report, trying to add some additional functinality
and I'm wondering about that Temp. Variable. I've not seen TempVars in
any
form suggested as solutions to anything. When I search on them I find
almost
nothing on this discussion board (one poster wanted to know how to track
them
and one tried to use them with no success). None of the books I've seen
mention them and help is (as is common) not very helpful (there just isn't
much there).
My question for you experts out there is: are Temp Vars good or evil? Are
they a good tool used in the right circumstances or will they come back to
haunt you and make you wish you had never taken up the Programmers
Keyboard?
If they're useful, what circumstances call for them? What are the
pitfalls
to watch out for? Are Global Variables a better idea?
I'd like to get the opinions of those who've used Access for a long time
(not just beginning to get comfortable with it, like me) to figure out if
I
should retool my existing report, and whether I should use them in future
applications.
I appreciate your time and opinions.
Kari
.
- References:
- Are TempVars Good or Evil?
- From: Kari
- Are TempVars Good or Evil?
- Prev by Date: Re: Get deleted primary keys
- Next by Date: Re: Are TempVars Good or Evil?
- Previous by thread: Re: Are TempVars Good or Evil?
- Next by thread: Re: Are TempVars Good or Evil?
- Index(es):
Relevant Pages
|
