Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

Clickable datasheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NeoFax - 09 Apr 2008 21:11 GMT
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?
NetworkTrade - 09 Apr 2008 22:22 GMT
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.
Signature

NTC

> 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?
NeoFax - 11 Apr 2008 13:10 GMT
On Apr 9, 5:22 pm, NetworkTrade
<NetworkTr...@discussions.microsoft.com> wrote:
> It probably is not feasible for you.  It would require alot of coding I think.
>
[quoted text clipped - 13 lines]
>
> - Show quoted text -

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!
NetworkTrade - 12 Apr 2008 14:52 GMT
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.
Signature

NTC

> On Apr 9, 5:22 pm, NetworkTrade
> <NetworkTr...@discussions.microsoft.com> wrote:
[quoted text clipped - 19 lines]
> type style allowing the technicians to check multiple items at once
> instead of one, requery next, requery...?  Thanks!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.