Search results

I have the following error and could not find any resources to help me here or in internet I am running a query which will sort a column of combinations and related fields based on user entered values. Since I did not know any other ways, I went in to query design view and in the criteria (of...

Thank you very much!! That solved it!

Thanks alot! That cleared up alot. Learned a bit of VB back in grade 10 but then its all about C and Java so I don't know how comparisons are done nor how values are called out in VBA. Thanks again and cheers (for now till I come up with another problem lol) Have a nice day! :D

Thats what I have on plate. The first option is assigned 0 and next one have 1 assigned to it. And the whole group frame name is 'optSearch' blnExactMatch = Me!optSearch '0 is the first one's assigned number blnExactMatch = (Me.optSearch=0) Which one of the above line would return a true or...

Thanks! But could you please let me know how to call them out? Eg, in a case statement (from the look of it, is it like this?) Dim blnExactMatch As Boolean If IsNull(optSearch) Then MsgBox "You must select one of the option boxes to define your search!" 'I assigned 0 as the first option...

Hello, I am fairly new to access designing. I have a function that starts like this Public Function GetResults(strPassed As String, blnExactMatch As Boolean) As String Now the blnExactMatch carries True/False. However, when I try to design two option boxes (1 which will carry true and...

Dear Sir/Madam, I am currently creating a database as part of an assignment. However, I have to do a search function (well its a big one but for now) where i get to choose a column from the list and then type the keyword, then it would return the search result to the my original input form. I...

thank you very much! that cleared up alot!!

Hello all, Sorry for being new and asking alot of questions. I see alot of helpful people here so hopefully someone might be able to help me out. I am a research student and during the upcoming semester, I have to scan newspaper articles (using OCR - they read the text and save as word...