[AccessD] Changing Default Printer

Andy Lacey andy at minstersystems.co.uk
Fri Aug 10 01:38:12 CDT 2007


Jim
I can see you'd have such problems in that environment. Happily I don't so
haven't been faced with them.

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
> Sent: 09 August 2007 17:58
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Changing Default Printer
> 
> 
> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 





More information about the AccessD mailing list