DLOOKUP: If Search Id is not found, then add it as a new record.

[@iammai5404]

That's great! You're a genius

[@EdcelleJohnGulfan]

Thank you.

[@Jojosmith342]

all thumbs up for allowing us to download the program. Great help with the code. Thanks a lot Edcelle for your valuable knowledge.

[@EdcelleJohnGulfan]

You are welcome. Thanks for watching. Your comments are highly appreciated.

[@dbdata9836]

Great

[@EdcelleJohnGulfan]

Thanks man.

[@archiligogilashvili1739]

please show how to protect the program from distribution...

[@EdcelleJohnGulfan]

Yes sure. Thanks for watching.

[@alimoradi6664]

thank U Mr Gulfan

[@EdcelleJohnGulfan]

You are welcome. Thanks for watching.

[@Abdullah_Alhathloul]

Nice , thank you

[@EdcelleJohnGulfan]

Thank you too

[@partner779]

Hello Mr John, I hope you be fine I'm thankfull of your great tutorials, I faced to a problem, my access database project hide or remove all forms, quires, reports after somedays automaticaly , just all the tables are remane with all records in !! how can i solve this problem? thank you

[@EdcelleJohnGulfan]

Maybe you have split the database. The table Will be separated from other objects.

[@partner779]

good idea, but I don't mind that I splited before!! it made me in troble! @@EdcelleJohnGulfan

[@santrehNgoding]

sir, how do you make a search report with multisearch and the results can be previewed and printed out?

[@EdcelleJohnGulfan]

Sample kzbin.info/www/bejne/d4G0h6Zpe9WYmLs

[@stephenbeswick2163]

Hi asked you you could do a video on access when you complete o from it will change colour say light blue to Green to state this form all fields have been completed could you please do a video on this for me I have users with poor eye sight this will help them when filling data in a form many thanks steve.

[@EdcelleJohnGulfan]

Sorry for late reply. I will create a video regarding this one. It's all about AFTER UPDATE FUNCTION.

[@maxcanispugnax4082]

Hi Gulfan. I repeated your step by step tutorial in a new db in Access 2007. Everything works except the last statement, " Else Me.txtResult = StrResult ". In the txtResult textbox, it does not return me the EmployeeName field present in the Employee table. Where is the problem? Thank you.

[@Jojosmith342]

can you do dlookup to show the specific record, not just the name ? thanks

[@EdcelleJohnGulfan]

Maybe this is what you mean. kzbin.info/www/bejne/m2K8mGeMps6NqNk kzbin.info/www/bejne/i6CYoYmVrLZnqcU