Automatic update powerpoint document based on query

Resolved · Medium Priority · Version 2003

Mon 28 Jul 2008, 16:39 Delegate Riccardo said...

Riccardo has attended:
Access Introduction course

Automatic update powerpoint document based on query

Is it possible to automatically update a set of powerpoint slides based on the results of a query (in the same way as a ppt document may be linked to an excel file)? thanks Riccardo

Tue 5 Aug 2008, 14:12 Trainer Amanda said...

RE: automatic update powerpoint document based on query

Hello Riccardo

Thank you for your question; and welcome to the forum.

The straightforward answer to this is no, unless you are pretty good at programming.

Perhaps it would be possible to get the query results exported into Excel; and then have the query results from Excel display in PowerPoint.

Amanda

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Automatic update powerpoint document based on query

Automatic update powerpoint document based on query

RE: automatic update powerpoint document based on query

Access articles

Access tip:

Splittng a database