Search results

  1. Shipper225

    Combining Line Items From Query onto a Form

    Ok, I'll give it a shot but just to show my inexperience I may be back if I can't figure out the subform. Thank you for the help.
  2. Shipper225

    Combining similar but not identical fields

    I've been looking about and was wondering if it is possible to make a report based off a query that would combine fields that are closely related but not the exact same. My example is, I have parts : BM 2K A BM 2K B BM 2K A Type 2 BM 2K B Type 2 (these items go from 1K all the way to 12K) Each...
  3. Shipper225

    Combining Line Items From Query onto a Form

    Attached. Used WinZip to compress all the data down.
  4. Shipper225

    Combining Line Items From Query onto a Form

    Ok, as I mentioned since the size of the table with all the data is to large for one attachment you have to take the depthrecord database and put that table into the frt cost sample database
  5. Shipper225

    Conditional Formatting Running Slowly

    From my experience with the conditional formatting in Access 2010 is that if you use it in a form and you move to the next line it basically reloads everything each time. I only use the conditional formatting in reports as it tends to keep things moving at a decent pace.
  6. Shipper225

    Combining Line Items From Query onto a Form

    My apologies, it was to large to post as one full unit. Attached is a database with just the table, copy the table over the existing one that was with the first attachment.
  7. Shipper225

    Combining Line Items From Query onto a Form

    Well thank you for any input you can give. As I said I started a new form thinking it may be easier to just do a search with fields to fill in and have a code that would plug in the data but I couldn't get the code to pass the data to all related records.
  8. Shipper225

    Combining Line Items From Query onto a Form

    Yeah the whole database is far to big to upload here. Should be 1 form, 1 query, 3 related tables
  9. Shipper225

    Combining Line Items From Query onto a Form

    As I mentioned when I run a shipment through the query I have 18 lines per shipment thus the form displays 18 lines instead of 1 line listing a QTY of 18. When I do have it display the 1 line I need to be able to type into the Freight cost, invoice and the Invoice paid fields to have it update...
  10. Shipper225

    Combining Line Items From Query onto a Form

    Here is a basic version.
  11. Shipper225

    Combining Line Items From Query onto a Form

    The DSum formula we worked on still displayed all the line items instead of condensing them down to a single record that would update all the line items in the referenced table.
  12. Shipper225

    Combining Line Items From Query onto a Form

    Yeah I managed to squeeze in a day off, it's shocker around here for that. I have been trying to figure the easiest way to update multiple line items using a form or a query. We tried using DSum but that would give me the total pieces per truck load. I tired using the count and or sum from the...
  13. Shipper225

    Combining Line Items From Query onto a Form

    The bound form being the first form I created? Sorry still learning all the terms of access
  14. Shipper225

    Combining Line Items From Query onto a Form

    So I worked around the idea by creating a search form that will allow me to bring up all the line items from the shipments by searching the BOL # field. I wrote a code that I figured would let me fill out the text fields on the top of the form and have it automatically fill in the corresponding...
  15. Shipper225

    Combining Line Items From Query onto a Form

    Yes, right now I have 1 shipment with 18 line items i.e. JB-206A-1 will show up 18 times on the report, if I can get it to show up only once with a total of 18 (like the formula we worked on does) and lets me update that one line item pushing the data to all related ones I'd be all set. Maybe...
  16. Shipper225

    Combining Line Items From Query onto a Form

    Ok so I guess I was wrong. Ran the form with more data in it and I am able to edit the 3 fields I need but it is not combining the line items as I had originally set out to do. My hopes had been to combine all the fields for the same shipment input the data and have it pass through to each line...
  17. Shipper225

    Combining Line Items From Query onto a Form

    Wow something so simple. Thanks again you've been a great help on all of this.
  18. Shipper225

    Combining Line Items From Query onto a Form

    Ok that did wonders getting rid of the error. I used the code: As you instructed but now I have a blank form with no data being pulled over from the query. This is what the form is: COR # (display in Ascending order) BOL # (display in ascending order) Ship Date, QTY Shipped (where this formula...
  19. Shipper225

    Combining Line Items From Query onto a Form

    Here's the field info from the query screen: JobNumber being an alpha numeric field and ShipmentNumber being a number field. Also it is sorted by Ascending if that matters at all. This works so that JobNumber: 206A with ShipmentNumber: 3 is displayed as: JB-206A-3 and is sorted in the proper...
  20. Shipper225

    Combining Line Items From Query onto a Form

    I always give it a few attempts and a bit of my own research before figuring I'm failing badly ;) Here is the code I tried: BOL # being the reference field (that I made in the query) that the cells should be grouped on. Problem is that it's returning a #Error. Now I've tired checking the " mark...
Back
Top Bottom