Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PPT Presentation generated in access is not updated

Status
Not open for further replies.

easycode

Programmer
Jan 28, 2005
195
US
Hello all,

I have developed an app. to generate a presentation with 30 presentations in access, all of the are charts.
If i open a form in access of chart 3 it display the correct result, but if i display the slide 3 in the ppt generated by access i get the chart of last month is not updating the info and i dont know why because what i do is copy and paste in access to power point (automated process)

Here is the code

Any help is appreciated


Do While Not rchart.EOF'open the table with all charts info)
fform = rchart![Chartform]
ftitle = rchart![Charttitle]
fname = rchart![Chartname]
fslidenumber = fslidenumber + 1
Set ppSlide = .Slides.Add(fslidenumber, ppLayoutTitleOnly)
With ppSlide
'From Access
DoCmd.OpenForm fform
Forms(fform).Controls(fname).SetFocus
DoCmd.RunCommand acCmdCopy

'To PP
.Shapes.Paste
End With
rchart.MoveNext
Loop
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top