Jim Dettman
jimdettman at verizon.net
Thu Aug 9 11:58:17 CDT 2007
Andy, If your saying what I think your saying, then the only problem with that is if you have multiple apps running at the same time, a file can get over written. To get around that, the file name generated on the disk must be unique or you need a semaphore to lock the resource (ie. a printer set to print to disk) until your done with it . This is especially true when you have automated jobs running on a tight cycle. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Thursday, August 09, 2007 10:05 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Changing Default Printer FWIW I overcome this by adding code to rename the file once it exists. Don't need to manipulate the registry that way. Once you've dictated what filename Adobe creates you put code to delete that filename at the start of your routine (if it exists off course) then after the PDF creation you have a timing loop that exits once the file exists and, once it's there, code that renames the file to anything you like. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy > Sent: 08 August 2007 19:44 > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Changing Default Printer > > > Rocky, > > There is no object model that I know of. There is vb code on > the Adobe site and on the web but each file is saved to a > setting in the registry, so if you want to have each file > saved to a unique name and folder location you have to set > that in the registry. I can dig out the code I use if you > want it. Send off line. > > Doug > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Rocky Smolin at Beach Access Software > Sent: Wednesday, August 08, 2007 11:22 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Changing Default Printer > > Do you know if Adobe has an object model that can be > manipulated through code? So that, for example, you could > create a file name or direct the PDF file to a specific folder? > > Rocky > > > > > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Charlotte Foust > Sent: Wednesday, August 08, 2007 11:00 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Changing Default Printer > > The alternatives (we used Amyuni) require coding and then > installation on the target machine. I'm not sure you would > be any better off, especially if you need to get this working > fast. On the other hand, several of the PDF printers you can > license on the web include VBA sample code to get you started. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Rocky Smolin at Beach Access Software > Sent: Wednesday, August 08, 2007 10:54 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Changing Default Printer > > Any good alternatives that you know of? > > Rocky > > > > > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Charlotte Foust > Sent: Wednesday, August 08, 2007 10:41 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Changing Default Printer > > On the other hand, it may cause you more problems. If you > are using generic code to print to PDF, you won't be able to > control page size, orientation, or anything else. Nor will > you be able to create it with a useful name, which may not be > what your user needs. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Rocky Smolin at Beach Access Software > Sent: Wednesday, August 08, 2007 10:35 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Changing Default Printer > > This is a work in progress so I don't have precise answers > yet. But, the plan is to have the user install whatever PDF > printer they like . In the control panel of the Automated > Email System there's a combo box with all of the installed > printers. They pick their PDF printer and it's saved in a > local options table. So they'll be providing their own PDF > printer. Which might finesse the problem you had. > > Rocky > > > > > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Charlotte Foust > Sent: Wednesday, August 08, 2007 10:23 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Changing Default Printer > > Um ... Is this PDF printer something you provide in your app? > We've found that we needed to include an installer for our > clients to reinstall their PDF printer when it went sideways, > and we ran into problems if a full version of Adobe Acrobat > was installed on the same machine. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Rocky Smolin at Beach Access Software > Sent: Wednesday, August 08, 2007 9:09 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Changing Default Printer > > Well, that won't be a problem for my app. Al I want to do it > have the user switch to a PDF printer for reports which will > then be attached to emails. > > > Rocky > > > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Charlotte Foust > Sent: Wednesday, August 08, 2007 8:52 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Changing Default Printer > > OY!! After all this time I don't recall. I know I wrote > printer object based code to replace all our old code to set > page size properly and then after testing it a bit, I threw > it out and went back to the original code. I don't think it > was a problem with selecting the printer, it was trying to > manipulate the page settings that gave us problems. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Rocky Smolin at Beach Access Software > Sent: Wednesday, August 08, 2007 8:45 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Changing Default Printer > > Uh-oh. What problems did you have with the Printer object? > Is that the same as using Application.Printer? > > Rocky > > > > > > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Charlotte Foust > Sent: Wednesday, August 08, 2007 8:08 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Changing Default Printer > > A2002 was the first version to have a printer object. I have > to tell you, though, that we tried it and went back to API > calls as more consistent and reliable. > > Charlotte Foust > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Rocky Smolin at Beach Access Software > Sent: Wednesday, August 08, 2007 7:21 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Changing Default Printer > > What version of Access has that Printer object? And that > code would go into the report in the load or open event? The > code I found that I posted yesterday works in A2K3, it's real > short, but does it at the OS level, which is probably more > sketchy than doing it inside Access itself. What to you think? > > Rocky > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.11.8/941 - Release > Date: 8/7/2007 4:06 PM > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.476 / Virus Database: 269.11.8/941 - Release > Date: 8/7/2007 4:06 PM > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com