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 > >