Transentient
Registered User.
- Local time
- Today, 05:23
- Joined
- Sep 25, 2007
- Messages
- 31
I have a contacts database I have constructed for my employer. As part of this i have designed and integrated a facility for producing a mailing label, incorporating the facility to place the label any where on the sheet (see attached picture). This all works fine.
Essentially the process followed is:
1) user chooses which contacts are to have labels
2) table generated containg company name, address etc for only those contacts selected.
3) union query runs to build in number of empty places before staring label position. Default start position is 1 when form opens. User can then user the selector pad to choose a start position.
4) Report generated from the query with the label(s) positioned correctly. This can then be printed.
5) Report is exported to a RTF document.
6) Preview pane linked to RTF document.
This means a label(s) are generated and a preview of whole page is shown, with the label in the desired start position. This all works ok
I know want to introdue a zoom facility. I have tried some code I found, from Stephen Lebans I think. This only magnifies what is on the screen so therefore the text is no clearer.
I have tried using another form, with a text box that displays the data directly from the table created in stage 2 above. My problems come when I want to get the zoom pane to display the approriate record to the label selected on the preview pane, specifically when dealing with mutiple contacts and multiple label quanties i.e say 2 contacts x 2 labels each contact.
A bit long winded, sorry, anyone with any suggestions?
many thanks
Essentially the process followed is:
1) user chooses which contacts are to have labels
2) table generated containg company name, address etc for only those contacts selected.
3) union query runs to build in number of empty places before staring label position. Default start position is 1 when form opens. User can then user the selector pad to choose a start position.
4) Report generated from the query with the label(s) positioned correctly. This can then be printed.
5) Report is exported to a RTF document.
6) Preview pane linked to RTF document.
This means a label(s) are generated and a preview of whole page is shown, with the label in the desired start position. This all works ok
I know want to introdue a zoom facility. I have tried some code I found, from Stephen Lebans I think. This only magnifies what is on the screen so therefore the text is no clearer.
I have tried using another form, with a text box that displays the data directly from the table created in stage 2 above. My problems come when I want to get the zoom pane to display the approriate record to the label selected on the preview pane, specifically when dealing with mutiple contacts and multiple label quanties i.e say 2 contacts x 2 labels each contact.
A bit long winded, sorry, anyone with any suggestions?
many thanks
