Re: Continuous Form code for current record

Tech-Archive recommends: Fix windows errors by optimizing your registry

I'd also be interested in seeing a calculation that slows down your form's
opening to such an extent! How many records are we talking about here?

Your only options in a continuous form are, as suggested, to do the
calculations in the query or to store the calculation results in a bound
field. And before someone chimes in, as they always do, yes, storing
calculated results in a table is frowned on by many, but there are instances
where it's allowable! They're even circumstances where it's absolutely
necessary! You just have to weigh pros and cons and decide if the trade-off
is worth it to you; speed versus storage space.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

.

Relevant Pages

  • Re: Summary task durations are NOT responding to subtasks
    ... Check Tools, Options, Calculation: Calculation is probably set to Manual. ... Microsoft Project MVP ... sub tasks. ... Opening the file on another machine works fine. ...
    (microsoft.public.project)
  • How to stop calculation on open?
    ... Have an unwieldy workbook. ... It is set for manual calculation, ... I'd like to inhibit calculation when opening it as ...
    (microsoft.public.excel.programming)
  • Re: Forcing a certain order in SQL Where Clause
    ... The part that is the bad idea is storing the same information twice. ... Now it is certainly true that if status is not a real column and instead is computed every time, you do not want every application to have that calculation inside the app whenever the app retrieves this row. ... Now it is true that that means every time you reference the status column, SQL must recompute the value and there is a small cost to that. ... But even in this case you still want a computed column, it's just that now you want to make the computed column "PERSISTED". ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I have a second table pull info from the first table?
    ... W or L to add it up in a query? ... You shouldn't be storing wins and losses in Table ... time (a disk fetch is much slower than almost any reasonable calculation), ...
    (microsoft.public.access.forms)
  • Re: Storing calculated values in a field
    ... It's much simpler to grab the current rate and store it in the table. ... What you are describing is not "storing the result of a calculation". ... are describing is the copying of related data rather than retrieving it as ...
    (microsoft.public.access.formscoding)