ACCESS FEED: [MS_AccessPros] Re: List box question

Selasa, 19 Februari 2013

[MS_AccessPros] Re: List box question

Jim

Using the MSysObjects table is convenient, but in this case I can't think of a way to show something based on an item in the list box. Maybe you need to consider creating a report table instead of using the MSysObjects table.

Bill

--- In MS_Access_Professionals@yahoogroups.com, Jim Wagner wrote:
>
> Bill,
>
> I am showing the queries in the database.usingÂ
> SELECT MsysObjects.Name, Mid([Name],5) AS QueryName, MsysObjects.Type FROM MsysObjects WHERE (((MsysObjects.Type)=5)) ORDER BY MsysObjects.Name;Â
>
> Â
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: Bill Mosca
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, February 19, 2013 12:56 PM
> Subject: [MS_AccessPros] Re: List box question
>
>
> Â
> Jim
>
> You could rig a textbox. Store whatever info you want to display in the same table as the list item. Add the info field to your ListBox and set the text box ControlSource to the that second column.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
> My nothing-to-do-with-Access blog
> http://wrmosca.wordpress.com
>
> --- In MS_Access_Professionals@yahoogroups.com, "luvmymelody" wrote:
> >
> > Hello,
> >
> > Is there a way to have a control tip or a label appear when I hover over or click a item in a list box? the double click could be for opening a report.
> >
> > Thank You
> >
> > Jim Wagner
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>