JMoss
jmoss111 at bellsouth.net
Fri Jul 23 07:00:08 CDT 2004
In excel turn on the macro recorder, and create your header. Stop the recorder and open the macro, and copy the code. Then in an Access module, insert the code with looping and row counting with your recordset code. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of paul.hartland at fsmail.net Sent: Friday, July 23, 2004 6:40 AM To: accessd Subject: [AccessD] OT-Excel Printing Header Rows On Each Page To all, I have an access database which in the end opens an excel spreadsheet, the problem being if it goes over one page I need the header to appear on all over pages (header being row A & B). Anyone any ideas how to do this, without the user having to go into Page Setup and do it manually ? Thanks in advance for any help. Paul Hartland -- Whatever you Wanadoo: http://www.wanadoo.co.uk/time/ This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com