Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-14-2019, 07:07 AM   #1
MichealDon
Newly Registered User
 
Join Date: Nov 2017
Posts: 22
Thanks: 33
Thanked 0 Times in 0 Posts
MichealDon is on a distinguished road
How to make output of report to Powerpoint

Hi All,
I have a database, and a report on event of button click.
I can also export the report to output with .PDF format or .XPS format.
Now I want to export the report with output .PPTX (powerpont)
I visit the link below several time, also download the Demo file for learning. But it seem to be a little bit different to my database.
https://www.access-programmers.co.uk...d.php?t=291319
In the Demo, with some controls OLE_Graphic to be defined on it, the code VBA will copy these OLE_Graphic control to Powerpoint Application then exporting output for PPTX format.
For try to testting, I copied some code from it to my database but the error measage informed " Compile error : User-defined type not defined " at the row
" Dim PowerPoint As PowerPoint.Application "

I do not know whether I can copy the output pdf, or XPS format to paste to Powerpont slide with how to code it.

Thanks very much for helping me to build the report output with the PP format and help access beginner like me to learn more .
Thank again.
MichealDon

MichealDon is offline   Reply With Quote
Old 01-14-2019, 07:23 AM   #2
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,491
Thanks: 381
Thanked 595 Times in 577 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: How to make output of report to Powerpoint

You are probably missing the Powerpoint library.

Go into the VBA editor (Alt + F11) and select Tools/Referencesand scroll down to 'Microsoft Powerpoint xx Object library' where xx is your version of Office and select the checkbox.

Then try again, or Compile using Debug/Compile from the ribbon bar.

HTH
__________________
Access novice. Sometimes trying to give something back.
Access 2007


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
MichealDon (01-14-2019)
Old 01-14-2019, 05:06 PM   #3
MichealDon
Newly Registered User
 
Join Date: Nov 2017
Posts: 22
Thanks: 33
Thanked 0 Times in 0 Posts
MichealDon is on a distinguished road
Re: How to make output of report to Powerpoint

Quote:
Originally Posted by Gasman View Post
You are probably missing the Powerpoint library.

Go into the VBA editor (Alt + F11) and select Tools/Referencesand scroll down to 'Microsoft Powerpoint xx Object library' where xx is your version of Office and select the checkbox.

Then try again, or Compile using Debug/Compile from the ribbon bar.

HTH
Thank you very much,
I have come to the site to select the Microsoft Powerpoint library.
The error is solved.
But I do not know how to copy the output report with pdf (or XPS) format to code it as picture to paste in the Powerpoint
Thank more for help and support from all of you.
Best Regards,
MichealDon

MichealDon is offline   Reply With Quote
Old 01-14-2019, 11:20 PM   #4
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,628
Thanks: 2
Thanked 2,049 Times in 2,004 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: How to make output of report to Powerpoint

Quote:
Originally Posted by MichealDon View Post
..
But I do not know how to copy the output report with pdf (or XPS) format to code it as picture to paste in the Powerpoint
Why do you want the report in pdf (or XPS) format when you paste it in a Powerpoint file?
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
MichealDon (01-15-2019)
Old 01-15-2019, 02:29 AM   #5
MichealDon
Newly Registered User
 
Join Date: Nov 2017
Posts: 22
Thanks: 33
Thanked 0 Times in 0 Posts
MichealDon is on a distinguished road
Re: How to make output of report to Powerpoint

Quote:
Originally Posted by JHB View Post
Why do you want the report in pdf (or XPS) format when you paste it in a Powerpoint file?
Dear JHB,
First of all thank you stop by my topic and your support.
Relate to your question. I want to explaint my database.
The database with some text fields, picture fields (Pics Path), and the report with these picures to be inserted on it.
The report to be printed (exported) to .pdf format file or .XPS file for mail sending everyday. Beside, the quality of pictures attached in the report is good when exporting. This is the reason I have printed it with these format.
I also looking for the new way to export the report to .JPG format or the orther Picture format such as .PNG. But , Access application seem to be not support for picture formats.
Now, for the purpose of presentation the report daily. So I want to export the report to picture or Powerpoint (with fair quality picture).
I do not know how to do the idea by my knowledge, I hope that the Access Community will help me to solve the trouble.
Thank you for your support.
Best regards,
MichealDon
MichealDon is offline   Reply With Quote
Old 01-15-2019, 03:28 AM   #6
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,491
Thanks: 381
Thanked 595 Times in 577 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: How to make output of report to Powerpoint

You can insert a pdf into Powerpoint, but I do not know whether it will refresh if you overwrite with a new copy.?
__________________
Access novice. Sometimes trying to give something back.
Access 2007


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
MichealDon (01-15-2019)
Old 01-15-2019, 03:53 AM   #7
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,628
Thanks: 2
Thanked 2,049 Times in 2,004 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: How to make output of report to Powerpoint

Nothing that you mention here is undoable, (except exports to JPG / PNG format which I have not yet tried it can be done).
But I've some more questions.
Quote:
Originally Posted by MichealDon View Post
..
The database with some text fields, picture fields (Pics Path), and the report with these picures to be inserted on it.
What is these pictures about, is it a graph or what?
Why do you store them?

Could you post your database with some sample data (and the name of the report/form) + a picture or something visually, how you want the result?

__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
MichealDon (01-15-2019)
Old 01-15-2019, 04:38 AM   #8
MichealDon
Newly Registered User
 
Join Date: Nov 2017
Posts: 22
Thanks: 33
Thanked 0 Times in 0 Posts
MichealDon is on a distinguished road
Re: How to make output of report to Powerpoint

Quote:
Originally Posted by Gasman View Post
You can insert a pdf into Powerpoint, but I do not know whether it will refresh if you overwrite with a new copy.?
Dear Gasman,
Thank you very much,
Would you like to give me the solution with Code VBA for declare variant and code insert the .pdf ?
If you can, i will try to do it.

Quote:
Originally Posted by JHB View Post
Nothing that you mention here is undoable, (except exports to JPG / PNG format which I have not yet tried it can be done).
But I've some more questions.

What is these pictures about, is it a graph or what?
Why do you store them?

Could you post your database with some sample data (and the name of the report/form) + a picture or something visually, how you want the result?
Dear JHB,
In my database, some fields contain paths of picture in Folder Picture (Pics. JPG, or PNG), with the code to load pictures from the Pics Folder to Forms and Report.
I will upload my database on tomorror when I will be at my office.
Thank you very much,
MichealDon

Last edited by MichealDon; 01-15-2019 at 08:12 AM.
MichealDon is offline   Reply With Quote
Old 01-16-2019, 12:59 AM   #9
MichealDon
Newly Registered User
 
Join Date: Nov 2017
Posts: 22
Thanks: 33
Thanked 0 Times in 0 Posts
MichealDon is on a distinguished road
Re: How to make output of report to Powerpoint

Dear JHB,
I am looking for the way to attach my database in here, but I could not find how to do. Visit some other topics, I can see some file attached from other member. The function for uploading file in the forum is available.
Maybe I am a new member, so the function is limit to me.
I upload my Database in the link.
For Data running, some code in Modules, or code for button "Report Fault Complain" must be edited for the path of Folder Pictures correctly.

https://drive.google.com/drive/folde...k5vd6?ogsrc=32

Thanks
MichealDon

Last edited by MichealDon; 01-16-2019 at 06:58 PM.
MichealDon is offline   Reply With Quote
Old 01-16-2019, 08:49 PM   #10
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,628
Thanks: 2
Thanked 2,049 Times in 2,004 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: How to make output of report to Powerpoint

The only requirements to upload is that a database file is under 2MB, and that you've to posted 10 post, else the file must be zipped.

For uploading database here:
Scroll down a little until you see the button "Manage Attachment", (click the button and follow the instruction).
If you file is to big, click "Compact & Repair" in MS-Access, then zip it.

Sorry I can't look at your database before tomorrow, because I'm away from home today.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
MichealDon (01-16-2019)
Old 01-16-2019, 09:42 PM   #11
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,628
Thanks: 2
Thanked 2,049 Times in 2,004 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: How to make output of report to Powerpoint

Could you please upload your database here, because it seems I can't get access to it follow your link.
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
MichealDon (01-16-2019)
Old 01-16-2019, 11:47 PM   #12
MichealDon
Newly Registered User
 
Join Date: Nov 2017
Posts: 22
Thanks: 33
Thanked 0 Times in 0 Posts
MichealDon is on a distinguished road
Re: How to make output of report to Powerpoint

Quote:
Originally Posted by JHB View Post
Could you please upload your database here, because it seems I can't get access to it follow your link.
Dear JHB,
Thank you very much.
I have just uploaded my database from file TEST.ZIP7
My computer had been only installed some Copyright Software, so I only compressed my database by .Zip7.
I do not know the Zip can be suitable to upload on the Forum.
If not, after working , I will upload the database with Zip on my computer at my home

Note : The File Zip7 could not be uploaded on here.
I will upload the new one later

Thank you again
MiChealDon
MichealDon is offline   Reply With Quote
Old 01-16-2019, 11:57 PM   #13
MichealDon
Newly Registered User
 
Join Date: Nov 2017
Posts: 22
Thanks: 33
Thanked 0 Times in 0 Posts
MichealDon is on a distinguished road
Re: How to make output of report to Powerpoint

Quote:
Originally Posted by MichealDon View Post
MiChealDon
Dear JHB,
This is the Zip attached,
For making the report by button "Report... ", you should modifiy some code in modules and VBA button command for the path of Folder Picture.
Thank again
Best Regards,
MichealDon
Attached Files
File Type: zip TEST.zip (1.62 MB, 16 views)
MichealDon is offline   Reply With Quote
Old 01-18-2019, 03:43 AM   #14
JHB
Have been here a while
 
Join Date: Jun 2012
Location: In the south of Denmark (Jutland), near the German border.
Posts: 7,628
Thanks: 2
Thanked 2,049 Times in 2,004 Posts
JHB has a spectacular aura about JHB has a spectacular aura about
Re: How to make output of report to Powerpoint

Now I've made it so that the pdf file is loaded into a Powerpoint file.
Remember to change the path of Folder Picture both in the code and in the table "Tbl_CGFaultControl".
Also remember to add the reference to Powerpoint Object Library if you add the code into another database.
The pdf file need to be closed before it can be inserted in the Powerpoint file.
Database file attached.
Attached Files
File Type: zip FAULTS COMPLAINT.zip (762.4 KB, 20 views)
__________________
If the above post has helped you, why not take the time to say thank you, by pressing the "Thumbs up."
JHB is offline   Reply With Quote
The Following User Says Thank You to JHB For This Useful Post:
MichealDon (01-18-2019)
Old 01-18-2019, 04:24 AM   #15
Gasman
Enthusiastic Amateur
 
Join Date: Sep 2011
Location: Swansea, South Wales,UK
Posts: 3,491
Thanks: 381
Thanked 595 Times in 577 Posts
Gasman has a spectacular aura about Gasman has a spectacular aura about Gasman has a spectacular aura about
Re: How to make output of report to Powerpoint

Quote:
Originally Posted by MichealDon View Post
Dear Gasman,
Thank you very much,
Would you like to give me the solution with Code VBA for declare variant and code insert the .pdf ?
If you can, i will try to do it.

MichealDon
My idea was just to output the report to pdf and have that file referenced in the PP presentation. As I mentioned, not sure if it will refresh, so have tried a quick test and it does not, so scrap that idea. Sorry.

__________________
Access novice. Sometimes trying to give something back.
Access 2007


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Gasman is offline   Reply With Quote
The Following User Says Thank You to Gasman For This Useful Post:
MichealDon (01-18-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Export report to powerpoint Em80 Reports 0 03-01-2015 07:23 AM
Make output value a percentage ScotWilder SQL Server 3 02-15-2013 06:31 AM
VBA to output query results to Powerpoint Tango Modules & VBA 4 05-01-2012 08:50 AM
Export Report to MS Word or MS Powerpoint FreddieLeaf Reports 0 04-30-2006 07:29 PM
[SOLVED] Report to Powerpoint with Format diannedhere Reports 0 03-05-2003 06:45 AM




All times are GMT -8. The time now is 08:01 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World