Search results

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...

Took a bit but I did as suggested and separated the two tables. Works great thank you for the help.

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.

Seems the attachment didn't work the first time, reattached. It will take a little bit for me to extract the tables/query before I can attach that.

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

cboItem is the unbound field I type into for the search, Transaction Item is the field that is supposed to be searched.

I've attached a sample of the database.

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...

Where would I add that line in my code? I tried both sections and when I compiled I got an error. I forgot to mention I am using Access 2007

So I've managed to use a search form that was posted on here but I am having a problem being able to search based on the displayed results of a combo box. I am trying to have a field search the second column of the combo box but I don't know the code to do so. To simplify the question here, is...

I tend to use the search a few times a week as I try finding existing threads for a problem I am experiencing then recreating a thread with the same topic.

Well my first idea is to add a column in the table that stored the types that would say BM2K, BM3K ect for each one this way I can make a group header that will put all like items together (if that makes any sense)

I think I get what you are saying, I need to have some form of common key that will tell access what to base the grouping option on, once I do that then I can do subtotals and an overall total at the end of the report.