Scrolling Text From Query

[dan.cawthorne]

Hi,
Can I Have Scrolling Text Box but it dispays Query Results is it
Possible?

Ive Searched for scrolling text, and ive seen certain ways of using
labels to create scrolling text,

I Have a Query that Returns 15 Records, and i want those records to
scroll a cross the bottom on my page
can this be done?
Regards
Dan

 

[dan.cawthorne]

is their no one to help?

 

[John W. Vinson]

Hi,
Can I Have Scrolling Text Box but it dispays Query Results is it
Possible?

Ive Searched for scrolling text, and ive seen certain ways of using
labels to create scrolling text,

I Have a Query that Returns 15 Records, and i want those records to
scroll a cross the bottom on my page
can this be done?
Regards
Dan

If you want the records to move across the screen, you'll need some probably
quite complex VBA code using the form's Timer event (to redraw the contents of
a textbox every tenth of a second for example). It's not a builtin Access
feature.

I find moving text on a screen VERY hard to read and would vehemently object
to any application that forced me to read it in that way. Why do you feel you
need this!?

 

[dan.cawthorne]

If you want the records to move across the screen, you'll need some probably
quite complex VBA code using the form's Timer event (to redraw the contents of
a textbox every tenth of a second for example). It's not a builtin Access
feature.

I find moving text on a screen VERY hard to read and would vehemently object
to any application that forced me to read it in that way. Why do you feelyou
need this!?

Well thanks for reply, sorry its a little late

i was trying to expirement differnt ways to display over due projects,
so when any one opens the database ive created, when the switch board
opens ive created a little dialog type form, which is opened from the
switchboard openevent a dcount function which counts to see if their
is any enquirys in the query the form in based on and then it opens
the little dialog form, and at the moment it displays the current over
due projects. ive set the form up as contineous so user has to scroll
down to read the projects, ( I was trying to create like an outlook
new email notification type form) - which i think i need to set a
timer close function, say after a 1min close me.name

but instead of the user having to scroll the scroll bar, the scroll
bar moves down, on its own or text boz could just move from side and
show one record at a time.

does this make sense?

 

[John W. Vinson]

but instead of the user having to scroll the scroll bar, the scroll
bar moves down, on its own or text boz could just move from side and
show one record at a time.

does this make sense?

Not to me, sorry. I would find text that jumps around on the screen without
any rationale to be very annoying and distracting, and of NO help in getting
me to track urgent actions.

If you do want to annoy your users the only way I can imagine is using the
form's timer event to move to a different record, or to change the control
sources of multiple textboxes.

 

[AccessVandal via AccessMonster.com]

No, never make sense. Here something for you to try out. From Lebans,Jeff
Conrad...
This site is still up with links.

http://www.geocities.com/pmpg98_pt/VerticalMarquee.html