Changing color of query data

[Majic]

Hey Guys,
Is it possible to change font color of query data? If so, please
help!

Thank you

Majic

 

[Jeff Boyce]

This is a "tablesdbdesign" newsgroup -- how does changing font color in a
query apply?

Try posting in the "queries" newsgroup, and adding a bit more description.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Pat Hartman]

There are default values that you can set under Tools/Options/Datasheet.
These will apply to ALL datasheets in the application and might even
transcend applications if this is one of those "all database" settings. You
can modify the settings in VBA when you use a form but not when you use a
query or open a datasheet of a table directly. Only forms/reports have
events where you can "hang" code which is why you cannot affect these
attributes on the fly for queries and tables.

I frequently set the background color of datasheet forms in the form's open
event. This makes them blend better with their parent forms since I never
use datasheet forms except as subforms on other forms.

Private Sub Form_Open(Cancel As Integer)
Me.DatasheetBackColor = 15000779
End Sub

 

[Majic]

There are default values that you can set under Tools/Options/Datasheet.
These will apply to ALL datasheets in the application and might even
transcend applications if this is one of those "all database" settings. You
can modify the settings in VBA when you use a form but not when you use a
query or open a datasheet of a table directly. Only forms/reports have
events where you can "hang" code which is why you cannot affect these
attributes on the fly for queries and tables.

I frequently set the background color of datasheet forms in the form's open
event. This makes them blend better with their parent forms since I never
use datasheet forms except as subforms on other forms.

Private Sub Form_Open(Cancel As Integer)
Me.DatasheetBackColor = 15000779
End Sub








- Show quoted text -

Thank you so much. By any chance do you know how to flag an urgent
order by flahing colors.
Here is what I have: there are one person who is doing the data entry
in High Point and her manager is in Greensboro. The Manager will have
his screen open, however, he wants to be alerted when the person who
is doing the data entry enters an urgent item.
So, I thought it something flashing or message pop up, but the problem
with the message because they both on the same screen I thing the pop
up message will not work. Any ideas?

Thank you

Majic

 

[Pat Hartman]

I would use email to flag urgent requests. Just having a form open will not
cause new items to appear. The automatic form refresh only updates values
for existing records and marks deleted records. You actually have to
requery the form to get records added since the form was opened to appear.

You can use conditional formatting to control the color of urgent items.