Search results

Many thanks, I'll give it a shot and let you know how I do.

The user is only concerned with the entire event. He was concerned that he wouldn't remember a specific date when searching for a harvest event. Of course, it's ok to have start and end dates, if that's what is needed. Thank you for taking time to answer all my questions.

I kept my original database to compare to your updated version 2, so I can learn from your example. In my original I could easily see the unbound combo box, and how to fix it viewing your version. On unbound combo boxes, it looks like you hi-light the unbound box and type the source (such as...

Thank you for your detailed post and updates. Today has been busy, I look forward to getting into this tonight. Thanks so much.

Attached is the database, thanks for taking a look at it this evening. There haven't been any changes to the table structure, and it does include your recommendation for tblFieldPlotCrop. In working on forms, I have created 2 forms that have sub forms, frmHarvestDates and frmFields. Your...

Thanks so much for your help. What I mean is....each time something is harvested from Putnal Big Field. It seems I may be confusing this form, frmFields, with forms I'll need to do actual data entry. In the last few days I've continued to review our discussion here. I've printed out your...

Hello, I'm back working on this project. Since the form is tied directly to the underlying table that holds the field names, does this mean I enter the txtFieldName such as Putnal Big Field, each time the Putnal Big Field is used?

I also am having a similar problem with a query. My query, QryNetPounds is based on 2 queries QryHarvestLoadSum and QryRecentTareAverage, which are joined by Date and VehicleID. Data is entered for 3 harvest dates: 03/30/2009, 03/31/2009, and 04/01/2009. No results return for 04/01/2009...

Thanks so much for your quick response. I'm past my deadline on this project. In join properties, the first option was selected. I tried option 2 and option 3, both gave me an error message: "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of...

This forum has been a life saver for me many times. Attached is database that I’m having trouble with. I have a query named QryNetPounds to calculate Net Pounds and Net Tons. This query is based on 2 queries QryHarvestLoadSum and QryRecentTareAverage, which are joined by Date and VehicleID...

Thanks so much, that worked great!

I enter Vehicle Tare Weight into a Table (named Tare), by Date and by VehicleID. Then I get top 3 (most recent) Vehicle Weights in query named QryRecentTare. Then I average the most recent 3 Vehicle Weights in query named QryRecentTareAverage. This gives me the average of the 3 most recent...

Thank you, that worked.

From another query titled QryDryAverage, that calculates the average by date.

Attached is my database project. My query, QryDMTons is returning the correct results for the following field names: DM Tons Adjusted 30% Expressions for field names are as follows: DM Tons: [Avg Of DryMatter]*[Net Tons]/100 Adjusted 30%: [DM Tons]/0.3 Prior to adding the above...

It looks like I have my first mainform/subform/subsubform setup, attached is .jpg. All the fields are populating. Your detailed instruction was very helpful. On the very first field on the main form txtFieldName, should that be a combo box to choose the Field Name? I'm going to look at your...

Thanks for the detailed response, that really helps. I'm going to go back to work on it some more.

Good to know I’m on the right track. I’ll put data in tables and see what forms may be needed. The table below has pk and fk’s, with no data input field. This table wouldn’t require a form for data input, is that right? If I understand this, its purpose is to join related tables. Perhaps I still...

The Master and Child Field Links all look good. That’s a great tip; I didn’t know to check for that even when tables are joined in the Relationships window. Since the Links all seem to be correct, I wonder if I have other forms to create or perhaps test data to be entered. On first glance I see...

Thanks so much. Attached is a .jpg of my Main form with subforms. I did the combo box for TruckID, as you suggested. Some other foreign keys did not populate. Do I need to a create combo box to look up those values?