I used the sorting and grouping option and added an extra footer section, added the after section there and it worked. Also added a sum text box and got the totals I was looking for.
If MachineCenter = backline And Line = "Line 2" Then
Call MsgBox("sorry - that value not allowed")
Cancel = vbCancel
End If
This is exactly what I put in and it still allows the user to enter Backline on Line 2. Did I miss something? No error message or anything else pops up...
I have a form that has a combo box labeled 'line' and I have a combo box labeled
'MachineCenter'. I want to create a validation rule so that if a user picks 'Line 2' in the first combobox they can't enter 'backline' in the second combo box. I am not sure how to write it.
Can anyone help with...
I need to seperate report pages when the line text box goes from 'line 1' to 'line 2' and it needs to have a total at the end of the page showing total amount of time that each line was down.
Where would the page break go?
I understood what you meant. I have used both bob's and your suggestions and was able to create a set of directions that hopefully doesn't leave out a step. Thanks to both of you.
Working on an assignment and was told to use the control break technique and couldn't quite figure out what it was.
Told to use it in creating a report.
I was wondering. I have created my switchboard and everything works great. All my forms show up like they are suppose to. Is there a certain process to loading the front end on the network and keeping the back end so that it can't be accessed?
The force new is set to none, but I think your right, it is how it is set on the page, because as I make things smaller the records show on one page. Now it is just a matter of rearranging things. Thanks