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 >