Search results

Hi, I am using VBA in Access to create a PowerPoint using the data on the database. I also want to be able to insert existing slides into the new presentation. I have done this which inserts the slides: .Slides.InsertFromFile _ FileName:=(rs.Fields("Extra slides 1")), Index:=0 However...

Thanks. I had to just leave it as .slides.insertfromfile... without the ActivePresentation.

Hi, I am using VBA in Access to create a PowerPoint presentation using the data in the database. I have got this working adding new slides and formatting them but I would also like to add slides from an existing presentation. I have tried the code below but it is not inserting the slides and is...

I know I'm not supposed to but after a week I also posted this question here... http://www.vbaexpress.com/forum/showthread.php?48268-Use-Access-VBA-to-create-an-action-button-in-Powerpoint-! and got an answer straight away. It appears the answer is that what I wanted to do is not possible.

Hi, I am using VBA in Access 2013 to make a PowerPoint presentation using data from the access database. Does anyone know if it is possible to use Access VBA to create a button in the presentation that runs a procedure itself? I'm not sure how to go about it if it is possible so any help would...

Hi, I am creating a PowerPoint presentation from data in an Access database using VBA with MS Office 2013. So far it is working well but there is a change I want to make that will enable me to edit the Custom Slideshows once the presentation has been produced. I figured I could do this by...

Found the answers here... http://www.access-programmers.co.uk/forums/showthread.php?t=255080

Thanks. That link was very helpful. I had to set the "unique values" property of the query to 'no' and the "unique records" to 'yes' to get it working.

Thanks for your reply. I am using Access 2013. For this version Microsoft have got rid of the memo field and replaced it with a long text field. I can input the data into the table fine, its just when its outputted that it is truncated just from one of the two tables.

Hello, I have been using Access 2013 to make a database which outputs values to PowerPoint. I have two tables with data in which are both brought together in a query which is the recordset my VBA code relates to to output it to Powerpoint. Both tables contain data in 'long text' fields. The data...

Hello, I have been using Access 2013 to make a database which outputs values to PowerPoint. Everything has been working fine up to now that I'm trying to add to the presentation. I have two tables with data in which are both brought together in a query which my VBA code relates to to output it...

Thanks for your help. I have managed to get it doing what I want using what you said. It now looks like this which does the job: For intVerse = 16 To 1 Step -1 If IsNull(rs.Fields("Song 1 chosen_Verse " & intVerse).Value) Then Else With...

I am using VBA to make a PowerPoint presentation based on data in an Access query. I am having issues with adding a picture to the presentation. I have the following bit of code which works to add the picture as long as it is right at the beginning of the code (ie. the last powerpoint slide)...

CJ - what you have written is exactly what I have already got - I should have explained it better. The problem is that because the records I need on each slide are located in different fields it won't automatically loop for each one so I have to write the code out with that one line different...

I have the following bit of code repeated lots of times in my code to make powerpoint slides based on each field of a query with only one line changing each time. Any ideas how I can condense it because my code is too big? With .Slides.Add(rs.AbsolutePosition + 1...

I did say the debug thing doesn't seem to be working so doesn't tell me which line failed (unless I'm using that wrong too)! Thanks though - that seems to be working fine now. :)

It says error 94 invalid use of null again - the debug part doesn't seem to always work so i'm not entirely sure which part is not working but all i have added is the if-the-else

I am making a database which has its output in PowerPoint. I have set it up so that each field value is shown on a different slide with the code for each slide like this: With .Slides.Add(rs.AbsolutePosition + 1, ppLayoutLargeObject) .FollowMasterBackground = False...

Hello, I am using access 2013 to make a PowerPoint presentation based on the data in a query. I know how to do that much using VBA but I am also trying to make a slide with a picture on it from a saved location. I have tried various things without any luck. This is my VBA code: Dim db As...

I have a report based on a query. Sometimes some of the fields on the report are blank because the information is not available. Is there a way to not show the blank fields on the report and to move the next field up into the space? I have tried using Is Not Null on the query criteria but if...