Airport Arrival and Departure Board

[cheer]

I am building an airport arrival and departure board system. Is anyone know where to download or plug in the said component ?

The component (or table) has the feature to move up existing data before it is replaced by with NEW data

I have attached a picture to illustrate the scenario

 

[pbaldy]

That could be done by simply requerying a form or report based on a query that drew out the appropriate data. Presumably one of the criteria would drop flights X minutes after arrival or cancellation.

 

[cheer]

What i know is MS Access, I can
a) Form
use the Me.Recordset.MoveNext to move to next record. However, end user is looking something like every 3 minutes, the first page data is moving upwards slowly before new set of data is replacing the existing one. There is a animation to show the moving upward action

Anyone has the example to show the animation ?

b) Report
Any example to show exactly how this can be done by using form ?

 

[pbaldy]

Forms and reports have timer events, which can be used to requery them at a given interval. Based on the appropriate query, you'd get exactly the behavior you're looking for.