98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training onsite - Excel Access Page breaks and Headings
excel training onsite - Excel Access Page breaks and Headings
Resolved · Low Priority · Version Standard
Wed 17 Jan 2007, 13:36Mike Palmer (guest) said...
Excel Access Page breaks and Headings
I have created the VBA to produce an excel spreadsheet directly from a command button on an Access form. I can format the data correctly, but I am having trouble with a) creating page breaks, and b) placing headings at the top of each page, where some values may change, such as week number.
I have also found that after each time I run the report, I have to repair and compact the database, any ideas?
Mike Palmer
Mon 22 Jan 2007, 15:39Trainer Jacob said...
RE: Excel Access Page breaks and Headings
HI Mike
Thanks for your questions and sorry for the delay in getting back to you. My colleagues who are experienced in these topic areas are training today, we will get back to you as soon as we can.
To help in our response; are you creating page breaks for each spreadsheet produced or trying to include this as part of your code?
Also are you attempting to the same for the headings with dynamic values?
Jacob
Mon 29 Jan 2007, 11:40Trainer Jacob said...
RE: Excel Access Page breaks and Headings
Carlos: Please have a look at Mike's question, can you help?
Thanks
Jacob
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Reconciling a list to correspond with anotherMay have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way. |
