Search results

Pbaldy, changing the bound column still didn't work... any other suggestions?

Maybe this is the problem? The search button on the NAICS code form just opens the query. How can I be sure that the query is taking the selection from the combo box?

My bad OHHH! I'm sorry... row source: SELECT [NAICS codes].[2007 NAICS US Codes], [NAICS codes].[2007 NAICS US Title], [NAICS codes].*, * FROM [NAICS codes]; column count: 2 bound column: 2

Code for NAICS query SQL for Query: SELECT Profiles.[Company Name], Profiles.[Company Contact Name], Profiles.[In what state is the firm incorporated?], Profiles.[List and describe each major product/service offered by your fir], Profiles.[List and describe each major product/service offered...

How do i do that? How do i resolve?

I Love You You dont understand how HAPPY I am!! Thank you so much... but one more problem: The Keyword search is working thanks to your help, but the NAICS code isnt - the difference for the NAICS code on is that I am using a combo box which is sourced from a table in the database. The search...

So far For the "criteria" in the "Primary NAICS Code Query" - I have: Like [Forms]![Primary NAICS Code Search]![NAICSlist] & "*" For the criteria in the "Product or Service Keyword" Query - I have: Like [Forms]![Keyword_search]![WhatKeyword] & "*" and for the "or" criteria I have: Like...

Yes, I realize that, but I need what to specifically put in the query criteria - EXACTLY as I am supposed to type it... any thoughts?

I am an intermediate user of Access and I am having difficulty using some forms that I have created that I am using separately as criteria for their respective queries. Two forms are currently set-up and these are the problems: 1. Form name: Primary NAICS Code Search This form contains one...