Scrolling Text From Query

D

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
 
J

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!?
 
D

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?
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top