Scrolling Marquee using Query Results

[thexxvi]

Good morning,



I am having trouble with coding a scrolling marquee that would use information that is pulled forward from a query. The query has the following fields:

[Team Name]
[Round]
[Round Pick]
[Player Picked]
[Position]
[Team]
[Overall Pick]

Ideally, what I would like is to have the scrolling marquee display the following:

(QUERY RECORD 1's INFORMATION) "Round" [Round], "Pick" [Round Pick], "Overall Pick" [Overall Pick] - [Team Name] - [Player Picked], [Position], [Team] // (QUERY RECORD 2's INFORMATION) "Round" [Round], "Pick" [Round Pick], "Overall Pick" [Overall Pick] - [Team Name] - [Player Picked], [Position], [Team] and so on...

with real information, it would look like this:

Round 1, Pick 1, Overall Pick 1 - Team 1 Name - Aaron Rodgers, QB, Green Bay Packers // Round 1, Pick 2, Overall Pick 2 - Team 2 Name - Cam Newton, QB, Carolina Panthers // Round 1, Pick 3, Overall Pick 3 - Team 3 Name - Andrew Luck, QB, Indianapolis Colts


I've come up with a code, but it includes a DLookup for every piece of information and it crashes access (as it should because I know that DLookups are completely inefficient).

Any thoughts on how this can be accomplished?

Thank you!

[ranman256]

cant you just show a form with all these fields?

[apr pillai]

I think you should build a string combining data and place it on a textbox control and move it from right to left. The method is explained on this link with the sample program and you may download the demo database:

http://www.msaccesstips.com/2006/10/reminder-ticker-form/


http://www.msaccesstips.com/downloads/2008/10/wave-shaped-ticker/

[thexxvi]

No ranman256. That will not work.

Thank you apr pillai. I'll try it and reply back. By the way, your second link did not work.