Search results for query: *

Hello! I really need your help! Ideally, the code should open specific directory (folder). Loop while opening all the Excel workbooks inside the folder. Copy “sheet1” from each workbook and paste it onto my active work. The worksheet should be copied using PasteSpecial...

It seems, I am pretty tired. Let me try again, Average (difference (Minimum ([Column A] ) - [Column B] on each group

I realized that My formula should read as: Average (between the difference Column A - Column)on each group. On column A, I need the minimum for each room number, each room number has two datetimes only on column A. Thanks again!

Hello, I am an active Tek-tip site user requesting help. This time around, I am trying to meet a deadline( I have researched for hours). I am willing to send you a e-card in the amount $40 from Amazon.com, if I star your post. I will be very very grateful!!!!! On Crystal reports: GROUP 4...

Yes; the count formula is on the group header. Should I move it?

I just tried the code below and these are the results: - The code hides Group Header 2 when the count is less than 1 (great) - Group Header 2 is not repeating on the next section. :( Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer) If (Me.TxtNumEnc < 1) Then...

Following your advice, I commented the code and the Group Header is performing as expected (Repeat on each page) Do you have an idea how to create a event condition on VBA? If condition_1 Then result_1 ElseIf condition_2 Then result_2 I am not sure if this is correct: If (Me.TxtNumEnc...

This is the code hiding the group header if specific field is blank. Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer) Cancel = (Me.TxtNumEnc < 1) When the cell is not blank; then, I am expecting this group header to be displayed and carry forward to the next page if...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Cancel = (IsNull(Me.TxtDetail)) Is this code Incorrect? Something is not working

Yes; the code hidden you suggested on a previous post to conditionally hides the group if blank. (it works great hiding the section) Private Sub GroupHeader2_Format(Cancel As Integer, FormatCount As Integer) Cancel = (Me.TxtNumEnc < 1) End Sub

Hi Duane! Thanks for your suggestion. Filtering the query is not an option. There are other fields on those specific record that need to be displayed on other sections (groups)of the report.

Thanks Duane! The group header is on the main report, and I am force to use Print Preview because the report needs to be exported to PDF.

Group Header Won't Repeat on Next Page even when Properties set to "RepeatSection" = "Yes". Any help will be greatly appreciated!!

I need to hide detail section (eliminate space) if specific field is null.

Thank you Duane! It works great!

On MS Access 2007, I am attempting to hide Group Header 2 if detail is blank. Also, it would work if I could hide the group based on specific text field being Null Thanks!!!!

On MS Access 2007 Report, I am attempting to hide Group Header 2 if the detail is blank for that specific group. Your help will be greatly appreciated, I am working against a deadline. Thank You!

Thank you for replying Mike! Weight= 150.79 I need to display as "9 lbs 6.8 oz

Hello, I have field or manufacturing weight in decimals, and I need to convert to pounds and ounces. in this format: 10 lbs and 5 oz. This is a two step process: a)convert decimal to pounds b)format format: "10 lbs. and 5 oz." Any help will be greatly appreciated!!!

Thank you "fishromacse", it works great!