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
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!
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?
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.
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.
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
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
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?
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.
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.
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 ??
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
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.
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.
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)
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)...
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.
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
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.
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?
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?
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 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.
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.
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.