rob@trainease.com
New member
- Local time
- Today, 03:34
- Joined
- Jul 29, 2001
- Messages
- 5
Having solved the problem of how to change trays - it has given me a new problem.
There are three reports.
When selecting all three -
COC - prints 1 white, 1 yellow, 1 white
AdviceNote prints 1 white
Invoice prints 1 white and 1 yellow
AdviceNote prints 1 yellow.
Of you select any one - it prints all colours for that report alone
The bog stanard code was lifted from the help I got here. (Controlling print) It opens each report in design mode, changes the settings, saves it, selects it, and prints it. I added a line to close the report.
If I run any one of the above reports, everything is okay, but if I run 2 or all 3, then the system errors when you try and assign the next invoice number to the next delivery item (using a GetNextNumber() routine that accesses a single record table with all the next numbers in it) - you get the message - User XXX on machine YYYY has placed the database in a state that it can't be opened or locked.
After multiple report printing, it seems to think we are now designers and won't play ball as a user.
The seven routines behind the print button all close the report, and nothing is left on the task bar to indicate anything has been left open.
Any clues?
I did try SelectReport = false instead of closing the report - but no joy there either
The only way to clear it is to close the form you started from - a bit of a nuisance for the user to have to fire from the main menu each time they want to enter a delivery and print the paperwork, as the form is pretty busy and takes a while to load.
HELP!
There are three reports.
When selecting all three -
COC - prints 1 white, 1 yellow, 1 white
AdviceNote prints 1 white
Invoice prints 1 white and 1 yellow
AdviceNote prints 1 yellow.
Of you select any one - it prints all colours for that report alone
The bog stanard code was lifted from the help I got here. (Controlling print) It opens each report in design mode, changes the settings, saves it, selects it, and prints it. I added a line to close the report.
If I run any one of the above reports, everything is okay, but if I run 2 or all 3, then the system errors when you try and assign the next invoice number to the next delivery item (using a GetNextNumber() routine that accesses a single record table with all the next numbers in it) - you get the message - User XXX on machine YYYY has placed the database in a state that it can't be opened or locked.
After multiple report printing, it seems to think we are now designers and won't play ball as a user.
The seven routines behind the print button all close the report, and nothing is left on the task bar to indicate anything has been left open.
Any clues?
I did try SelectReport = false instead of closing the report - but no joy there either
The only way to clear it is to close the form you started from - a bit of a nuisance for the user to have to fire from the main menu each time they want to enter a delivery and print the paperwork, as the form is pretty busy and takes a while to load.
HELP!
