Selecting Printers

[ElCid]

Hi

I have nearly completed my database with has been built in Access 2000. I'm just adding the final touches to it.
Once i have the security in place you will not be able to access the tool bars. This is where i am having an issue.

The database will be stored on multiple computers yet will have one design master which all of the repilca copies will syncronize to.

As each database will be on separate laptops which will not always be connected via the network. I need a way in which the user can select a printer without using the tool bar. Is there a bit of code or a form i can create which will display the printers availible?

This one is really stumping me.

Many thanks.

EL Cid

 

[M8KWR]

try the attachment this will work.

Any issues let me know.

 

[ElCid]

Woooot!

Nice one!

Looks like this will solve my problem.

I'll have a little play with it so i understand how it works,

Many thanks,

EL Cid

 

[bionicman]

i am having a problem getting this to work. i am having a problem if i try to implement it into my database, and if i just open the demo as is. it is changing the default printer on my system, but Access does not recognize it unless i close the DB and re-open it. any ideas?

Thank You!