Recent content by mikey222

hi guys i' ve recently created a product database for the company using access and i would like to know how most people distribute their work for the employees to use. I have the following questions Is most of the time all employees computer have access installed so they could use it from...

hi kiwi I'm using the code u provided above and i realise that the path would only update if i input characters to lngPropertTypeID from a form but not under the table. Thus, the path would not update when i paste a list of lngPropertTypeID to the form. Is there a way around it? Taken into...

thanks for the code it works perfectly now cheers

great it worked...thanks for the help...didnt pay enough attention on that configuration... cheers

everytime i open my database i have to activate the VB permission but its very tedious for the end users is there a way to bypass it cheers

jal thank you so much for trying to help out i checked out your example and i now understand what ya talking about i've changed all my check boxes to pull down menu with a true value in every of my criteria. Surprisingly it works... your solution is very handy too but it might takes extra...

now i tried using If Not IsNull(Me.filterpopup) Then strWhere = strWhere & "([popup] = " & True & ") AND " Else strWhere = strWhere & "([popup] = " & False & ") AND " End If If Not IsNull(Me.filterirregular) Then strWhere = strWhere &...

Thank you for replying... seems like its not solving the problem at all i've created a test sample if you want to take a look its a 2007 version... Private Sub cmdfilter_Click() Dim strFilterCriteria strFilterCriteria = "" strFilterCriteria = strFilterCriteria & "[irregular] = " &...

ok but exactly how do i use the command BOTH onto my example? when i check the box pop up the following command shows up ([popup] = True) AND ([rock] = False) AND so that is why a product with popup and rock feature would not show up unless i check both the boxes... emmm...

Thank you for replying i kinda understand what you trying to point me to but in terms of code i dont know how to command the system to perform with the criteria (BOTH) so it wont search from one level to the next appreciate the effort to help out ^^:)

anyone could kindly help out...thank you:):):)

First of all sorry for violating the rules in the forum and thank you those who have replied my post. I've followed husky's code and it works much better now. Now the system won't show the result if the product contains two or more TRUE values when one tick box is choosed from the search. eg...

thank you for the reply i've changed my code to If Me.filterirregular = True Then strWhere = strWhere & "([irregular] = True) AND " Else strWhere = strWhere & "([irregular] = False) AND " End If and it works but when i search the database with several...

Hi everyone i have a search engine and for my products with boolean yes/no options to filter the results. i currently use If Me.filterirregular = -1 Then strWhere = strWhere & "([irregular] = True) AND " ElseIf Me.filterirregular = 0 Then strWhere = strWhere &...

thank you once again for replying let me digest the intructions and let ya know the result... appreciate:)