Here's the database I am working on. A form comes up with 3 buttons.
The first one transfers a comma delimited text file into a table.
The second button opens a report which runs a query that sorts and retrieves only certain information. It puts each line into a cell in a table, 3 across (3 columns) and then repeats on the next line. These cells are formated to fit on a sheet of labels. They need to remain just as I have set them in page setup!
The third button runs a delete query that clears the table.
During the actions of either the text transfer or the delete query the page setup settings are lost. The columns attribute reverts to 1 column and the margins revert to 1". I DO NOT WANT ACCESS TO DECIDE MY COLUMNS AND MARGINS. THIS 'FEATURE' IS NOT WANTED!!!
How can I prevent this from happening? Some have suggested PrtMip, but I have been unable to get this to work and nobody is able or wants to help me. PLEASE HELP ME!!!
The first one transfers a comma delimited text file into a table.
The second button opens a report which runs a query that sorts and retrieves only certain information. It puts each line into a cell in a table, 3 across (3 columns) and then repeats on the next line. These cells are formated to fit on a sheet of labels. They need to remain just as I have set them in page setup!
The third button runs a delete query that clears the table.
During the actions of either the text transfer or the delete query the page setup settings are lost. The columns attribute reverts to 1 column and the margins revert to 1". I DO NOT WANT ACCESS TO DECIDE MY COLUMNS AND MARGINS. THIS 'FEATURE' IS NOT WANTED!!!
How can I prevent this from happening? Some have suggested PrtMip, but I have been unable to get this to work and nobody is able or wants to help me. PLEASE HELP ME!!!
