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
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
RE: Excel Access Page breaks and Headings
Carlos: Please have a look at Mike's question, can you help?
Thanks
Jacob
