Query fonts etc

[bknight]

I'm trying to remember the Access programming class I took in the 90's. so using A97 or A2k is there a way through programing/or hard coded into the query design to change font color criteria todays date versus a date in the tables? Memory losses are a constant nagging issue with me sometimes.

[HansV]

What do you mean by "to change font color criteria todays date versus a date in the tables"?

[bknight]

For example if the target date is greater than todays date make the output of the query green.

[HansV]

You cannot do that in a query.

On a form or report in Access 2000, you can apply conditional formatting to text boxes and combo boxes using Format > Conditional Formatting.
In Access 97, you'd have to use VBA code. This is relatively easy on a single form and on a report; it's much more difficult on a continuous form.

[bknight]

This is all That I have to work with.

EDIT: Adding Field parameters

[HansV]

Again, you cannot set this in a query.

[bknight]

Only in a report?

[HansV]

In Access 2000, you can use conditional formatting for text boxes and combo boxes on a form and on a report.

[bknight]

Something like this, but doesn't work.

[HansV]

@Today() is not valid in Access. Use Date() instead (without @).

[bknight]

That worked!

[HansV]

Good to hear that.

[bknight]

Is there a shortcut/key stroke combination the "refreshes" a query? The only way I have been able to accomplish this is to go to design view and then back to datasheet view.

[HansV]

When you open a select query, there is a Refresh All button on the Home tab of the ribbon. There is no specific keyboard shortcut for this button, but you can use Alt+H, K, R, E

[bknight]

All four keys with Alt selected? I get a ping when I do something like that.

[HansV]

No, hold down Alt while pressing H, then release Alt (this will have selected the Home tab of the ribbon).
Then press K and R and E one after the other.
(This is the sequence that works in Access 2016; I don't have Access 2007 to test on)

[bknight]

Alt +H, results in KR icon over The refresh all in the ribbon.
After KR you get A or E choice.
Thanks

[Rudi]

For others reading this post; this is the sequence in visuals... (Access 2013)

Holding down ALT, then pressing "H" results in this:

SC001.jpg

After releasing all the keys and then pressing "K" results in this:

SC002.jpg

Now pressing "R" results in this:

SC003.jpg

Lastly press "A" for Refresh All or "E" for Refresh.

This is the end of the presentation. You may all now advance to the back of the room and grab some refreshments and a muffin.

[BobSullivan]

When I want to re-run my queries, I press Shift+F9. Is that the same as a refresh?

[HansV]

Shift+F9 "requeries the underlying tables", i.e. it reruns the active query or refreshes the active form.