[AccessD] Changing Default Printer

William Hindman wdhindman at dejpolsystems.com
Wed Aug 8 16:09:44 CDT 2007


...not once he sees their prices.
William Hindman
----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Wednesday, August 08, 2007 4:33 PM
Subject: Re: [AccessD] Changing Default Printer


> Doug:
>
> I'd appreciate seeing that.  Adobe is standard so the client may 
> standardize
> on it.
>
> Thanks and regards,
>
> Rocky
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
> Sent: Wednesday, August 08, 2007 11:44 AM
> 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
>
> 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
> 






More information about the AccessD mailing list