Search results

strSQL = "SELECT *From Product" strWhere = " WHERE (((Products.TagNumber) Like Me!TagSearch)) AND ((Products.CategoryID)=Me!CategorySearch));" strSQL = strSQL & strWhere Me!SearchResult.RowSourceType = "Table/Query" Me!SearchResult.RowSource = strSQL...

I have created a database using the RecordSet function. So for example: Set History = db1.OpenRecordSet ("InventoryHistory") HOwever, previous to this function, I declared : dim History as Database and then: Set dbsCurrent = OpenDatabase("c:\fluid system...

I went through the whole forum and am still could not find a clear answer to making a history table. I want to store all the modifications made to the main Products table. So, whenever the user modifies the data on the Product forms, the previous data would be copied and stored into the...

I have been trying to create a form for searching through my product table. I wanted the user be able to choose whether he/she wants to limit the search by selecting spefic categories. So far, I created that kind of search with query tables and then the search result is displayed as a query...