Scrolling news using a record

[vbaInet]

Heres the code, where would I put it?

Integrate it into the two Mid() code lines.

 

[MKader12]

Try this sample I just put together. It appears to be a lot simpler than what you are attempting. It uses one table and the table only has one field. A record set is used to create the string for the scrolling text within the form. The form scrolls the text within a label and also along the bottom status bar. Ricky Hicks deserves the credit for his use of the Mid function within a Timer event to create the scrolling effect.

HTH

HELP...

1st thanks for this amazing code... if you can please tell me how to make your message board close after 40 seconds automatically..

Thanks,
MK

 

[Sharkiness]

Ou should be able to do a docmd.close with an on timer event

 

[MKader12]

Ou should be able to do a docmd.close with an on timer event

I've done it, yet, it freezes or close immediately.