Search results

After doing more research, I have updated the code to the following, but it still does not work. Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer) '// Hide Available Hours for Unscheduled Work //' If Nz(Me.Section(acGroupLevel2Header).Controls("Mech_Scheduled"), "") =...

Hello, I have a report that lists scheduled and unscheduled work for our mechanics. I also have a summary at the end of the report that lists how many work orders were scheduled, how many hours were scheduled etc. I am also totalling their available hours. However, I would like the report to...

Thank you CyberLynx. It works perfectly. Liz :-)

Thank you for your response CyberLynx. I have compacted my db and then zipped it. Here it is attached. It is the frmMechDailyWork and the corresponding frmMechDailyWork(subform) that is not working properly. The matching frmDailyWork and frmDailyWork(subform) are what I was modeling the Mech...

In design view, there is space in the General tab at the bottom of the window to set the default value for that field. Here is a link to a good resource. http://www.csus.edu/training/handouts/workshops/Access_2007_Overview_and_Tables.pdf Hope this helps you. Liz

It is returning the 3 each time because rather than setting the default, the DLOOKUP function is setting it to always lookup "Band 1". You can set the default for the field within the table setup itself. Hope this helps. Liz :)

I have a form with an embedded subform for data entry. When the information is put into the form and the user presses enter, the data should then jump down to the subform with the form being blank again ready for another entry. What is happening now, is after the date is entered in the form, it...

I did use AND rather than &, but that did not help either.

Hi all, I have a database where we schedule work and have the corresponding work order or preventative maintenance number in a field called [WO/PM #]. I am trying to make a field that will basically find the records for the certain day and if the work is scheduled and the [WO/PM #] field...