Jim
Don't worry. In the end the dog ends up in a hospital in a body cast and the cat comes in. The cat says, "Here's your dinner...Oh, wait this time I didn't forget the gravy." And he pulls out a big pot of gravy and a hose. The dog got more gravy than he would have liked. {grin}
Bill
--- In MS_Access_Professionals@yahoogroups.com, Jim Wagner wrote:
>
> Wow. I am a little afraid now!!! I will be talking nice to my boss for awhile I guess
> Â
> Jim Wagner
> ________________________________
>
>
>
> ________________________________
> From: Bill Mosca
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, February 19, 2013 3:27 PM
> Subject: [MS_AccessPros] Re: List box question
>
>
> Â
> Jim
>
> I guess it's no gravy for the boss. Ever see that Looney Tunes Cartoon with the Dog that kept beating up the cat because the cat kept forgetting to bring gravy with the dog's food? Hope your boss doesn't beat you up. {grin}
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, Jim Wagner wrote:
> >
> > We thought of creating tables and put the objects in it, but my boss just wanted to see a list of queries to run at a moments notice for our boss. The mouse move is only gravy and it is really not important.ÂÂ
> > ÂÂ
> > Jim Wagner
> > ________________________________
> >
> >
> >
> > ________________________________
> > From: Jim Wagner
> > To: "MS_Access_Professionals@yahoogroups.comMS_Access_Professionals@yahoogroups.com>
> > Sent: Tuesday, February 19, 2013 2:41 PM
> > Subject: Re: [MS_AccessPros] Re: List box question
> >
> >
> > ÂÂ
> > I am not concerned with users in this database.It is our internal database for my boss and I only.ÂÂ
> > ÂÂ
> > Jim Wagner
> > ________________________________
> >
> > ________________________________
> > From: Duane Hookom duanehookom@>
> > To: Access Professionals Yahoo Group ms_access_professionals@yahoogroups.com>
> > Sent: Tuesday, February 19, 2013 2:25 PM
> > Subject: RE: [MS_AccessPros] Re: List box question
> >
> >
> > ÂÂ
> > I agree with Bill. I would never expose values from the msysobjects table to users. I almost always create a table of reports (or other objects) with a number of fields that provide a description, status, etc.ÂÂ
> >
> > You can use the Y value on the Mouse move to determine kinda which value of the list box the mouse is over. However, if you have a scroll bar, you would need to do a lot more coding to determine if the list is scrolled up or down.
> >
> > Duane Hookom MVP
> > MS Access
> >
> > ----------------------------------------
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: wrmosca@
> > > Date: Tue, 19 Feb 2013 20:28:22 +0000
> > > Subject: [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]
> > > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (19) |
Tidak ada komentar:
Posting Komentar