M
mphotographer via AccessMonster.com
I appologize for the wall of text that may be coming...I will try to break it
up, but I am new and am not sure what all info you guys may need.
I am working in a machine shop with 15 or so pc's connected via a central
network. All of which can print to one 36" plotter in the foremans office.
Here is my situation, they asked me if I would be able to scan and load all
of their paper drawings into a database. Though time consuming, it seemed
easy enough.
The troubles started when they said that I needed to create the database
myself and since I had never used access nor attempted to do any other coding
before, I was lost to say the least.
Via much trial and errror and a few messages on here about a year ago, I now
have a working database running and can search via drawing number, item name,
or company on the table.
What they would like now are buttons than anybody using the database can
print the drawing they need on the plotter. I managed to create command
buttons that can print the current drawing either on small format of 8.5"x11"
on the little laser printer with one button or large format on the 36"
plotter with another as well as opening in autocan with a third.
Here is the code section for one of the buttons:
Private Sub PrintLarge_Cmd_Click()
DoCmd.OpenReport "CAD Report2", acNormal, , "[File]=Forms![Test 2]!File"
End Sub
Here is where my problem finally comes in. I use a seperate report for each
button and have a default printer set for each so that I know where its going
and the size it will print. When I set up the "print small" and "print
large" buttons, they work fine from my pc but when i try from another persons
machine, the print small button works but the print large one does not. I
tried to talk to the tech guy here but I feel he would rather pull his own
teeth than discuss it with me. I did manage to get him to say its because
the pc's in this little office (3 pc's) are defaulted to the laser printer
which is probably why the print small button works on all 3 machines but the
print large only works on mine.
Finally, I just gave up and created 3 "print large" buttons... so now all 3
machines can print to the plotter but there are also two "dead" buttons on
everbodies screan in this office as a result.
I am trying to find out if there is some way to code in that when on one
machine to this and that...and while on another to do the same thing just
from that one. If not, I will end up with about 20 Command Buttons that do
the exact same thing and 19 that are dead depending on which machine is being
used.
And as I 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
up, but I am new and am not sure what all info you guys may need.
I am working in a machine shop with 15 or so pc's connected via a central
network. All of which can print to one 36" plotter in the foremans office.
Here is my situation, they asked me if I would be able to scan and load all
of their paper drawings into a database. Though time consuming, it seemed
easy enough.
The troubles started when they said that I needed to create the database
myself and since I had never used access nor attempted to do any other coding
before, I was lost to say the least.
Via much trial and errror and a few messages on here about a year ago, I now
have a working database running and can search via drawing number, item name,
or company on the table.
What they would like now are buttons than anybody using the database can
print the drawing they need on the plotter. I managed to create command
buttons that can print the current drawing either on small format of 8.5"x11"
on the little laser printer with one button or large format on the 36"
plotter with another as well as opening in autocan with a third.
Here is the code section for one of the buttons:
Private Sub PrintLarge_Cmd_Click()
DoCmd.OpenReport "CAD Report2", acNormal, , "[File]=Forms![Test 2]!File"
End Sub
Here is where my problem finally comes in. I use a seperate report for each
button and have a default printer set for each so that I know where its going
and the size it will print. When I set up the "print small" and "print
large" buttons, they work fine from my pc but when i try from another persons
machine, the print small button works but the print large one does not. I
tried to talk to the tech guy here but I feel he would rather pull his own
teeth than discuss it with me. I did manage to get him to say its because
the pc's in this little office (3 pc's) are defaulted to the laser printer
which is probably why the print small button works on all 3 machines but the
print large only works on mine.
Finally, I just gave up and created 3 "print large" buttons... so now all 3
machines can print to the plotter but there are also two "dead" buttons on
everbodies screan in this office as a result.
I am trying to find out if there is some way to code in that when on one
machine to this and that...and while on another to do the same thing just
from that one. If not, I will end up with about 20 Command Buttons that do
the exact same thing and 19 that are dead depending on which machine is being
used.
And as I 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