Display access data in powerpoint

[ck1999]

I have been working on this project. Search forums on here and also on the internet. And I was working on what I thought was the solution until I figured out I was displaying data that couldn't be updated.

What do I want to do:

My boss is wanting to display active orders on a screen in our production area. This screen will (for the moment atleast) only show active orders.

1. What I am in visioning is querying the table (I think I can handle this part) to get open orders
2. Display each order on a separate slide in power point Using a table format
3. We will have separate columns to show what step in the process the order is.
4. When info in the database is updated (from a number of different people) the slideshow is updated.

I am in the process of creating a power point that I can do steps 1 -3 with using vba code. And possibly 4 if I attach the procedure to a command if the table is updated then requery and rebuild power point slides.

My question is does anyone have a better method? Am I going about this completely wrong?

Thanks

Chris

 

[dhookom]

I would think a web page would be more appropriate than PowerPoint. I've pulled data from SQL server to create charts and tables in PowerPoint but the data was static.

Duane
Hook'D on Access
MS Access MVP

 

[ck1999]

I am currently trying to generate a powerpoint from access vba. And using the timer interval to basically close the powerpoint and start a new one with updated data. This shows about a 3 second glitch between closing show and opening new show. However, if I only refresh every 15 minutes I dont think it will be that big of a deal. If you have a way to prevent this I would appreicate it.

I was hoping there was a way inside of powerpoint to fill a slide with a set of data from access.

But I am still working and fine tuning my method.

Chris

 

[dhookom]

Are you looking for code to pull data from Access into PowerPoint? How far have you progressed?

Duane
Hook'D on Access
MS Access MVP

 

[ck1999]

I have not found how to pull data from access into powerpoint. I am creating an instance of a powerpoint presentation it does not actually save anything into powerpoint. Just displays data in a presentation.. Then i used the interval to create a new instance every 15 minutes (or thats the goal when completed). It is working ok so far in trial stages.


Chris

 

[SkipVought]

So is this intended to be a display on the shop floor or something similar?

It might be easier to do in Excel, where a query could be refreshed periodically via a built-in feature.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[ck1999]

Yes for production floor. I thought about excel but I dont know how many lines I can display at a decent size font to be seen from a distance. It may have up to 30 - 40 lines. So far by putting a slide per customer (there shouldn't be more than 6 items per customer) then I can have multiple slides.

New Problem is I was planning on running this on 1 of the computers in our office and installing an additional video port on computer for the lady who does order entry. But, I am not sure how this will be affected if she tries to use access for something else. I am thinking that it will interfere and I will not be able to run 2 instances of access.

Any help on this new dilemma. Someone has mentioned an all in 1 type computer with a touch screen so they can make updates/changes on the production floor if needed.

 

[SkipVought]

Well making changes on the shop floor: don't you have a corporate scheduling system that has its own feedback? This is just a report that reveals the aspects of what's going on in the system. You might want some controls to grant the option to view report data in various ways.

So a report in Excel of data extracted from Access. You could have a program that 1) refreshed the Access data every M minutes, 2) loops thru the customers in the download, filters for each customer every (M/(Cust count)) minutes, zoom to fit the data.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

BTW there are other interactive report options like QlikView, which they started using on our shop floor about 2 years ago.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]