dynamically update

  • Thread starter Thread starter Mike Surrett
  • Start date Start date
M

Mike Surrett

I would like to dynamically update PowerPoint presentations using data
stored in an Access database (or Excel if necessary) based on store name and
presentation.



We have 9 stores, and 6 presentations thus we currently maintain 54
presentations manually changing the data for each store. What I would like
to do is just have the 6 presentations and use a database to fill in the
data, like title (name of the store) sales goals, sales achieved, etc.



What I envision is when you open the presentation a drop down pops up and
you select a store, then it populates the presentation with the data from
that store.



Any Idea's?
 
Hi Mike,
I've read your request again and now I see what you mean. Your requested
functionality of that dropdown box is indeed not possible directly in
powerpoint/datapoint.

I don't understand if you what to run online representations or create new
static presentations. But you could also consider to run this workaround:

A.
make 1 master database and 9 store databases. Each store database has linked
tables to the master database. The queries in the database will do the
filtering for the store. Now you only have to create 1 master presentation.
When it is finished you copy your master presentation 9 times and change the
connected database. Or you do this manually if it is not changed that often.

B.
put that dropdown functionality on an access form. The selected value will
be applied on the queries in the database. Just create a simple join query:
SELECT * from tblSales, tblSelectedStore where tblSales.Storeid =
tblSelectedStore.StoreID. You can also put a "RUN" button on that form to
start powerpoint with your presentation.

Hope this helps.
Kurt.


Mike Surrett said:
Kurt I have seen your post all over the board about your product but it does
not appear that it will do what I need it to do.
Click to expand...
 
Back
Top