Search results

This is my second database. My first database was completed with a lot of study and video tutorial, along with excellent tips on this forum. You both have made a good observation. I do have all nine loads in one table. The customer brought his Excel spreadsheet for me to review and create a...

In my query there are 9 fields that record weight of truck loads, Load1, Load2,...through Load9. Some fields may have no entry. I need to count ONLY the number of loads that have entries. Once loads are counted I then need to perform the following calculation: Gross Weight - (Tare Weight x...

Thanks so much for your post and answers to my questions. I double checked my code AND found my error. It's working wonderfully!

This forum has helped me on so many occassions. Over the last 2 days I have searched and found answers so close to what I need. My issue: I have a query in which I average 3 fields. In some cases all three fields may be null. When they are I get an #Error in my average field. In several...

Wow, this is exactly what I need, and I'm trying to get it to work. I have 3 fields (sometimes null value) that need to be averaged. In my query, using the expression builder, I placed all of your code into the "Field" of column named "Average Tare:". (I did substitue my field and column...

This worked for me. Many thanks for all the posts and ideas from everyone here.

Brain cells, highly over-rated. Can you tell me how to post the db?

I'm missing something, perhaps a few brain cells. Here's the code for the Form which opens the report fine: Private Sub cmdCancel_Click() DoCmd.Close acForm, Me.Name End Sub Private Sub cmdOK_Click() If IsNull(Me!txtStartDate) Then MsgBox "You must enter a Start Date."...

Thanks for the welcome. I've book marked the site. I think my brain is fried. :eek: Would you believe on the report close event, I entered the following code and now I'm back to the original problem. The date is showing up with #Name? in header of report: Private Sub Report_Close()...

Thanks, that worked for hiding the form: Me.Visible = False I'm sorry, but I don't know what code to put in the close event of the report to get the form to close. I'm pretty new, I've spent a few months self-taught with a book, and a video tutorial. Sure working hard and don't want to be...

Thank you so much for your help. I'm part of the way there. I removed the close command from the form. However, it did stay on top of the report, when the report opened - as you suspected. You say to hide it in the code that opens the report and close it in the close event of the report...

That's it, the form I created is a custom dialog box. Once the Start Date and End Date are entered, I click the OK command button. The form closes and the Report opens in Report Preview, ready to print. I just did a test where I had the report open in Report Preview. Then went back and...

Yes, the form is still open in Print Preview. However, I noticed if I go to "Report View" or "Layout View" I see the error message #Name?

I've created a report that opens via a form that requires a Start Date and End Date. I would like the date range to show up in the report header. I created an unbound text box in the header of the report and in the control source referred to form that generates the report as such...