Change the printer in MSaccess

by MYLE 16. July 2010 00:01

Every wanted to be able let the User Change the printer in MSaccess

Dim prt As Printer
For Each prt In Application.Printers
    Me!Myprinter.AddItem Item:=prt.DeviceName
Next prt

where Me!Myprinter is a combo box on the form Now Printing that report

Dim prt
Set prt = Application.Printers(Me!Myprinter)
Set Application.Printer = prt
stDocName = "That Report"
DoCmd.OpenReport stDocName, acNormal   
Set Application.Printer = Nothing

Comments

11/9/2010 1:30:02 AM #

Sabina Caride

I will pass on the link of this site to other people that I am familiar with with the same things going on.

Sabina Caride United States |

12/14/2010 10:23:58 AM #

Frank

You own a very interestingexcellent blog. There is only one question remaining for me In which way do you deal with the increasing number of Spam in blog comments? I really hate it, It wastes lots of my time and I really hate dealing with it every day.

Frank United States |

12/14/2010 8:29:58 PM #

Dominick Berdin

Ariel Plumbing Fixtures for Home Remodel? I am doing a remodel that includes a half bath that get used quite a bit. I need to purchase a fresh toilet and I am looking at a couple by a brand named Ariel (the platinum toilet and the Hermes).

Dominick Berdin United States |

12/14/2010 8:50:15 PM #

Adelina Winterholler

Bedroom color? I have no idea what color to paint my room! one of my friends suggested one adjectives red wall and the other three gray or white,and on the red accent wall a dead black tree. I guess approaching a silhouete(sp?) I need help swiftly. I like modern type things, retro, just some.

Adelina Winterholler United States |

12/14/2010 9:46:00 PM #

Stuart Packer

Bedroom color philosophy please back? I just turned 17 and I want to change my room completely, from the very soon pink ceiling and blue walls with multicolored everything to a new hip, seasoned place for a teen to be, but also grown up like. and I dont have any wall color planning.

Stuart Packer United States |

12/15/2010 7:31:43 AM #

UK GHD

Nickelodeon  is my no. 1, it  is really coming to existence beautifully on display screen too.Thanks Armin and co. for years value of entertaining reading.

UK GHD United States |

12/15/2010 11:25:12 PM #

pacific war photos

What about that old pacific war site, it has heaps of cool stuff

pacific war photos United States |

12/20/2010 5:56:49 PM #

nautical wall decor metal

What's up with your feedback here? In most cases I spot lots of clever opinions here, yet this all seems like garbage if you ask me.  Come on guys, why don't we turn it around.

nautical wall decor metal United States |

12/21/2010 7:31:43 PM #

comfortable heels

Do you individuals have a fb fan page? I appeared for one on twitter however couldn't uncover one, I would like to grow to be a fan!

comfortable heels United States |

1/6/2011 2:49:21 PM #

Levi Roome

I think online colleges are the way that people will go back to college in the future. They just hold so much potential for learning, I wouldn't be surprised if all education was online in a few decades.

Levi Roome United States |

1/9/2011 12:06:04 AM #

la gazzetta dello sport

.. What about social bookmarking and the others?

la gazzetta dello sport United States |

1/12/2011 8:29:56 AM #

Greg Prociuk

First, Thanks for this blog; I have been hanging out for months and have got untold tips and ideas from you. Love it!

Greg Prociuk United States |

1/12/2011 10:10:51 PM #

Rogelio Costantino

Great, I will stick your RSS feed to my browser, thanks for sharing, do you have pingback enabled in your blog or not? I would like to send you a request.

Rogelio Costantino United States |

1/12/2011 11:28:08 PM #

free6

"Please, do you want me to get caught or something? I'll make it up to you later, really." Then I ran up into the house, just as I could hear her spit something at me in rapid Spanish.

free6 United States |

1/13/2011 12:06:28 AM #

free6

"A strategically placed peephole in our adjoining bedroom wall. That way neither one of us will know when someone else is watching or not. It will heighten the sex act with our men every time." She was smiling radiantly at me now.

free6 United States |

1/13/2011 7:34:40 AM #

teens

As my arousal increases, my dream change to include a man... Im lying on my back as he lowers his cock to slide into my mouth while she moves to lick at my sweetness. My fingers will dip into my own wetness and as I long to taste the sweet cum of him, I will taste my own fingers.

teens United States |

1/13/2011 8:58:32 AM #

teens

"Oh. I'd better get back to work," she said with a start. She quickly stood up, smoothed out her dress and hair, gave me a peck on the mouth, and vanished from the dressing room.

teens United States |

1/13/2011 11:55:34 AM #

teens

I am an unusual Thai girl. Or maybe I should say my family is unusual, because I have a twin sister. Her name is Manu and she was jealous of me when I met John. She tried to take him for herself but he stayed faithful to me.

teens United States |

1/13/2011 1:21:13 PM #

teens

She must have felt my resistance wane, because the next thing I knew her tongue was in my mouth. I couldn't believe it. I wondered just how far she intended to go with me. She certainly showed no signs of stopping.

teens United States |

1/14/2011 8:38:19 PM #

Wilmington NC Custom Home Builder

Our family wishes to improve to a larger custom home but with the current condition in the economic climate we are going to most likely remain in our current residence and repair it up a bit.  I would like a fresh bath even though it almost certainly isn't going to add to the worth of the house since price ranges have gone down.  It probably will make it easier to sell when the time occurs though.  Many thanks for this post.

Wilmington NC Custom Home Builder United States |

1/23/2011 8:52:06 AM #

steve jobs resigns

Who ever has the balls to turn that in is my hero. LOL man.

steve jobs resigns United States |

Comments are closed

Dislexia

I see people have commented about my style of writting.
Well I have dislexia so spelling is not one of my good points
but when it comes to reading/written code thats the easy bit.

 

 

Poll

What Search Engine Do you use




Show Results

Disclaimer of Liability

While every effort will be made to ensure that the information contained within this website is accurate and up to date, The Company's listed with this web site and any associated parties, make no warranty, representation or undertaking, whether expressed or implied, nor does it assume any legal liability, whether direct or indirect, or responsibility for the accuracy, completeness, or usefulness of any information.

 

Google Ads

Most comments

apply cash advance apply cash advance
1 comments
us United States
cloudy cloudy
1 comments
us United States
mutuelle mutuelle
1 comments
fr France

RecentComments

Comment RSS