Search results for query: *

Solved! I figured it out. The press will only ever have 1 Roll of paper active at any time, so I created a query to pull the record that is missing the ending data. I then created a subform based on that query on the change roll form. I created an unbound text box with 'on change' and 'after...

I may be going about this in completely the wrong way, but I'll try to explain what I'm trying to accomplish. I have a table - RollTable I am tracking footage of usage on a roll of paper for printing. I would like to have a form where the operator would only have to put in the beginning...

Thanks dhookom!! Sorry about my vague post, but you were able to read thru it because that's what I needed. I knew there was something I could do with the IsNull, but I could not figure it out. I included the calculation you provided in the report variance calculation so that I could keep my...

I would like the report variance to only show the percent from total pages and actual clicks where both fields are populated. The actual clicks are added from a different table at the first of the following week. Is there an easy way to do this or should I just live with it the way it is...

I got it. I removed the Me.isDuplex.Undo line altogether. The Cancel action does it already. Thank you for your help!!!

Thanks MajP. This works, but the only problem I had is when it pops up with the msgbox to fill in the job page amount first, it doesn't uncheck the isDuplex box. It's somewhere in this code: If Trim(Me.jobPageAmount & " ") = "" Then 'Need to have the job page amount filled in MsgBox...

I am working on a database that tracks printing press production and waste. To calculate for duplex printing, I want to include a check box on the form that when the box is checked it will double the job page amount entered into the table and on the total shown at the bottom of the form. This...