dbTalk Databases Forums  

Display real-time access data via projector

comp.databases.ms-access comp.databases.ms-access


Discuss Display real-time access data via projector in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dale
 
Posts: n/a

Default Display real-time access data via projector - 01-23-2008 , 11:51 PM






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

Reply With Quote
  #2  
Old   
Fred Zuckerman
 
Posts: n/a

Default Re: Display real-time access data via projector - 01-24-2008 , 12:16 AM






"Dale" <mtech1 (AT) yadtel (DOT) net> wrote

Quote:
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






Reply With Quote
  #3  
Old   
Arno R
 
Posts: n/a

Default Re: Display real-time access data via projector - 01-24-2008 , 02:59 AM




"Dale" <mtech1 (AT) yadtel (DOT) net> schreef in bericht news:980ca2b4-2a06-425d-9bd0-bcc84c4df956 (AT) d4g2000prg (DOT) googlegroups.com...
Quote:
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
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.
Use timerevents in the mainform to switch screens, switch recordsource and such.

Arno R


Reply With Quote
  #4  
Old   
Dale
 
Posts: n/a

Default Re: Display real-time access data via projector - 01-24-2008 , 10:28 PM



On Jan 24, 3:59*am, "Arno R" <arracomn_o_s_p_... (AT) planet (DOT) nl> wrote:
Quote:
"Dale" <mte... (AT) yadtel (DOT) net> schreef in berichtnews:980ca2b4-2a06-425d-9bd0-bcc84c4df956 (AT) d4g2000prg (DOT) 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. *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

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.
Use timerevents in the mainform to switch screens, switch recordsource andsuch.

Arno R- Hide quoted text -

- Show quoted text -
Thanks everyone, this gives me a place to start.

Dale


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.