473,396 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

uniquely identify selected records in a table

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

Apr 5 '07 #1
2 1693
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

Apr 5 '07 #2
On Apr 5, 2:28 pm, "Rick Brandt" <rickbran...@hotmail.comwrote:
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- Hide quoted text -

- Show quoted text -
Thank you Rick!

Apr 5 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Ross | last post by:
Hello everybody, When I try to configure my data adapter for ODBC I get the error "Could not determine which columns uniquely identify the rows for "Shipments"." This is for my update and delete...
4
by: acni | last post by:
I have the following peice of code to try and send an email to selected contacts in my form.The problem is this line: StrStore = DLookup("", "qrySelectEmail", "??????") This looks up the email...
6
by: Alan Silver | last post by:
Hello, After much battling, I think I am finally seeing some progress on my first user control (thanks to the patient souls who have answered my many questions!!). I am left with one more...
0
by: bazzer | last post by:
im trying to access a microsoft access database from an asp.net webform. but when i use the OdbcDataAdapter config wizard i get the following errors: *Generated UPDATE statement -could not...
7
by: bazzer | last post by:
i am having trouble updating a datset because i get the follwing error in the Data Adapter configuration Wizard: Generated UPDATE statement. could not determine which columns uniquely identify...
1
by: Anoop Nair | last post by:
Hi I am developing scripts in C# which can be used to test windows based applications. I use Win32 API's to perform click operations etc. To uniquely identify a control in a window rather than ...
10
by: Frankie | last post by:
It appears that System.Random would provide an acceptable means through which to generate a unique value used to identify multiple/concurrent asynchronous tasks. The usage of the value under...
6
by: Ryan Liu | last post by:
Hi, If I want to uniquely identify a computer. I can read CPU ID or Mac Address. I heard, but is this true: some BIOS can block CPU ID from being read? (In this case, will I get an exception,...
23
by: raylopez99 | last post by:
A quick sanity check, and I think I am correct, but just to make sure: if you have a bunch of objects that are very much like one another you can uniquely track them simply by using an ArrayList...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.