Search results

Yes that was the problem Thank you!!!!!!!!!!!!!!!!!!!!!!!!!!!

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...

Would the total go in the same area as the page break?

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.

Now you really see my confusion. Assuming it must be written wrong.

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.

How would it be used in the execution of a report?

Does anyone have any idea what control break technique is?

Thanks that was exactly what I was wondering. I have split it but wanted to make sure how to set it up using the link table manager.

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

My reports are only showing one record per page and that is not what I want. I want them to show on one page. What simple thing am I overlooking?

They are formatted as time. I looked through the different examples and it show how for format date/time and minus dates from other dates but I need it to specifically subtract the first time from the second time and display the results in another text box. I understand that is where I would...

Example ?? The second choice seems more along the lines of what I need but not sure how to go about it. These reports work along the lines of drill down. One group has a specific set of criteria and the second group has the same plus more and the third has even more plus all the previous criteria.

Unfortunately there can be no parameters that pop up. Somehow it has to run in the background. The form is being created so that there is absolutely no typing in the form. The date is chosen from a DTPicker and then the user just clicks on a button that produces a specific report. For now I...

I have two text boxes that show a begin time and an end time. I want to take the different and put it in another text box that shows the results. EX: begin end total 05:12 am - 05:23 am = 11 Any suggestions?? I am looking to make it so whoever does data entry, it will be a...

Is there a way to produce one query that will produce several results that display in a report that is generated from a button? The only difference is the criteria. EX: SELECT tblDownTime.dtDate, tblLine.lineName, Sum(tblDownTime.dtDowntime) AS [Total Time Down] FROM tblMachCent INNER JOIN...