INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Display access data in powerpoint

Display access data in powerpoint

(OP)
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

RE: Display access data in powerpoint

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

RE: Display access data in powerpoint

(OP)
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

RE: Display access data in powerpoint

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

RE: Display access data in powerpoint

(OP)
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

RE: Display access data in powerpoint

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Display access data in powerpoint

(OP)
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.

RE: Display access data in powerpoint

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Display access data in powerpoint

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

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close