Greetings and salutation,
I am new to the forum - so hello all!
I could really use some assistance as I am also new to database administration. I have been given a database that was originally developed in Access 2003, and has been upgraded to 2007 and recently upgraded again to 2010. My issue is with Headers and Sub-headers.
Within a group, we have data set up in a three-tier format. When printing this data, we want headers (i.e. Telecom Testing), sub-headers (i.e. POTS or Cellular), and then the list of testing results. My problem occurs when the listing of results continues printing onto the next page, at least one line of data appears above the -sub-header.
For example: Telecom Testing
Telecom Testing: POTS
Line of data (testing results)
Line of data
Next page
Line of data
Telecom Testing: POTS
Line of data
Telecom Testing: Cellular
Line of data
I am not very familiar with VBA, either, so not sure how the code is set up or how to fix it. Any assistance would be greatly appreciated.
Thank you
I am new to the forum - so hello all!
I could really use some assistance as I am also new to database administration. I have been given a database that was originally developed in Access 2003, and has been upgraded to 2007 and recently upgraded again to 2010. My issue is with Headers and Sub-headers.
Within a group, we have data set up in a three-tier format. When printing this data, we want headers (i.e. Telecom Testing), sub-headers (i.e. POTS or Cellular), and then the list of testing results. My problem occurs when the listing of results continues printing onto the next page, at least one line of data appears above the -sub-header.
For example: Telecom Testing
Telecom Testing: POTS
Line of data (testing results)
Line of data
Next page
Line of data
Telecom Testing: POTS
Line of data
Telecom Testing: Cellular
Line of data
I am not very familiar with VBA, either, so not sure how the code is set up or how to fix it. Any assistance would be greatly appreciated.
Thank you