scrolling data on bottomof form[RESOLVED]

[yousufkhan]

i wanted to scroll data from access table on the bottom of form or by taking a lable or text box etc..
till the form is active i wanted to keeep on displaying the records from the table 1 by 1 after some pause on that lable how can i do pls help

[llkhoutx]

Use the OnTimer event with an appropriate form Time Interval property to execute DAD or ADO code to cycle through the table recordset displaying your scrolling data in a text box.

[yousufkhan]

i have not use timer can you please give me a small example

[llkhoutx]

Unzip the attached zip file and open with A2K.

Form "form1" in the mdb will flash hello.

Look at the form in design view. Look at the OnTimer event, and the Timer Interval. The OnTimer event is triggered on the the Timer Interval which is in 1000ths of seconds, every second in the instant case (1000 = 1 second = 1000 1 thousandths of a second).

[yousufkhan]

i have tried to unzip the file there is only link for mdb and no form1
pls check it

[llkhoutx]

I've attached my zip file, desbibed above in this thread.

[yousufkhan]

i m not using A2K i doing it in vb 6 in vb6 there is no timer event on the form
i ll b using vb timer if i use the timer for scrolling records on the label at the bottom of the form simultneously i adding records into the same table and retreving also will it effect on the sppeed of programe or is there any other way to do this