Re: Open a form from a record in Querry result or Table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Reggie (NoSpamreggie_at_NoSpamsmittysinet.com)
Date: 07/19/04 

Date: Sun, 18 Jul 2004 23:51:39 -0700

David, queries do not have events associated with them. Design a form and
base the recordsource of the form to the query. The form has all the events
you mention. If you want it to be displayed to look like the query result
set the view of the form to data***. 

-- 
Reggie
----------
"David" <David@discussions.microsoft.com> wrote in message
news:5E330944-FF42-431C-BF4D-A9CFA2170BAF@microsoft.com...
> Hi Jeff,
> I am sorry the 100 column seems to have side-tracked my question.
> Actually it doesn't matter if it is 10 or 100 columns, for my purpose.
> I can repose my question is a different way:
> I open a form.
> It triggers a querry which produces so many rows of data on the screen.
> When I click on (or mouse over) a row in the query result, I want my form
to recognize that "event".
> The questions is:  how could the click on the query result be captured as
an event by the form?
> I look into the "properties" associated with a select query and do not
find "events" associated with the the life of a select query.
> I suppose some coding may be needed.
> Any hints on how to get it done?
> David
>
> "Jeff Boyce" wrote:
>
> > David
> >
> > !Red flag!
> >
> > Access is a relational database ... and it sounds like you have
"committed
> > spread***" on it!  A look through the tablesdbdesign newsgroup will
reveal
> > that it is VERY uncommon to have more than 30 or so fields in a well
> > normalized database design.  ?100 fields?!
> >
> > We could discuss "how to's" for a long time, but unless you revisit the
> > topic of normalization and consider revising your table structure, we
will
> > be trying to make Access do things it is neither intended nor designed
to do
> > well.  Sorta like trying to drive nails with a chainsaw <g> ...
> >
> > You can do it, and even succeed, but it's a lot harder than using the
> > correct tool, and the risk of "hurting yourself" is a lot higher.
> >
> > Good luck!
> >
> > Jeff Boyce
> > <Access MVP>
> >
> >
Quantcast