First off I am using Access 2003 database on Access 2007
I'm not quite show how to explain the problem I have been having lately. Basically I am trying to take two records from one table and sum the quantity field in them to display the information on a different table. I.E. table one has...
The second one, there area few records with the same WorkOrderID but the actual details vary per line. For example I have only 26 ID's but have well over 4,000 records.
I am doing this in Access 2007.
I'm having an issue trying to move between records on a set form. The form is linked to a table where each order is created has multiple lines to it. When I try using the buttons I made to move between the records I view duplicate records until I finally get to a...
My department is trying to get away from using Excel reports as Access fills in the data we need and is much easier to generate reports. I've got the lay out but I wasn't sure if it was possible to replicate the design, figured I'd put it out there since someone said almost anything is possible...
Attached is the report and related tables. I am using 11/1/11 and 11/30/11 for the pop ups since to attach that form would have made the database even bigger.
I am using Access 2007 and am attempting to create a report similar to one I currently use in Excel. The issue I seem to be having is finding a way to have the data for each 'job' on the same line going from left to right lining up with the days of the month. I've attached a PDF of what I have...
Those links were very useful, thank you very much for all the assistance. Search form works like a dream and I've learned a few new tricks that'll keep me from asking the same questions again.
This may be a stupid question but once I remove the row source how am I supposed to change the control to a combo box since the control source remains the same (thank you so much for your patience)
The control source for the combo field is: Transaction Item
The row source for the field is: SELECT Inventory.ID, Inventory.Item, Inventory.Discontinued FROM Inventory;
And it is bound to column 1
I don't see anything that says Combo Box Control
When I get rid of the top line and modify the line you instructed I get a compile error "Compile error: Method or data member not found" and it highlights the .Column(1) in that string
I do have a numeric TransactionID field, but since I am trying to search similar products I can't use that (also there are hundreds of products listed so very hard know what ID to look up) I tried putting the provided string as follows
Private Sub cmdFilter_Click()
Dim strWhere As String...