Search results

hi arnelgp , thank you very much, it works pretty well. And I want to say that you are a very kind and very informative person. you and other experts gave me a big help to finish this database. thanks again all.....

hi, I would like to focus on data (date) field. this date is always a future date. when a customer book a tour, user enter details according to the customer said. my opinion is when the user enters the date if we can create another field in "QuadroGeneraleDiPrenotazioneF form" as END DATE or...

hi arnelgp, i was busy with my other works so I couldn't send any replies to you. the database is working so perfectly. thank you very much. your codes are perfect.I hope this post will helpful for those who search the same matter. I have a new suggestion to do this database which is, can I...

hey arnelgp,buongiornooo. I was waiting for your reply. thank you very much. yes great, i can manage the rest. now I'm going to make other reports. I will let you know once finished the work. thanks again have a nice day and a nice weekend. cheers...

hi, thank you very much for kindy pay attention to my request. here I attached the latest database.

hi arnelgp, sorry for bothering you always.the query, mask and all running perfectly. now I need, 01. As I said earlier, I want to apply commision percentage to every single customer. (like 25%,20%, 0%...etc) so is there any possibility we can add this values to the query? or we can make a new...

hi, can I delete these two fields shown by the attached JPEG

this is more than enough for me :) now I want is, I want to run a report and get printed.

woooooowwwwww grande arnelgp it is working finely. thank you so much. thumbs up for your work. I cant do this without you guys. thank you very much everyone, who spent their time to work on this.

Dear all, thank you very much for helping me on this matter. I thought to describe you all my needful to understand better. I’m working for a tourism company. So, we need a database to keep track our customers. I want a table which includes customer all details. ClienteID , Data (date) , Nome...

hi arnegp, sorry to bother you always. query form only works with date. other criteria no. it gives me only empty query result. thanks

hi,, thank you very much. i tryied to run query using search by name. it runs but it dosent show me the results.only empty query. i attached a printscreen too. thanks.

yes, it seems ok now. but we have another problem now. what is enter parameter value? pls refer JPEG thanks.

dear sir, i tried the codes given you. there is an error. pls refer attached JPEG. and thank you very much for looking on this matter.

main table contains : ClienteID Data Nome Cognome Paese Lingua Nave Durata Pick_Up Orario Codice_Operatore Telefono Posta_Electtronica Tour_Operator Tour_e_Escursioni Adulti Ragazzi Bambini Adulti_Totale Ragazzi_Totale Bambini_Totale Quota_Totale Commissioni Commissione Euro Netto Note...

can you pls modify the correct codes for me. thanks. so i can create a brand new query instead of modifying the old one and i modified the bracket error also after that i got an error. SELECT DiscoverMessinaCustomerT.Data, DiscoverMessinaCustomerT.Nome, DiscoverMessinaCustomerT.Cognome...

i deleted my old customersearchform and my customersearchquerytable . and pasted your codes in new query SQL form. there also an error. pls refer attach JPEG i think according to my relationship with two tables (refer 11 JPEG) there are two Tour_e_Escursioni

hi i attached my data base thanks

thanks for the advice. currently im following arnelgp steps. because I don't understand advance access techniques. I have only two months experience about access.

guys, something wrong somewhere . pls refer attachments and i have a error message : enter parameter value ? in query some fields are duplicated ( there are two columns ) i have a dout about this code , [Nave] Like "*" & [Forms]![CustomerSearchF]!txtPaese & "*") in my form i done have nave...