Hi
I have a report which prints a label on a label printer that contains a barcode which is then stuck on the box.
This works absolutely fine.
The problem I have is when other people use the system. It runs from a MySQL BE and each user has their own network save FE with a link to it on their desktop.
Each PC that uses the system has the paper size set up in windows, named exactly the same.
On the report I have not set the default printer to use, as although it is the same physical printer, its sometimes called different things. As it is only a USB printer it is not on the network, and when it is it is shared from the PC it is connected to. There's only a couple of different machines.
When the person comes to print the label they select which printer they want to use from a combo box, and hit print, the report then prints the label. All this works fine.
What doesn't though is the paper size. For some reason every time I update the FE and people log into it for the first time, it changes the paper size to something else and mis-prints the label. I have saved the report with the correct paper size set, and never have a problem on my machine, but others do.
Every time I update the FE, I have to open each users version and change the paper size manually.
Does anyone have any ideas as to what might be causing this, or any code that I could put in place so that when the report opens, it changes the paper size to what it should be?
I have a report which prints a label on a label printer that contains a barcode which is then stuck on the box.
This works absolutely fine.
The problem I have is when other people use the system. It runs from a MySQL BE and each user has their own network save FE with a link to it on their desktop.
Each PC that uses the system has the paper size set up in windows, named exactly the same.
On the report I have not set the default printer to use, as although it is the same physical printer, its sometimes called different things. As it is only a USB printer it is not on the network, and when it is it is shared from the PC it is connected to. There's only a couple of different machines.
When the person comes to print the label they select which printer they want to use from a combo box, and hit print, the report then prints the label. All this works fine.
What doesn't though is the paper size. For some reason every time I update the FE and people log into it for the first time, it changes the paper size to something else and mis-prints the label. I have saved the report with the correct paper size set, and never have a problem on my machine, but others do.
Every time I update the FE, I have to open each users version and change the paper size manually.
Does anyone have any ideas as to what might be causing this, or any code that I could put in place so that when the report opens, it changes the paper size to what it should be?
