Search results for query: *

thank you i was try this before but its not work at all but i try now more carefull and its work

Hi i have a table with 10000 records and i want to find the multiply or the double records.Can anyone tell me how can i find this records without checking all the the records one by one thanks

they works very well all thank you very much my friend

now it works fine thank you but still i want to validate the form when there is no record i write a code that its look like this: Set qryDef = dbNm.QueryDefs("qrycustom") qryDef.SQL = strSQL & " " & strWhere & "" if qrycustom=0 then msgbox"no records...

i try it but now the msgbox appears even the fields are fill

i have made a form for searching and i took the code from the Thread702-563930 my code now its look like this: Private Sub cmdSearch_Click() Dim strSQL As String, strOrder As String, strWhere As String Dim dbNm As Database Dim qryDef As QueryDef Set dbNm = CurrentDb() strSQL =...

At last i fixed thank you for your help. Many greetings from Athens.[wink] George

Hi i have make a database with one table with nine fields. id,surname,firstname,address,city, zipcode,etc.. and i will like to have a search form wich when i type a part of the surname,firstname,city,address and zipcode the results will preview in mailing labels. Can anyone please tell me how...

Hi i have make a database with one table with nine fields. id,surname,firstname,address,city, zipcode,etc.. and i will like to have a search form wich when i type a part of the surname,firstname,city,address and zipcode the results will preview in mailing labels. Can anyone please tell me how...