I am very uneducated when it comes to working with coding and access in
general, so I apologize for anything that may be very obvious to somebody
else. Esentially my current problem is that I have a database that is
being
used on 15 or so different computers and on the form I have a command
button,
"print large" which sends the drawing and necessary info to a 36" plotter
in
the foremans office of the shop.
The problem I am having is the the button functions properly from my work
station but nobody elses. To get around this, I created two more buttons
with the same function for 2 other desks...in doing this however, I
esentially create 2 dead buttons on everybodies screen at the 3 pc's I
have
working buttons at and still have many machines where nothing works at
all.
I also have a "print small" button that sends it to a letter sized laser
printer...but this button works on the primary 3 machines. I'm assuming
this
is so because this printer is set as the default printer on each machine.
Here is the code section for one of the buttons:
Private Sub PrintLarge_Cmd_Click()
DoCmd.OpenRe****t "CAD Re****t2", acNormal, , "[File]=Forms![Test 2]!File"
End Sub
I am trying to find out if there is some way to code in that when on one
machine to do this and that...and while on another to do the same thing
just
from that one. If not, I will end up with about 15 Command Buttons that
do
the exact same thing and 14 that are dead depending on which machine is
being
used.
And as I am not real comfortable with this whole program yet, please let
me
know
if I should be posting this issue someplace else.
Any info what so ever would be greatly apreciated.
Thank You
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-multiuser/200807/1
|
