[AccessD] Poll on Access 2007

Max Wanadoo max.wanadoo at gmail.com
Mon Jun 29 13:14:39 CDT 2009


Charlotte:

I am not sure this is the same thing.  But, when I used to code in Foxpro,
we had a function called Scatter MemVar and it opposite Gather MemVar.

These were terribly important and useful. Basically, you could take a table
and using Scatter, create a temporary variable for each field in the table
with the same name, prefixed by m. (M DOT).  It made coding very easy.
Gather put the contents back into the table.

As I say, tempvar need not be bad necessarily.

Max



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: 29 June 2009 19:05
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Poll on Access 2007

 I'll bet I could tell you how they implemented TempVar, because most of
us have created some variation on that theme in the past to get around
the limitations on global variables.  It would be hidden in the MS
implementation, but it has to be pretty much the same thing ... And it's
a great way to create a sloppy application: the easier it is, the
sloppier it becomes.

Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Monday, June 29, 2009 3:54 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Poll on Access 2007

Hi Shamil,

--------------------------------------------------
From: "Shamil Salakhetdinov" <shamil at smsconsulting.spb.ru>
Sent: Monday, June 29, 2009 10:19 PM

> ... did you find good use of those
> "interactive reports" features in your customers applications?

This is the confusingly-named 'Report View' of a report, which was new
to Access 2007 as an additional (i.e. as well as Print, Preview, etc)
view of a report.  Yes, I have used this a number of times, and found it
very nice. 
The user can use built-in right-click menus to filter the data, and you
can use the Click event to link from report records to detail forms,
etc.

Being able to assign a Control Source to an image control is another
thing I have had cause to use quite a lot.  Just a small thing, but
anything that saves time and effort for the developer is nice.

I have also really liked the new TempVar (temporary variable), which I
have used extensively.  Very easy to create anywhere, anytime, in your
code, and then can be used throughout the application in code, in query
criteria or calculated controls, in calculated expressions in form or
report controls, etc.  Very handy.

-- 
Regards
Steve 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list