Problems Automating Access With Powerpoint

Aug 3, 2006

Ive been following the code on the Microsoft support site for automatically creating a PowerPoint presentation using data from Access.

The sample code takes one field from the sample table and displays this on the PowerPoint slide - it then assumes the user can apply this knowledge and add more fields to the slides themselves. I have tried to do this but am getting nowhere.

Please can somebody advise how I add additional fields to the slides via the code. I am afraid Im not very confident with VBA so am stumbling a bit blindly here. Here is a sample of the code that I think I need to add to:

With ppPres
While Not rs.EOF
With .Slides.Add(rs.AbsolutePosition + 1, ppLayoutTitle)
.Shapes(1).TextFrame.TextRange.Text = "Hi! Page " & rs.AbsolutePosition + 1
.SlideShowTransition.EntryEffect = ppEffectFade
With .Shapes(2).TextFrame.TextRange
.Text = CStr(rs.Fields("LastName").Value)
.Characters.Font.Color.RGB = RGB(255, 0, 255)
.Characters.Font.Shadow = True

I tried to replicate the last bit here by adding Shapes(3) and the new field name, but I must be doing something wrong because Access throws up an error message.

If anybody can give me some pointers I would be grateful. Also, if anyone can advise how I can determine the position of the fields on the slide I would be grateful (they seem to be centering at the moment).

The link for the full code is here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/officeaccess2powerpoint.asp

Many thanks,
Adam.

View Replies


ADVERTISEMENT

Access And Powerpoint

Apr 15, 2008

Hello, we have just installed a PC screen in our employee break area and this displays things that are going on in our plant using PowerPoint. Things are working well but we have a slide that needs updated daily and would like it to update automatically. What the slide shows is how many safe work days have gone by since our last accident. I have no clue on how to do this :confused: I know a little about access so if I can use access to run the PowerPoint sides then how would I do it? We also display birthdays and anniversary dates on other slides so I would like to display these things as well but on separate slides. Thanks!

View 6 Replies View Related

Access Pivot Charts In Powerpoint

Apr 1, 2004

I have created a pivot chart using the Autoform and now i want to export this charts to powerpoint, i cannot copy that chart which i have created in in autoform, i can export the pivot table to excel sheet and draw again the chats but i cant copy or export the pivot charts directly, Is there any option for that. can anybody help me in this case?

View 2 Replies View Related

Modules & VBA :: How To Add Pictures Into PowerPoint Using Access

Aug 17, 2013

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.

Dim db As Database, rs As Recordset
Dim ppObj As PowerPoint.Application
Dim ppPres As PowerPoint.Presentation
On Error GoTo err_cmdOLEPowerPoint

[code]....

At the moment I am not worrying about adding the data as I know how to do this and had it working before - its just adding the picture to the slide.

View 2 Replies View Related

Insert PowerPoint Presentation Into Access?

Dec 4, 2012

I have a database that multiple users open and enter data in on a weekly basis.

I have a powerpoint presentation that shows instructions on how to use the database for the users.

I would like to insert the powerpoint users guide into the main form so the user can click on it and read the instructions.

I am working in access 2010...

View 3 Replies View Related

Opening Powerpoint Presentation From Access Form

Mar 12, 2006

Is there an easy way to open a powerpoint presentation from an Access form? Have seen the coding solution on msdn but was hoping there was a simpler way.

Thanks:)

View 1 Replies View Related

Displaying An Access Form In Printed Material Or Powerpoint

Oct 10, 2005

Maybe a strange question but what is the best way to display access forms in a PowerPoint presentation or in printed material. If i do a print screen and then tidy it up the resolution is not great.
Any ideas

View 1 Replies View Related

Modules & VBA :: Close All PowerPoint Files From Access Application

Apr 29, 2015

i want that if any powerpoint application is open after closing my access app all of these powerpoint files will be closed. i found this code for excel file and i changed it for powerpoint application. but i have an error message in this pink line?

error 438: object doesn't support this property or method

Code:

Public Function test()
Dim oApp As Object
Dim workbook1 As Object

[Code].....

View 2 Replies View Related

Modules & VBA :: Using Access 2013 To Create Action Button In PowerPoint?

Nov 22, 2013

I am using VBA in Access 2013 to make a PowerPoint presentation using data from the access database. know if it is possible to use Access VBA to create a button in the presentation that runs a procedure itself?

View 1 Replies View Related

Modules & VBA :: View Powerpoint Presentation Slides In Access Form 2010

Aug 26, 2013

I would like to know if there is any code to view existing Powerpoint presentations in an Access 2010 form . I am creating a library and would like to set this up. I would need step by step info as I am a beginner. I have seen code for 2007 and tried it but it didn't work for me. I'm working with Access & Powerpoint 2010. I've seen VBA, Automation, etc. I do not want to build ppt presentations in access.

View 5 Replies View Related

Modules & VBA :: Open Specific Powerpoint File That Matches A Selection On Access Form

May 27, 2015

We have an access database which has a form that has a list box that details particular records. See attach "list box".

What I would like to do is double click on the record and this would look in a powerpoint folder (see attach "path") and open the presentation if there is a match to the value in Listbox Column 5 i.e. Tool Number.

I can get it to open the presentation if I include the tool number in the path but I cannot seem to be able to get it to compare the values and only open if there is a match.

View 4 Replies View Related

Automating Import Of Excel Into Access

Sep 7, 2005

Hello All
is there a way (i guess using VBA) to import an excel spreadsheet into an access table without having to go through the wizards, if you know all the field names and other variables ??

Yours in anticipation

DJS

View 8 Replies View Related

Automating A Mail- Merge In Access

Apr 18, 2006

I'm using a query that selects all customers from a Customer table who haven't made any payments for a particular week and then sends a letter to them.
I would like to use a command button on a form which the user can press and then view the letters for all the customers- they would only have to specify the week.
Is this possible?
Thanks

View 3 Replies View Related

Modules & VBA :: Automating Mailmerge From Access Form To Word Document

Aug 5, 2013

I am having the strangest results with my automated mailmerge. Basically it does work, but not all the time. The basic idea is to allow the user to dynamically create a query that produces a result list which fills a temporary table. The use then selects a prebuilt merge template and merge is executed against the temp table. The merge template are of the .doc type, but sme have been converted to .docx; the .doc files tend to work most often, but all of the will eventually get a Table is locked message... However if I run in test mode with code breaks and manually step through the process it always works... here is the heart of the code ...

Err_Pos = 10

Code:
DoCmd.SetWarnings False
' if tmp tbl left over from last run kill it
DoCmd.RunSQL "Drop table Word_Merge_Tmp_TBL"
Err_Pos = 12

[Code].....

There are many error cases in the error catch routine. That I have managed to make Access stop hanging when word has a problem or the table is locked. But I can't get the table to be free consistantly and why does it always work when I manually step through the code.

View 4 Replies View Related

Hperlink To Powerpoint

Aug 1, 2005

i am trying to set up a resource database to hold information for my team, links to files are working ok as a hyperlink apart from a link to a powerpoint presentation.

yes it does link by it trys to run the slide show, which i do not wont, my team only need to open the slide show and then they can view the file and if they want it they then can save it.

how do i stop it trying to run the slideshow?

any help would be good

View 4 Replies View Related

Exporting Into PowerPoint

Mar 11, 2007

I am not sure where to post this, so I am trying the general forum. What I have right now is a very simple access database for teachers at our school to use - it has a field for who the announcement is from, who the announcement is for, the announcement, and the date the announcement is for.What I want to do is export each record from Access and put each record on a separate PowerPoint slide, where the title of the slide is who the announcement is from, and the body of the slide contains the announcement. Is there any way to do this easily? I have tried the MSDN thing where you create a form that brings up an instance of PowerPoint, but I would really like to do an export of records from Access then import them into PowerPoint. Any suggestions on how to do that?(here is the link from MSDN http://msdn2.microsoft.com/en-us/library/aa159920(office.11).aspx, this isn't what I want to do - I want a separate ppt file)

View 1 Replies View Related

How To Place A Form Into PowerPoint Using VBA

Sep 3, 2012

I have made a powerpoint presentation from inside Access. I have a form that populates the fields based on user input. I would like to put a copy of this form into a powerpoint slide after the data has updated. Is there a way to do this?? I have tried numerous code variations and can't seem to get anything to work.

I am using Office 2003. My supervisors are comfortable with the display of the form the way it is. So I really need to use a picture of the form and not just the info contained in the form (otherwise i would just fill the slide with the data from the query)...

View 4 Replies View Related

Automating A Query

Oct 27, 2007

After running an UPDATE or DELETE query I get the typical Yes/No screen (ie. Do I want to procede to carry out the changes?). Is there anything than can be added to the query that would automatically answer YES, and eliminate the Yes/No screen from appearing.

View 2 Replies View Related

Automating A Import Function

Jan 23, 2007

I am trying to automate an import function for my database. I recieve a disk that has about 200 little spreadsheets on it every month. I need to either import these or set-up link tables to them in a more automated system than doing it all manually. (It takes a lot of time to do manually) Please can anyone help.
Note: The files are all named 3000 to 3200. The following month they are called the same. I'm hoping this will not cause to much of a problem.
PLEASE HELP

View 5 Replies View Related

Automating Table Deletions

Aug 30, 2006

Hello,
I have a general table question. I have a VB programmed user interface logging information to a MS Access Database Table. I want to automate it so when you open up the table to view what was logged -- any table entry older than 2 weeks is removed from the table. Will this be difficult? Any suggestions on how to start? Are there any access functions that will do something similar to this? Thanks in advance.

Zak

View 2 Replies View Related

Automating A Delete Query

Jan 2, 2008

I currently have the following query written:


DELETE * FROM TABLE1


When runs, it tells me the number of rows to be deleted and I have to click "Yes" for it to run. Is there a way to run the query and not have the prompt so it will run without human input?

View 1 Replies View Related

Automating Criteria In A Query?

Oct 7, 2004

Not sure whether this is possible. I want to use a command button on a form to set the criteria for a particular field in a query. I have created a combo box listing the possiblities I require, but don't know where to go now, I have tried using SETVALUE, but it doesn't seen to like this. Any Clues?

Thanks

View 1 Replies View Related

Automating A Datatype Change

Feb 1, 2006

When I export or do a make table query from Oracle to Access, the new table has some of the datatypes changed. Many of my numberic fields are decimal instead of Long Interger. I then need to go and manually cahnge them back. If I forget or miss one, it crashes another application we use.

Has anyone come up with a solution to automatically go through the table structure and change the datatype from one format to another? This would be a great help.

I am using Oracle 9i and Access 2002.

Thanks for you time

Sherriff

View 1 Replies View Related

Automating Import And Export

Feb 11, 2013

I would like to automate this daily process: In this order import or link, (not sure which is the best option) a fixed width table, add an ascending number to the end of each of the records, reverse the order, and finally export to fixed width .txt documents depending on the quantities in one field. There would be 3 text files exported, max.

View 4 Replies View Related

Automating Periodic Repair And Compact

Jun 6, 2005

Hi All!


I have Access 97 client and server databases linked together. My system is setup so the database is aware of how many users are currently logged in so Ill know when it is being used exclusively. What I want is some code to check every week that a repair and compact has been performed and if not start one on both the client and the server databases (assuming no one else is in them). Do I need code to delete the LDB files beforehand aswell just in case?

I kind of imagine this check will be performed when the first person logs in of a morning.

Client: rentals_prod.mdb
Server: rentals_data.mdb

Regards,

Dalien51

View 3 Replies View Related

Automating Internet Explorer With Office XP.

Jul 29, 2005

Iīm thinking of starting to use office XP for a small system I have. My question is:

Is office XP more compatible with internet explorer in terms of VBA automating? I have had to work around internet explorer quite a lot in office 97, and I havenīt been able to do what I want.

Fuga.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved