Recent content by jaycie

strWhere = " WHERE (((Products.TagNumber) Like '" & Me!TagSearch & "')) AND ((Products.CategoryID)= & '"Me!CategorySearch & "'));" -------------------------------------------------------------------------------- Thanks for your response. But, I tried that statement, and the program kept on...

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

hehe, nevermind i got it working thanks so much!

how would i make a reference to DAO .. . is it an option in the menu? or is it just a module or what? Thanks, for your input, though.

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

wow, thanks, man. that is really helpful! i think i get it now. i m going to try to implement it n see what happens from there. thanks!

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