Has anyone experienced problems when opening shared databases following the installation of Adobe Acrobat?
I have Access 2003 shared db's which are accessed by users via a desktop shortcut. Adobe seems to force the db to attempt to open with exclusive access resulting in an error. I know how to specify exclusive access within the shortcut (/excl) but I'm not sure how I can force shared access.
Has anyone figured out a way around this one?
Thanks, Dave
Hi,
After much frustration and hair pulling I have managed to get the code below to work.. It prints out reports from access one at a time cycling through the list of schools in our county. My question is that I would like to save each report with a filename eg KS1_3000_version1.pdf where 3000 is the unique school ID.
So my question is how can I get the code/acrobat to save my file in a desired location with a pre-specified filename?
this would make the whole process a real click of a button! I know it is possible because we have a national database that does the same thing.. but I cannot crack the backend to see the code
bah!
thanks in advance
john
***********
Option Compare Database
Private Sub Command1_Click()
Dim repQuery As QueryDef
Dim dBase As Database
Dim rsRep As DAO.Recordset
Dim strrep As String
Dim data1 As String
Set dBase = CurrentDb()
Set repQuery = dBase.QueryDefs("john_test_ks1")
Set rsRep = CurrentDb.OpenRecordset("2_KS1_Performance_review_report")
Do While Not rsRep.EOF
data1 = rsRep.Fields("ESTAB_FK").Value
repQuery.sql = "SELECT SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA.DFES, * FROM 2_KS1_Performance_review_report INNER JOIN SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA ON [2_KS1_Performance_review_report].ESTAB_FK = SCHOOL_BASE_DATA_SCHOOL_BASIC_DATA.DFES WHERE ((([2_KS1_Performance_review_report].ESTAB_FK)= " & data1 & "));"
repQuery.Close
DoCmd.OpenReport "john_test_KS1_report"
DoCmd.Close acReport, "john_test_KS1_report"
MsgBox "done"
rsRep.MoveNext
Loop
Set rsRep = Nothing
Exit_Command1_Click:
Exit Sub
Err_Command1_Click:
MsgBox Err.Description
Resume Exit_Command1_Click
End Sub
Hi there
I've got an Access database, that somebody has given to us on CD. In it, there are several scanned documents that have been made into PDFs and stuck in an OLE field.
Unfortunately, I don't seem to be able to get at them. I can see the PDF icon in the OLE object's frame, but double-clicking on them chucks out a "Microsoft Access can't open the file containing the OLE object" error.
I know the files were added correctly, 'cause I've got an older version, and some of the same files appear to open fine. Any new files I add in this version are also openable. It's only the ones that were in there when I copied it off the CD that don't open.
Needless to say, I'm a little worried that I've lost a load of work. Does anyone have any idea as to how I might be able to get at them?
Ta!
Colin
Hello,
I am currently on maternity leave and trying to troubleshoot this from home, so I hope I've got all the details right!
Our form, which shows details of a specific document, contains a hyperlink field into which we insert a link to the PDF file of that document...then we can just click the link to open the PDF. We've never had a problem with this. However, since I left, the office has upgraded to Acrobat 7 and the links no longer work. Apparently when you click on the link it looks like Acrobat just opens and closes immediately. They are using Access 2003.
Anyone have any experience with this, or any suggestions on what to try? I'm not even sure where to start.
Thanks!
Jen
Is there a way to output a single record from a form not report as an Adobe PDF automatically?
View 2 Replies View RelatedHello, i have a question or a case for you and i hope you would help me with it, after seeing your browser sample.
I have a table with 2 fields, ID and title and each title is hyperlinked into a pdf file.
i want to creat another field yes/no "choose"
My boos aked me that he wants to choose the links and then a command button print to print them all the records he chose,
Is that feasable between access and acrobat reader,
Thanks
I have the strangest error.
I have used a OLE Bound Object, so I could create a link to some .PDF files. Everything works great, and I was ready to roll it out to the users (boy will they be excited), when I noticed a silly error I could not get rid of.
After closing the .PDF file (which opened correctly) I get an error that reads:
---------------------------------------------
The operationon on the Acrobat Document object failed.
The OLE server may not be registered
To Register the OLE server, reinstall it.
---------------------------------------------
I have searched the internet, this message board and the Microsoft website, and have come up with little. I believe it might be a .dll error, but the only thing close I could find regarded MS Access 95/98. This is an MS Access 200 DB. I get the error on both a Microsoft 2000 machine AND a Microsoft XP machine.
I tried to use "On Error Resume Next" but to no luck.
If anyone has any ideas, I would appreciate the help/suggestions.
Thank you,
TJ Bernard
Using Access 2000, I have a macro to generate a report by updating various make-table queiries. I would like for the macro to print the report to an Adobe PDF file and save the file as the database name.
When I manually print the report, it gives me the opition of selecting printers and Adobe PDF is listed as a printer. After selecting the "printer", a "Save As PDF" menu pops up and currently it lists the Access Report Name. I would like to use the database name as the name of the PDF file.
In short, when I execute the "Generate Report" macro, I want the end product to be a PDF file using the database name as the PDF file name.
Since converting to Access 2010, when I use the "PDF or XPS" button to create a PDF from a report, after the save dialog it opens the PDF in Adobe reader, and then after I close it there is another dialog with the option to save the export steps. Is there any way to just be able to save the PDF and go back to where I was without having to do the extra clicks to get back?
Back in Access 2000 I had created a custom button on a toolbar that would automatically make a PDF from the open report, but that didn't transfer over when I converted the database to 2010.
Is it possible to attach a WP, Excel, or Adobe file to a form, possibly by using a control key? How?
View 6 Replies View Related