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.
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.
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!
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
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.
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?
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.
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)...
I'm using access tables to store my data. to retrive data I use jet odbc engine in c++.
I want to insert a large amuont of records (about 20 mega records) to my database in the fasts way i can. if i use sql syntax (insert into table ()....) it's takes for ages (about 500 records per second).
if i'm writing a csv file and then use import (via access) it's much faster but here I have two problems 1.I dont know how to use the access import tool from c++. 2.I dont think I can distributie the access import tool with my product.
so my questions are : 1. Does any know any tool that insert records in an optimize way? 2. How can I use the access import tool in c++? 3. Can i use the jet engine to import csv files?
I keep getting the error Syntax Error in INSERT into statement. I don't know why
This is the sql statement:
Dim intRequest As Integer Dim intRequest2 As Integer Dim strSQL As String Dim intInvoiceNumber As Integer Dim strInvoiceDate As String Dim strName As String Dim intBalanceDue As Double repeats:
If Paid.Value = -1 Then intRequest = MsgBox("Now that you have checked this as been paid, do you wish to finalize this and become irreversable? (If you want further help about this click the Cancel button)", vbInformation + vbYesNoCancel) If vbNo = intRequest Then cancellation: Paid.Value = 0 Call MsgBox("Request cancelled.", vbInformation) Exit Sub ElseIf vbYes = intRequest Then ' Perform action here Invoice_Number.Enabled = True Invoice_Number.SetFocus intInvoiceNumber = Val(Invoice_Number.Text) Invoice_Date.SetFocus Invoice_Number.Enabled = False strInvoiceDate = Invoice_Date.Text Bill_To_Name.SetFocus strName = Bill_To_Name.Text strSQL = "INSERT INTO Paid-Address (Invoice-Number, Invoice-Date, Name, Balance-Due) VALUES ('" & Val(intInvoiceNumber) & "','" & strInvoiceDate & "','" & strName & "','32')" Invoice_Number.Enabled = False MsgBox (strSQL) DoCmd.RunSQL strSQL Else intRequest2 = MsgBox("You have checked this invoice to be paid but if you don't finalize it, it be assumed an error or the cheque has bounced. If you finalize it in the other hand this invoice will be permenantly deleted from this record and entered into the paid summary instead. Do you wish to return back to the request message or do permenant cancellation?", vbInformation + vbYesNo) If intRequest2 = vbYes Then GoTo repeats GoTo cancellation End If End If
I am trying to get a form to insert info into a access database. I am using dreamweaver 2004, i created the form with 4 text fields and a submit button. Ive added a ODBC connection and dreamweaver can qurery my table.
I added an insert record server behaviour, and i figured dreamweaver does all the work for you but when i saved and uploaded the page to my test server it would not submit and redirect to my chosen page, it only refresh the form.
Has anyone out there done this before and can notice a step that im missing.
Do i need to setup a recordset? because ive tried that as well and no success
I have this line in my VBA program: ssql = "INSERT INTO [tblEMPPROCESSING] ( [Procedure] ) SELECT [tblEmpGenProcStatus].[GeneralProcessingStatus] FROM [tblEmpGenProcStatus] where [tblEmpGenProcStatus].[ID]= " & ID & " and [tblEMPPROCESSING].[PositionID] = " & PositionID & "" DoCmd.RunSQL ssql
It always pops up a window for me to type in [tblEMPPROCESSING].[PositionID]. I don't know why? Thank you in advance.
I am creating a student database in Access. I have connected a number of tables through primary keys with RI.
When I create a new record in the student table, I need to insert the student id manually in the grade table.
In SQL Server, I would use an insert trigger to do this automatically. How about in Access?
I need to get this new student id in a number of similar tables: scores, assessments, terms.
I have been populating the student table with data, exporting to access, importing as a new table, adding the id field, creating the relationship, then populating the table with the missing data, which is very labor intensive.
I have a lot more data to enter.
An easier way to do this in Access would be greatly appreciated.
I have been using access for a while and never faced this problem.
When using access 2000, whenever i try to insert a row, access gives me a popup saying "about to append a row, are you sure" which i have to click yes to. For this reason, i can insert rows when in ms access. But when i try to do it through a JSP page that i have set up, an insertion never takes place.
How do i get around this?How do i get rid of the annoying popup?
I have a c# windows form application that inserts rows into an access database. Some values are decimal and access keeps rounding the values to the nearest whole number. How do I stop that behavior?
Keeping getting ole server is not registered when trying to insert jpg into access.
So, far have done the following.
Tried to repair Office install - no success.
Complete uninstall of Office, followed by standard install ( saw this as a possible fix).
Add of complete office components followed by:
Click on start and in the start search bar type CMD, right click on the command prompt icon in the programs area and then click on run as administrator.
At the command prompt type regsvr32 wmnetmgr.dll and then press enter. Successful
Made sure MSCOMCT2.OCX file is copied to c:windowssysWOW64 not c:windowssystem32 Regsvr "C:Program Files (x86)Common FilesMicrosoft SharedTriedit riedit.dll" Successful
Still receiving error when trying to insert jpg.
File on another db shows item as Package and right clicking on Packager Shell Object Object -> Activate Contents opens Windows Photo Viewer and displays photo.
From Excel VBA, how do you insert a ".mdf" database into Access say "Northwind.mdf".I tried:
Code: Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset conn.Open ConnectionString:="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:pathNorthwind.mdf;"
I am at work, and I have acquired a database that prints labels. They now want the database to be coded so that after certain labels are printed the database will print a blank label. I have the code figured out as a Do While statement in order to print the blank label. The problem I am having is that I am trying to use the Insert Into command to insert the filepath into the table that adds the blank label.
|DoCmd.RunSQL "INSERT INTO Rod_tmakLabels ( Print, [Order] ) SELECT Yes AS Expr1, 'Rods Labels' AS Expr2"|
If I run the above command, it just adds the text "Rods Labels" at the end of the table. Is there anyway with the INSERT INTO command that I can insert the new label between the 2nd and 3rd row and add another row? Or is the command designed only to add a new row to the end? I haven't had any luck searching for this yet.