Thanks again Roland for going through all these troubles. Your kindness is
so much appreciated. If you were somewhere near me I'd buy you some
chocolates!
I'll test your pages tonight.
Regards,
Conax
"Roland Hall" <nobody@nowhere> wrote in message
news:#uSAhGVxDHA.2156@TK2MSFTNGP09.phx.gbl...[color=blue]
> Ok. I have a working model. Let me know if this will work for you and[/color]
I'll[color=blue]
> make the code available.
>
> I created a database:
> conax.mdb
>
> table:
> table1
>
> fields:
> id (autogenerated)
> field1 (text 50)
>
> I have an input page: // add records to the database here
> link:
>
http://kiddanger.com/lab/conaxform.asp
>
> And I have a report page:
> link:
>
http://kiddanger.com/lab/conaxframeset.asp
>
> Frameset contains two pages:
>
http://kiddanger.com/lab/conaxfront.asp
>
http://kiddanger.com/lab/conaxback.asp
>
> Conaxfront.asp has a scrollable DIV which is what will be updated.
> The timer on conaxback.asp will call a function that will reload this page
> in the hidden frame. This is the engine.
> This page will make a trip to the server to gather the current records.
> It will clear the DIV in the conaxfront frame and then populate it with[/color]
the[color=blue]
> current records from the database.
> --Note: If you were going to have a lot of records, I would maintain an
> index and just add the additional record. I'm not sure what the[/color]
performance[color=blue]
> difference would be but for this application, it didn't sound like you[/color]
would[color=blue]
> have that many.
> The rest of the page is not affected.
> I put an animated image on the frame to show you it does not get reloaded
> when the timer updates the records displayed.
> I didn't build a fancy interface and I don't have a page to delete or[/color]
modify[color=blue]
> records but that's not part of this scope.
>
> You have to add records and then monitor the report page. The timer will
> update the page every 60 seconds.
>
> --
> Roland
>
> This information is distributed in the hope that it will be useful, but
> without any warranty; without even the implied warranty of merchantability
> or fitness for a particular purpose.
>
>[/color]