Recent content by voltie

but this one, doesnt search on Name, can someone help me:) it does only search in Surname and Surname in combination with Name, but noy only in Name..

i have fix it thanks, Me.Filter = "name Like ""*" & Me!Text** & "*"" AND surname Like ""*" & Me!Text** & "*"""

hi i got a little question, i have a search button for only searching on surname, i want to search on surname and name or name, so i want a combination so when i search for surname JOHN, and there are 10 Johns, i want to click also name, to filter again.. can some one help me, the code i...

i have fix it already thanks

Hi David, Just i have change it to normal access database, so there is no sql server etcetc anymore.. i have transfer all data to an acces database, and create all again, i think i have to do something with currentdb()? i have delete enterprisemanager,sql etc.

hi, i had an access database builed with adob connection/sql server.. now i have rebuild my database without sql/connection.. but i dont know how to fix change my login/to my database now... the login is searching for my sql/connection.. can someone help meplease to rewrite my existing...

hi, i got the next code.. DoCmd.OpenForm "klachten van client" forms![klachten van client].klant_id = Me.Klant_id but i want to add into this code the next : DoCmd.RunCommand acCmdRecordsGoToNew can someonehelp me? the first code + tell him to do that in a new record.

Re: the specified field "klant_id" could refer to more than one table listed in the F can you tell me please what code i have to use than..

the specified field "klant_id" could refer to more than one table listed in the FROm HI, i got a form KLANT and QUESTIONS.. when i search for KLANT and click on button ADD question i get the error.. the specified field "klant_id" could refer to more than one table listed in the FROm .. can...

i cant upload its 3mb...

its 3mb.. i cant upload it inhere..

or i get the error an expression in argument 6 has an invalid value..?

i got one other problem now.. when i add new client... which never asked a question or had an issue.. and i search for the new client.. than click on the button ADD QUESTION/ISSUE.. then i get an empty FORM so all textbox/labels are gone... but when i search for a client who already have had...

HEY BOB THANKS!! that was the problem.. thank you again for the CODE sory for my bad english:p

i got other records.. its filled with 10 clients.. is it possible that the problem is that when i load the form its on READ ONLY mode..?