Display real-time access data via projector

Access 2003

I have an access database used for scoring a high school sporting
event. Data is entered as scores are turned in from the different
events throughout the day.

I would like to display data via multi-media projector in real time,
so students & teams know thier status at all times.

I am open to ideas about how to achieve this. I have tried reports
and continuous forms, but haven't found anything that I like so far. I
also know that this will take multiple PC's linked to the same data
source.

Any & All Suggestions are Appreciated!

Dale

Re: Display real-time access data via projector

"Dale" wrote in message
news:980ca2b4-2a06-425d-9bd0-bcc84c4df956@d4g2000prg.googleg roups.com...
> Access 2003
>
> I have an access database used for scoring a high school sporting
> event. Data is entered as scores are turned in from the different
> events throughout the day.
>
> I would like to display data via multi-media projector in real time,
> so students & teams know thier status at all times.
>
> I am open to ideas about how to achieve this. I have tried reports
> and continuous forms, but haven't found anything that I like so far. I
> also know that this will take multiple PC's linked to the same data
> source.
>
> Any & All Suggestions are Appreciated!
>
> Dale

How about a peer-to-peer network of pcs (or laptops). Each pc would be
running a local front-end mdb, linked to a network back-end mdb.

One pc would be attached to a powerpoint projector instead of a monitor.
That pc would be running the front-end mdb and set to have a specific form
open that displays the desired results upon the screen. The form could have
a timer event that updates/refreshes regularly (every minute or two, or
five).

The other pc(s) would be operating data entry/input forms with users
inputing scores as they are received.

Fred Zuckerman

Re: Display real-time access data via projector

"Dale" schreef in bericht =
news:980ca2b4-2a06-425d-9bd0-bcc84c4df956@d4g2000prg.googleg roups.com...
> Access 2003
>=20
> I have an access database used for scoring a high school sporting
> event. Data is entered as scores are turned in from the different
> events throughout the day.
>=20
> I would like to display data via multi-media projector in real time,
> so students & teams know thier status at all times.
>=20
> I am open to ideas about how to achieve this. I have tried reports
> and continuous forms, but haven't found anything that I like so far. I
> also know that this will take multiple PC's linked to the same data
> source.
>=20
> Any & All Suggestions are Appreciated!
>=20
> Dale

Last year I created a 'live' app where I present Outlook scheduling data =
on screen.
Data is synchronized with Outlook (and imported in Access) every 10 =
minutes.

So I would create a separate app to present the data on the screen.
Import or sync the relevant data in your app every xx minutes or so.
Show what you want to display on different screens/forms.
These screens could be subfoms, made visible when needed.=20
Use timerevents in the mainform to switch screens, switch recordsource =
and such.

Arno R

Re: Display real-time access data via projector

On Jan 24, 3:59=A0am, "Arno R" wrote:
> "Dale" schreef in berichtnews:980ca2b4-2a06-425d-9bd0-=
bcc84c4df956@d4g2000prg.googlegroups.com...
>
>
>
>
>
> > Access 2003
>
> > I have an access database used for scoring a high school sporting
> > event. Data is entered as scores are turned in from the different
> > events throughout the day.
>
> > I would like to display data via multi-media projector in real time,
> > so students & teams know thier status at all times.
>
> > I am open to ideas about how to achieve this. =A0I have tried reports
> > and continuous forms, but haven't found anything that I like so far. I
> > also know that this will take multiple PC's linked to the same data
> > source.
>
> > Any & All Suggestions are Appreciated!
>
> > Dale
>
> Last year I created a 'live' app where I present Outlook scheduling data o=
n screen.
> Data is synchronized with Outlook (and imported in Access) every 10 minute=
s.
>
> So I would create a separate app to present the data on the screen.
> Import or sync the relevant data in your app every xx minutes or so.
> Show what you want to display on different screens/forms.
> These screens could be subfoms, made visible when needed.
> Use timerevents in the mainform to switch screens, switch recordsource and=
such.
>
> Arno R- Hide quoted text -
>
> - Show quoted text -

Thanks everyone, this gives me a place to start.

Dale