Search results

I have a form pulling from a query with a number of fields. All the fields display the information properly, except the "CustomerRef_FullName" field, which shows up as "#Name". The field displays properly in the query, but not the form. I have the query field as the control source for the text...

I have a database full of Time Entries, linked to other tables, to show all information in one location. The "Time Table" stores the "Part Number", which is linked to "ItemRef_FullName" in the other table. When I enter an Order Number, I want it to return a list of parts, with only the latest...

Use criteria on a potentially null field? OK. So I have the following query: SELECT dbo_salesordera.RefNumber, dbo_salesorderlinedetail.ItemRef_FullName, Sum(dbo_invoicelinedetail.Quantity) AS SumOfQuantity, dbo_salesorderlinedetail.Quantity, dbo_invoicelinedetail.ItemRef_FullName...

Whenever I run the following criteria on my ODBC SQL connection, Access closes with the error "Access has stopped working". If I run the same query on a local database, it works fine. If I run the full query without that criteria on my ODBC connection, it works fine as well. Only with this code...

I think I may have been going about this the wrong way, so I'll see what you all think would be best. I need to make a system that tracks the time required to make a part, as well as a way to check the current status/location in our warehouse. Additionally, it needs to be an easy to use...

I am trying to put together an advanced query, but can't figure out how. I need to pull data from 3 tables. Table A has Order Number and Part Number as entered by user. Table B has order information (eg. Company Name) Table C has the part information for each order line item I need to build a...

I need to make a button in a subform that tells the parent form to go to a new record. Any ideas?

OK, so I'll try to explain this the best I can. I have a table (Time Table) with the fields ID, EmpID, Part Number, Order Number, Start and Finish Time, EmpName, Location, and Quantity. I've developed a database that has a multi-item form showing all of the non-finished orders. These orders...