Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #14167

Re: merging pdf files

Show all headers | View raw

On Monday, August 3, 2020 at 2:50:02 AM UTC-5, internet...@foobox.com wrote:
> Albert, you say:
> "So, I only merged 2 files, but you can have 2 or 10 files."
> I assume that this is only illustrative and that there is no limit to the number of files. 
> 
> Am I correct?
> Jim 
> 
> On Sunday, 2 August 2020 05:40:57 UTC+1, Albert Kallal (Access MVP) wrote:
> > On Friday, July 31, 2020 at 7:33:58 AM UTC-6, internet...@foobox.com wrote: 
> > 
> > > For many years I have used Stephen Lebans ReportToPdf that has worked well until now. 
> > 
> > Yes, a lot of us used that utility. and before Access/Office 2007, we also used his PDF creator. 
> > 
> > Thankfully, now (even with runtime) we can create PDF's from Access - even the runtime, and NOT require any PDF drivers or even software to be installed - nice! 
> > 
> > > 
> > > I am needing to transfer the system to 64 bit Windows and the library StrStorage.dll fails to load. 
> > 
> > All recent versions of windows (for quite a long time name) have be OS x64 bits. 
> > 
> > However, until rather recent, office installs remained x32 bits. 
> > 
> > > I am not that familiar with the workings of libraries but I am assuming that MergePDFDocuments in a function within the StrStorage.dll 
> > 
> > It was in one of the two .dll's, can't remember. However that .dll is a x32 bit windows .dll. 
> > 
> > > I have downloaded what I think is a newer version of StrStorage.dll but it fails to load. 
> > > hLibStrStorage = LoadLibrary(CurrentDBDir() & "StrStorage.dll") 
> > > The file exists and is in the correct place 
> > > 
> > > I am assuming that it is for 32 bit systems. 
> > 
> > You are correct. It is a win x32 bit file. Since you now using VBA and office x64 bits? 
> > Then of course you can't use those .dll's anymore. 
> > And the wonderful Stephan's? He not been around the access scene for a good 13 or more years. 
> > 
> > 
> > > Has anyone any knowledge of this? 
> > 
> > Yes, I very much know this stuff! 
> > 
> > > 
> > > Is there another way of merging pdf documents without buying the full version of Acrobat? 
> > 
> > Yes, I created a .net .dll that can work with x32 or x64 bits. 
> > I also use the "load library" approach that Stephan used for his PDF stuff. 
> > 
> > I just simply don't have the time to correctly put up a web page. 
> > 
> > But I have a loader, one for x64 bits, and one for x32. 
> > This loader can load any .net .dll. For .net, x32 or x64 bits does NOT matter (if the code was compiled using ANY CPU). 
> > However the loader must match. 
> > 
> > To use: 
> > You have to place the .dll nloader and the Pmerge.dll in your front end folder (same as PDF merge). 
> > Now since the two loader.dll's are VERY small, then you might as well make a habit of placng both in the folder. 
> > 
> > So, we have a total of 3 files: 
> > nloader.dll - x32 bit loader 
> > nloader64.dll - x64 bit loader 
> > Pmerge.dll - new .net PDF merge 
> > 
> > So, place the above 3 files in the folder. 
> > 
> > The VBA code to merge is now this: 
> > 
> > Dim MyPdf As Object 
> > Set MyPdf = CreateObjectNET("Pmerge.dll", "Pmerge.Pmerge") 
> > 
> > 
> > MyPdf.Add "c:\test4\p1.pdf" 
> > MyPdf.Add "c:\test4\p2.pdf" 
> > 
> > MyPdf.OutPutDoc = "c:\test4\P1ANDP2.pdf" 
> > 
> > MyPdf.Merge 
> > 
> > So, I only merged 2 files, but you can have 2 or 10 files. 
> > There is also a 
> > MyPdf.Clear 
> > That just clears out the files if you want to merge again (and if you JUST created the MyPDF object, then no need for clear. 
> > 
> > So, only 3 tiny .dll's. 
> > And it AUTOMATIC works for x32 or x64 - you don't have to do anything or change the code. It will work for both x32 and x64. 
> > 
> > the example assumes Access 2010 or later (I have the VBA test for x64 bits - so, if for SOME strange reason someone wants to use this in a pre-access 2010? It WILL work fine, but you have to remote the #Win64 test/check I have, since only 2010 and later has this built in test/check in VBA for x32/x64. 
> > 
> > You can download from my skydrive - it is a sample accDB and the above 3 .dll's. 
> > 
> > To use in YOUR application? You just need to import the ONE code module. 
> > (NetLoader). 
> > 
> > So, this example: 
> > Super easy, super simple to use. 
> > No registration, no installer. 
> > It just works. 
> > 
> > Here is a skydrive link to the zip file - do try it - perhaps post back. As I stated I don't have time to write up a web page. So, you have to just take your time, and look at the sample code. However, the sample code above is all you really need. 
> > Please do give it a try, and at least throw the community a dog bone here that this worked for you. 
> > 
> > Link: 
> > https://1drv.ms/u/s!Avrwal_LV4qxhphvq4_Ce9EmZFMbEA?e=Je7dmU 
> > 
> > Now, the above is actually based on PDFSharp - it has MANY cool features: 
> > Modify, merge, and split existing PDF files. However, I have only exposed the merge feature, but there are quite a fw more features that I could "just" expose. 
> > 
> > Good luck! - post back if this works for you. 
> > Albert D. Kallal (Access MVP 2003-2017) 
> > Edmonton, Alberta Canada 
> > pleaseNoS...@msn.com

First, Allen thanks for the dll info.

I am having trouble with your sample database. I get a err.lastDllError 203 after executing hLibDynaPDF = LoadLibrary(CurrentProject.Path & "\" & strDll). It's returning a non-zero value. because of this MyCreateObject(CurrentProject.Path & "\" & strDll, strClass) returns nothing.

dll error 203, The system could not find the environment option that was entered.

Do I need to register any of the COM objects?

Access 2016 32bit on Windows 8.1 64bit
references are
Visual Basic For Applications
Microsoft Access 16.0 Object Library
Microsoft Office 16.0 Access database engine Object Library
OLE Automation

I also tried it on Access 2010 32bit on Windows 7 64bit

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

merging pdf files internet.shopping@foobox.com - 2020-07-31 06:33 -0700
  Re: merging pdf files samxjones2@gmail.com - 2020-07-31 07:02 -0700
    Re: merging pdf files internet.shopping@foobox.com - 2020-07-31 08:51 -0700
  Re: merging pdf files "Albert Kallal (Access MVP)" <kallal@msn.com> - 2020-08-01 21:40 -0700
    Re: merging pdf files internet.shopping@foobox.com - 2020-08-02 07:49 -0700
      Re: merging pdf files "Albert Kallal (Access MVP)" <kallal@msn.com> - 2020-08-02 09:34 -0700
        Re: merging pdf files "Albert Kallal (Access MVP)" <kallal@msn.com> - 2020-08-02 13:37 -0700
    Re: merging pdf files internet.shopping@foobox.com - 2020-08-03 00:49 -0700
      Re: merging pdf files Ron Paii <ron81pai@gmail.com> - 2020-08-03 06:55 -0700
        Re: merging pdf files Ron Paii <ron81pai@gmail.com> - 2020-08-03 08:02 -0700
          Re: merging pdf files "Albert Kallal (Access MVP)" <kallal@msn.com> - 2020-08-03 09:28 -0700
            Re: merging pdf files Ron Paii <ron81pai@gmail.com> - 2020-08-03 12:18 -0700
              Re: merging pdf files "Albert Kallal (Access MVP)" <kallal@msn.com> - 2020-08-03 12:59 -0700
                Re: merging pdf files Ron Paii <ron81pai@gmail.com> - 2020-08-04 05:28 -0700
                Re: merging pdf files internet.shopping@foobox.com - 2020-08-04 08:48 -0700
                Re: merging pdf files "Albert Kallal (Access MVP)" <kallal@msn.com> - 2020-08-05 10:18 -0700
                Re: merging pdf files lucteunis1@gmail.com - 2021-02-10 12:01 -0800
                Re: merging pdf files "Albert Kallal (Access MVP)" <kallal@msn.com> - 2021-02-11 15:04 -0800
                Re: merging pdf files Keith Tizzard <internet.shopping@foobox.com> - 2021-06-24 08:44 -0700
    Re: merging pdf files musicloverlch <lhowey@gmail.com> - 2021-08-24 09:37 -0700
      Re: merging pdf files Keith Tizzard <internet.shopping@foobox.com> - 2021-08-24 10:42 -0700
        Re: merging pdf files musicloverlch <lhowey@gmail.com> - 2021-08-25 09:23 -0700
          Re: merging pdf files Keith Tizzard <internet.shopping@foobox.com> - 2021-08-25 09:39 -0700
            Re: merging pdf files musicloverlch <lhowey@gmail.com> - 2021-09-10 07:20 -0700
              Re: merging pdf files "Albert Kallal (Access MVP)" <kallal@msn.com> - 2021-11-11 11:09 -0800
                Re: merging pdf files Extreme Estabrooks <jestabrook@winningsolutionsinc.com> - 2021-12-29 08:03 -0800
                Re: merging pdf files Extreme Estabrooks <jestabrook@winningsolutionsinc.com> - 2021-12-29 08:04 -0800
                Re: merging pdf files ANKIT ROY <ankit.aryson@gmail.com> - 2022-03-02 22:47 -0800

csiph-web