Clickable datasheet

N

NeoFax

I would like to have a subform that displays in datasheet view that
highlights the line item when clicked and if double clicked added to a
table as an urgent/critical item. How would I accomplish this?
 
N

NetworkTrade

It probably is not feasible for you. It would require alot of coding I think.

What would be viable would be to add a new field to the underlying table of
the subform; a yes/no field This is a field that could be checked if
Urgent.

It would not "add" a record to an urgent table - I don't view that as a
normal database method.....but you would be able to query on the checkfield
"yes" condition to show all urgent items.
 
N

NeoFax

It probably is not feasible for you.  It would require alot of coding I think.

What would be viable would be to add a new field to the underlying table of
the subform; a yes/no field    This is a field that could be checked if
Urgent.

It would not "add" a record to an urgent table - I don't view that as a
normal database method.....but you would be able to query on the checkfield
"yes" condition to show all urgent items.
--
NTC





- Show quoted text -
Click to expand...

I guess that is what I meant, but how do I display it in a datasheet
type style allowing the technicians to check multiple items at once
instead of one, requery next, requery...? Thanks!
 
N

NetworkTrade

assuming you've added the yes/no field to your table;

the set of data is the table - or a query that is a subset of the data; a
query is preferable because it allows you to sort the presentation and also
filter out the yes from the no.

you originally mention it being a subform; you can insert a subform into a
main form with the subform being a table, a query or another form

I myself generally prefer a form - you can easily make a quick continous
form of the query using form wizard tabular....strip off the page
header/footer that wizard automatically creates and you have a simple form
that is ideal for use as a subform...

It is a continous form so the user is not looking at one record at a time -
one views all the records the query presents. However you call it a subform
- and when you attempt to insert the subform the Wizard is going to prompt
you as to what is the logical link between the main form and subform... so
whatever relationship you establish can limit what is view.. this is very
fundamental database stuff...you can set there to be no link between the main
& subform and so the subform will show everything from the query regardless
of which record the main form is sourced on....

I hope this helps.
 
Top