ACCESS FEED: Re: [MS_AccessPros] Re: List box question

Selasa, 19 Februari 2013

Re: [MS_AccessPros] Re: List box question

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 wrmosca@comcast.net>
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]