Andy Lacey
andy at minstersystems.co.uk
Fri Nov 21 04:47:22 CST 2003
A dead simple way that I use is to set up a temporary table with an Autonumber key, set the Label report's recordsource to the temp table sorted on the Autonumber, then when the user selects the starting position I write the appropriate number of blank records (one less than starting pos) to the temp table before writing the required address. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Subject: RE: [AccessD] Date: 21/11/03 10:41 Have a look at http://www.peterssoftware.com/ls.htm Tim -----Original Message----- From: pedro at plex.nl [mailto:pedro at plex.nl] Sent: 21 November 2003 10:06 To: AccessD at databaseadvisors.com Subject: [AccessD] Hello group, i want to make adress-labels for 1 single adress. In our hospital we use sheets of labels. Is there a way on a form when i have selected one user, to give the position on the report, where the adress on the label must be printed. for example i have a labelsheet with 6 labels. Can i make command buttons an click on the third commandbutton, so that the adress is placed on the position of label3 "labelsheet" cmd1 cmd2 cmd3 cmd4 cmd5 cmd6 TIA Pedro Janssen _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2