Search results

Thank you for working with me on this, I'm sure it's getting annoying with all the added questions but I just keep failing somewhere along the lines. I tried the DSum with this formula: =DSum([UnitsShipped],[tblDepthRecord]) UnitsShipped being the Field I want summed up, tblDepthRecord being...

Where would I put the term since Access won't let me put it right into the criteria or total fields?

Ah ok, I think I'm starting to get it now, I need to do a DSum() so that I can edit the data in the 3 fields I need then

The only problem I run into now is that it wont let me make any edits to the form. I get the message that the RecordSet is not updateable

Works beautifully, thanks

Hope this is correct, still learning things with Access 2007

Just the SQL and support tables attached, whole database is .. well huge by now lol

Ok attached are the relevant tables for this query, I didn't write this I'm just trying to generate a new report since the programmer is no longer with the company. Compressed as a RAR file had to change extension to ZIP

I looked into that link a few days ago but couldn't get it to not list all the line items. The only real fields I need to display are: COR#, JB, Ship Date, Frt Cost, Invoice #, Invoice Paid. My boss would like to see me get a total piece count displayed in the Shipped QTY field if possible.

My boss would like to see the total pieces shipped out on each shipment but we don't need to see the actual break down of how many pieces per line item

There is only 1 date per shipment but can have a few shipments on one day. The biggest issue I am running into is the fact that each shipment has a few line items and that is what makes them show up on the report more then once.

Ok so I've been put in charge of another database, this one was built by someone else and I have been trying to create a new form based off the programmers tables and queries. The problem I have run into is that I have 1 shipment with 10 line items to it so on my form it displays that way. Is...

I have a few databases that I maintain using the BE, what I call the middle and the accde versions. I find that if someone is in the accde version on the network then the version I have open for editing will be a lot slower. I should also note that all 3 parts of the database are on the server...

Ok a bit of background, I've made 3 or 4 (could even be a dozen by now) databases in Access 2007 and instead of running them all as separate files I was wondering if there is a way to combine them all into one database or exe file. Now some of these are quite large databases so combining them by...

Thanks but i went the lazy way out, right before the End Sub command I put in that the search form is to close once the code is run thus forcing a fresh start for searching. Thanks for everything

See this is why you don't put someone from the shipping department in charge of making a database. It works much better thanks to all the help from you Gina, the last (as I hope at least) issue is that when I open one form then close it to go back to the search if I don't close the search form...

Clicking the number is supposed to open the corresponding report in the Accident/Near Miss form

Attached, had to remove the user log in forms so it was small enough to fit

All test data is in here right now, the log in you can bypass for now or enter the info in the text box. You can open the search box from the Main Screen

GinaWhipp, I am getting so frustrated with this now I am really thankful you are helping me work through this bit. In the code I posed above when I go to run it I get a "Compile Error Syntax Error" with a yellow arrow highlighting the "Private Sub AutoNumber_Click()" and the line "Msg Box...