I'm not actually using queries, the code is behind the click event and actually uses variables from the form.
I have sorted it now by using a local table to collect the correct records, and then use that to update the main table.
Thanks for the suggestion anyway
I have a teaser – it’s been bugging me for long enough.
I have a letter produced from the database asking people to renew their support (Born Free Foundation). Amongst all the required data links and other conditions, the key is that Rem1Sent should be null.
After the letters have been...
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...
Hi
Before getting the accesswatch reply, I went off on a search and sort of found what I needed - which after a little work ended up as :-
First - a new Module "Printing"
Option Compare Database
Type zwtDevModeStr
RGB As String * 94
End Type
Type...
Does anyone out there have the code to select printer, tray and number of copies when opening a report? Is there an add-in for this?
The example in Help is no good at all.
Thanks