Print a specific record report from a form

bbylls · #16 01-29-2010, 12:59 PM

That prints the screen form and then does a preview of the report.

RuralGuy · #17 01-29-2010, 03:01 PM

Does it let you select the printer before it prints?

bbylls · #18 02-01-2010, 05:56 AM

I get a blank preview and the printer select dialog box, I choose the printer I want to print the report on, but the report prints on the default printer, and the screen form prints on the selected printer.

RuralGuy · #19 02-01-2010, 07:23 AM

Hmmm...maybe this link will work for you. http://allenbrowne.com/AppPrintMgt.html

bbylls · #20 02-01-2010, 08:04 AM

Well, that does not work either.
I tried the OpenTheReport() command and the DoCmd.OpenReport and they both do the same thing.
The report opens in preview, I click on Set Printer, but no printers show up in the Combo/List box.
Then the dialog box won't close when I click the close button.
I have to click the Red X in the upper right corner.

RuralGuy · #21 02-01-2010, 08:25 AM

You are showing as Access 2003. Are you patched to SP3 with the HotFix applied as well? At this point I would eliminate corruption as an issue. Importing to a new db clears most issues. Have you done that? Is your OS up to date? You could also be dealing with some sort of Vista anomaly.

bbylls · #22 02-01-2010, 08:34 AM

I have sp3 and all the hot fixes applied. I have also imported to a new db.
OS is up to date so I guess I am just out of luck.
Thanks for all the help, I really appreciate it.

RuralGuy · #23 02-01-2010, 09:31 AM

Can you try your system on other than a Vista box? It might tell you something.

bbylls · #24 02-01-2010, 09:46 AM

I am going to try it on an XP box and MS7
I will let you know what happens.
Thanks.

RuralGuy · #25 02-01-2010, 11:15 AM

We'll stay tuned, thanks.

bbylls · #26 02-08-2010, 03:08 AM

What I ended up doing was keeping the print button that automatically prints to the default printer.
I then added a preview button. When that opens you then have the Ctrl+P option in the file pull down menu (standard Windows stuff) to redirect printing.
I realized what I wanted was already there, and I didn't have to write any code.
Thanks for all your help. It is well appreciated and I learned a lot.

bbylls · #27 02-08-2010, 03:16 AM

I have tried to mark it Solved, but it was not available under Thread Tools.

RuralGuy · #28 02-08-2010, 03:34 AM

Thanks for sharing your solution and I marked the thread as Solved for you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
print continued at bottom of report	ecpike	Reports	2	02-25-2010 11:50 AM
Print Report from Form ID	Brian62	Forms	1	09-18-2009 11:50 AM
List Box in Form is causing black boxes to print on a report	tigers	Forms	1	07-30-2009 10:54 AM
Print a different image per record	mcaldwell	Reports	5	04-24-2009 12:00 PM
How do I get a line not to print on a report...	tigers	Reports	3	03-24-2006 05:40 AM