Recent content by Stevenje

Oh ok, I think I understand. You want it to Collate, Print page one with first footer, then print page one with the second footer, then page two ... I would have to do a little research on this. Basically you would have to use the same code as I gave you earlier but with a little twist. See...

I guess I am confused by what you mean together. If you want each copy to have a different footer you are going to have to print it twice, once with one footer and then the other one with the second footer. They will happen one right after another. You're not going to be able to have the...

Correction, Left off a couple things ** Code for the Page Footer on your report Private Sub Detail1_Format() If Forms!MyForm!FooterFlag = 1 then Me.txt_CopyMesage.Value = "This copy for Customer" Me.txt_ReturnPolicy.Visible = True Me.lbl_CustomerSignature.Visible...

I didn't try and debug the code, but logically here is what I believe will work. 1. Based on the criteria or selection in a field set a flag that is for multiple copies. So If I must have 2 copies set flag to true, if not set flag to false. 2. have a button to click that will run the report...

So with an MDE file, can the user, if they use Shift, can they see the tables. I have a situation where I was trying to prevent access to the back end. Which are linked tables in Oracle using microsoft ODB. How can I make it so the users cant see these tables? Should I create an Access back...

I thought you could still get to the code and database tables if you hold shift as you open the mde file. I have been able to do this and see the raw data, and code. I couldn't how ever do anything in the code as far as editing, adding, etc. If I'm not learning, I must be coasting. If I am...

It would be helpful if I could see the actual code. I'm thinking that it might be an order issue with the code. It's hard to tell. If I'm not learning, I must be coasting. If I am coasting, I must be going down hill.