How to turn of Query auto calculation (1 Viewer)

Infinite

More left to learn.

Local time

Yesterday, 21:38

Joined

Mar 16, 2015

Messages

402

• Jan 16, 2016

• #1

In excel your able to turn of the calculations from running, unless the user specifies to. Is that possible to do that with access? Thanks!

 

MarkK

bit cruncher

Local time

Yesterday, 21:38

Joined

Mar 17, 2004

Messages

8,179

• Jan 17, 2016

• #2

Yes. For instance, if something gets calculated in Access, it is always possible to not do that calculation.

Hope this helps,

 

Infinite

More left to learn.

Local time

Yesterday, 21:38

Joined

Mar 16, 2015

Messages

402

• Jan 17, 2016

• #3

Well yes, I could just turn it into a append query, and append it to a (for instance) tblQuery1 instead of qryQuery1. But that quickly gets cluttered.

 

Infinite

More left to learn.

Local time

Yesterday, 21:38

Joined

Mar 16, 2015

Messages

402

• Jan 22, 2016

• #4

Yes. For instance, if something gets calculated in Access, it is always possible to not do that calculation.

Click to expand...

How would I do that?

 

MarkK

bit cruncher

Local time

Yesterday, 21:38

Joined

Mar 17, 2004

Messages

8,179

• Jan 22, 2016

• #5

Combine the use of an IF...END IF block and a toggle button, or a check box, or some other comparison to a value the user can set. If the comparison fails, skip the operation.
Consider the following code, which, when run and if the check box is set, does the operation

Code:Copy to clipboard

If Me.chkDoTheOperation Then
[COLOR="Green"]   ' do the operation[/COLOR]
End If

In this way the user can control whether an operation occurs.
Hope it helps,

 

Infinite

More left to learn.

Local time

Yesterday, 21:38

Joined

Mar 16, 2015

Messages

402

• Jan 22, 2016

• #6

Thing is, that is the easy part. What I want, is the have to data already, and if I want the most recent data, then run the query. So lets say I have a frmQuery, and it is based off of qryQuery. But the qryQuery takes 8 days to run, so I only want it to run once, and see the data in frmQuery. But if the user wants the most recent data, then they may run qryQuery. Is that possible?

 

MarkK

bit cruncher

Local time

Yesterday, 21:38

Joined

Mar 17, 2004

Messages

8,179

• Jan 22, 2016

• #7

I think I answered the question you posed in your original post. If you have a different question, I recommend you start a new thread.