Scrolling (marquee) Tect
in [General]
|
From: Commish on 13 Apr 2010 12:24 I have a form in Access 2007 - and along the bottom, I want to add scrolling text - like a News Ticker. I don't need to display hard coded, static text, I want to use the results of a query - a query that chooses the 10 highest (most recent) values. I can create the query easily, and display it in a datasheet. But is there an easy way to have this scrolling along the bottom of an existing form?
From: Arvin Meyer [MVP] on 13 Apr 2010 13:05 Try this: http://www.datastrat.com/Download/Scroll.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Commish" <mark.wolven(a)gmail.com> wrote in message news:a7325869-09c6-481b-bd84-c7bfe6e0003c(a)m38g2000vbr.googlegroups.com... >I have a form in Access 2007 - and along the bottom, I want to add > scrolling text - like a News Ticker. > > I don't need to display hard coded, static text, I want to use the > results of a query - a query that chooses the 10 highest (most recent) > values. I can create the query easily, and display it in a datasheet. > > But is there an easy way to have this scrolling along the bottom of an > existing form?
From: Commish on 13 Apr 2010 13:42 On Apr 13, 1:05 pm, "Arvin Meyer [MVP]" <arv...(a)mvps.invalid> wrote: > Try this: > > http://www.datastrat.com/Download/Scroll.zip > > -- > Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.accessmvp.comhttp://www.mvps.org/access > > "Commish" <mark.wol...(a)gmail.com> wrote in message > > news:a7325869-09c6-481b-bd84-c7bfe6e0003c(a)m38g2000vbr.googlegroups.com... > > >I have a form in Access 2007 - and along the bottom, I want to add > > scrolling text - like a News Ticker. > > > I don't need to display hard coded, static text, I want to use the > > results of a query - a query that chooses the 10 highest (most recent) > > values. I can create the query easily, and display it in a datasheet. > > > But is there an easy way to have this scrolling along the bottom of an > > existing form? That's a good start - I can see that there's an Event Procedure associated with the On Timer event. Looking at the code, you've got it set to text. If I replace the text with [query].[field] - will this cycle through the records in the query?
From: Arvin Meyer [MVP] on 13 Apr 2010 23:06 "Commish" <mark.wolven(a)gmail.com> wrote in message news:0891ac3a-6420-41e7-b853-e7526ceb52b6(a)d27g2000vbl.googlegroups.com... On Apr 13, 1:05 pm, "Arvin Meyer [MVP]" <arv...(a)mvps.invalid> wrote: > Try this: > > http://www.datastrat.com/Download/Scroll.zip > > -- > Arvin Meyer, MCP, > MVPhttp://www.datastrat.comhttp://www.accessmvp.comhttp://www.mvps.org/access > > "Commish" <mark.wol...(a)gmail.com> wrote in message > > news:a7325869-09c6-481b-bd84-c7bfe6e0003c(a)m38g2000vbr.googlegroups.com... > > >I have a form in Access 2007 - and along the bottom, I want to add > > scrolling text - like a News Ticker. > > > I don't need to display hard coded, static text, I want to use the > > results of a query - a query that chooses the 10 highest (most recent) > > values. I can create the query easily, and display it in a datasheet. > > > But is there an easy way to have this scrolling along the bottom of an > > existing form? That's a good start - I can see that there's an Event Procedure associated with the On Timer event. Looking at the code, you've got it set to text. If I replace the text with [query].[field] - will this cycle through the records in the query? ================= No. You need to build a loop to cycle through the records and concatenate them into a long string. Then use that string in the code. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access
|
Pages: 1 Prev: draft house committee meeting minutes 4-12-10 Next: Access 2007 and the Internet |