Re: uniquely identify selected records in a table



Takeadoe wrote:
Folks,

From what I've been able to gather from previous posts, I gather that
the answer to my question is probably NO - but I'll ask just to make
sure.

I want to do the following:

1) Run a select query to find Record x.
2) Change the value in Field 1 of Record X from "Yesterday" to
"Tomorrow"
3) Change the font color, font size, border, fill, anything associated
with this record so that it can be uniquely identified by someone at a
later date.

It will be a table that will be accessed by lots of people with little
or no Access experience - sort of like myself, so it will have to be
simple.

Thank you so much for your help.

Mike

Nope. You need to save some DATA in that record that can be used to find
the record at a later date. None of that other stuff is "associated with a
record".

Now, you could store some data in that record and have code in a report that
would see that data and make that record on the report have diffferent
color, shading, font, whatever, but you can't make the table do that by
itself.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



.



Relevant Pages

  • Re: Default Font
    ... write some Automation code to format the report after the export is ... Microsoft Access MVP ... Excel is set to the same default font as Access but each ...
    (microsoft.public.access.queries)
  • Re: Change row font color
    ... of my report I have control to designate the particular course (Red, Green, ... course green font, Orange course orange font, etc. ... Hugh ... >I am using Access 2000 and would like to change the font color of the first ...
    (microsoft.public.access.reports)
  • Re: uniquely identify selected records in a table
    ... Change the font color, font size, border, fill, anything associated ... would see that data and make that record on the report have diffferent ... Rick Brandt, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: Dynamic Report
    ... report, then open the report in, what, IE, and cause it to be printed there? ... one of the steps necessary is to have it dynamically select a font size ... programming I provide to Word to perform the task. ... those templates to the sections of the text. ...
    (microsoft.public.access.reports)
  • RE: Problem after VS 2008 sp1 or something else
    ... both install IDAutomationHC39M_FREE font. ... the report must be installed on the report server and on the client ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)