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 Replies
ADVERTISEMENT
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
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
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
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
Jul 28, 2006
Hi I have a Contact form with all the details of the contacts, I would like to add a photo for each contact, how can I get to this?
Marco
View 1 Replies
View Related
Sep 21, 2006
No? Yes? If, so how?
View 2 Replies
View Related
Nov 13, 2014
I'm trying to place an if statement in an afterupdate event on a form. The code I have is
Code:
If [Customer] Like "BRO001" And [Inv No] is null Then [Job_Price] = [Shots] * 27.5
this gives me a run time error, object required and highlights
Code:
If [Customer] Like "BRO001" And [Inv No] Is Null Then
I'd like the code to do nothing where the requirements to alter the job price are not met.
View 5 Replies
View Related
May 7, 2014
I'm using a calculation on my form that subtracts one number from another and stores the difference between the two in a 3rd field. This works correctly but I want the difference to show 1 decimal place at all times.
So for instance if subtract 35.1 from 35.2 I get a difference of "0.1".
But if I subtract 35.0 from 36.0 I get a difference of "1".
The first case is fine but I need the difference to be "1.0" in the second case.
I've set the number of decimal places in the table from auto to 1 and changed the format on the form to a standard number with 1 decimal place. Neither of these show a difference of 1 as "1.0"
How to force 1 decimal place at all times?
View 3 Replies
View Related
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
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
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
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 1 Replies
View Related
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
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
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
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
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
Dec 7, 2005
Hi,
In a form a have a field wich contains for exemple 'ABCD', is it possible to place focus in this field after the last character (after the D in my exemple).
Thanks in advance.
VINCENT
View 2 Replies
View Related
Jan 27, 2007
i have a statement like this:
rs![tblRecurringDefects] = f("txtTotalRecurring" & i) / f("txtTotalJobs" & i) * 100
how can i have two decimal place?
View 1 Replies
View Related
Oct 29, 2006
Hi again, This might be a simple answer, but I have tried several event properties, the last in the OnCurrent of the main Form. But most of the calcs work most of the time, and occassionally I get an 'Error 2001'. I have a couple of years VBAing, so still a teenager?? I am curious as to wether I am placing the calcs in the right event. I really only want them to do the calcs when the leave tab is selected (see enclosed image) and/or if a new employee record is navigated to. I will also attach code of calcs. If it needs to go into the Tab control what is the best event?
NB pink fields on form are visible=No and for troubleshooting
Coding:
' Run Calcs here for Leave other than Sick Leave.
If IsNull(EmpStartDate) Then
DaysWorked = 0
Else
DaysWorked = DateDiff("d", EmpStartDate, Now)
End If
' Calc number of days between Employee Start Date and Now
TotalLeaveAlloc = DaysWorked * (Me!AnnualLeaveDue / 365)
' Divide Allocated days by 365 and multiply by number of days worked
If IsNull(DSum("[DaysTaken]", "[qryLeaveRecords]", "[LeaveType]<>'Sick' And [tblEmployees]![EmployeeID] = [tblLeaveRecord]![EmployeeID]")) Then
TotLeaveRecorded = 0
Else
TotLeaveRecorded = DSum("[DaysTaken]", "[qryLeaveRecords]", "[LeaveType]<>'Sick' And [tblEmployees]![EmployeeID] = [tblLeaveRecord]![EmployeeID]")
End If
' Calculates the number of leave days taken from leave records in database based on qryLeaveRecords
' Used IsNull to check if there are no records found - set calc result to zero
Me.Taken01 = TotLeaveRecorded 'visible option = no
' Display this on screen
If IsNull(Me.LeaveAccrued) Then
LeaveBalance = TotalLeaveAlloc - TotLeaveRecorded
Else
LeaveBalance = TotalLeaveAlloc - (TotLeaveRecorded + Me.LeaveAccrued)
End If
' Check if there is any Accrued Leave [reduces the need to load historical Leave Records] and subtract them
Me.Bal01 = LeaveBalance
' Display Balance
' Run Calcs for Sick Leave here.
If IsNull(DSum("[DaysTaken]", "[qrySickLeaveRecs]", "[tblEmployees]![EmployeeID] = [tblLeaveRecord]![EmployeeID]")) Then
TotSLeaveRecorded = 0
Else
TotSLeaveRecorded = DSum("[DaysTaken]", "[qrySickLeaveRecs]", "[tblEmployees]![EmployeeID] = [tblLeaveRecord]![EmployeeID]")
End If
' Calculates the number of leave days taken from leave records in database based on qrySickLeaveRecs
' Used IsNull to check if there are no records found - set calc result to zero
Me.Taken02 = TotSLeaveRecorded 'visible option = no
' Display this on screen
Me.Bal02 = Me.SickLeaveDue - TotSLeaveRecorded
' Display Sick Leave Balance
thanks in advance ...
View 8 Replies
View Related
Aug 11, 2007
Hey all
I'm looking to get Access 2007. Anyone know the cheapest place to get it? I'm in UK but if importing is cheaper I'd be interested.
Thanks for your help
View 7 Replies
View Related
Jun 14, 2006
Hey everyone,
I'm playing with my DB a bit and I need help in determing which way to go. When I print out labels for Envelopes or directly on envelopes, sometimes I have people living on the same address (a family), so I would like to save some on printing and actually sending several envelopes to the same address.
Now, I was thinking of doing this through the code in VBA but now I'm thinking if there is maybe more simple and faster way in building a qry.
All the data for the labels and envelops comes to a temp table from where I'm printing out reports...so what I'm not sure, is there a way to make a querry which would go through my temp table sorted by address, pick address1 then address2, if they are the same, check if lastname1 and lastname2 ise the same and then name1=name1 & Name2, delete record2 and go on...
tnx a lot
View 2 Replies
View Related
Mar 4, 2008
My sql code reads as follows:
Total ATR: Round([Total Resolved] / ([Total Resolved] + [Total Escalated]) * 100) & "%"
This will round to a whole.
When I try to set it to round to the tenth it fails.
I tried using
Total ATR: Round((([Total Resolved] / ([Total Resolved] + [Total Escalated]) * 100) & "%"),2)
Any ideas?
View 3 Replies
View Related
Jan 17, 2006
Is there an easy way of doing this? I have a database that I want to automatically place racers as they finish. I have four race divisions. All racers no matter the division start at the same time. I have all of this figured out, but what is getting me is the finish place (1st, 2nd, etc.) Is there a way on a continuos form to automatically place the racers? How this works is...Main form has racer info., on this form is a stop button, and after the button is clicked, it will show his/her finishing place in their division which is subform of the main form. Here is the reason I want this. Someone may have registered wrong and they are in the wrong division, and we have to change them to the correct division after they have finished and already been placed. I want to be able to move them to the right division, and then my subform requery and they placed in the correct position in the new division. Sorry this is so lenghty. Plain and simple can I make a subreport have an unbound field that shows each records place the recordset? Thanks for your help, and like I said sorry this is so long.
View 4 Replies
View Related
Sep 27, 2004
I am building a database from a detailed Excel file which has upwards of 22 decimal places. Access restricts the decimal usage to 15 characters. Even when selecting the 15 characters, Access rounds the entry. The only way it will work so far is as text, but it is a calculated field. Any suggestions?
View 3 Replies
View Related
