Search results

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:)

thanks for the reply i gotta have memProperyPhotoLink on the same page because i have all the information displayed in the forms. if the system works IngPropertType is empty and different product codes are entered and memProperyPhotoLink will self generate the fixed directory along with the...

thanks for the reply but is the code completed ori have to add in the name for this code...appreciate the reply and sorry for asking so much...^^

thanks for the reply i finally fixed it...appreciate :)

thanks for the reply i will work on it and let u know the result appreciate much ^^

I'm trying to setup the system so that when i input the ID of a product the photo link will update the directory containing the product ID. Say for example I input A0003 to the field IngPropertType the directory under memProperyPhotoLink will update to ...