Data Entry Form,Auto generate unique ID, Image Control, Upload&Delete Photo,Add/Search/Edit. VBA

Hello Friends! In this we will learn how to Auto generate Unique Reference ID for every new entry and how we can Upload ,Delete and save Image in specific folder by the name based on Unique ID.

For Unique ID generation:
Private Sub TextBox4_Change()
w = TextBox5.Value (Phone# in the UserForm)
z = TextBox4.Value (Name in the userform)

ComboBox2.Text = Left(z, 3) & Right(w, 3)
End Sub
-------------------------------------------------------------------------------------------------------------------------------------------------
Private Sub TextBox5_Change()
w = TextBox5.Value (Phone# in the UserForm)
z = TextBox4.Value (Name in the userform)

ComboBox2.Text = Left(z, 3) & Right(w, 3)
End Sub
-------------------------------------------------------------------------------------------------------------------------------------------------

my Previous Video on Data Entry Form-
Add/Update & Delete in Data Entry Form with List Box Control using VBA.

[noelgriffen]

Thank you yaar bohut prisan tha pic autofit keliye

[thambirajahsritharan]

Please make advance videos related to this topic series, using advance filters, report generation etc, and Thanks for sharing your knowledge with everyone

[sridharkrishnappanavanerth]

Please make advance videos related to this topic series, using advance filters, report generation etc.

[xbtheglobedenier]

Hi Can you please tell me, how to save the data base in separate drive instead of the same sheet?
Thank

[jitendramahapatra]

Sir basis to advanced vba course series wise upload kijiye please

[Fazwaans]

Thanks for sharing your knowledge with everyone, you did not enplane about the Unique ID, can u kindly upload video and enplane the unique id option. thanks

[rodriguekinda]

Hi mister. Thank you very much for this wonderful tutorial. how to automatically populate combobox1 and listbox1

[SantoshMore-xq]

userform me ak se jada photo upload Kar sakte hai kay sir

[noelgriffen]

Jese jese excel mein type krte hain wase wase hi formula bar mein show hota hain wase hi hame vba mein krta hain jiska effect excel mein Lana hain

[Veenu-yipc]

Auto generated unique id not shown in combobox

[umairsaeed]

Hi Sail,
Could you please tell me how to add option buttons for Yes or No selections in this user form?
I added two option buttons, it works perfectly fine when adding data (displays "Yes " or "No" according to the selection) but when try to edit data, it returns value -1 instead of "Yes" and 0 for "No".
Will you please guide me for the whole process along with my problem of returning value instead of text?
By the way thanks for easy interpretation for quick understanding.
Thanks and regards,
Umair

[KaranRaj-hwyr]

Hello sir, I work for purchase and sales department, there was a query about is there any possibility where we can use vba userform for when i change company name datavalidation should also change and show me

[chona]

How do you keep the listbox updated everytime you add or edit a data?

[noelgriffen]

Bhai excel mein formula bar mein je randam text effect hota hain wase hi vba mein kese karenge plz ek do din mein batow

[ChandanSingh-uuph]

Sir can we search the details of the image

[Veenu-yipc]

When I update date then 3 row also added above the table, I don't know what is the reason .can give any idea to resolve the problem.

[chandranathsil]

we did not add picture in some data but double click in list box, the previous picture is showing. how it to solve ???

[flackvanderdutch]

Can you please provide us with the google drive link ?

[mustafakoker]

Merhaba sakıncası yoksa kodları paylaşırmısın

[Babaloo]

Aap comments ka koi bhi reply nahi de rahe hai
Mujhe ek question puchhna hai jab data ko ADD kare to image agar blanck ho to add karne se pahale ek message aaye (validation lagana hai image par) "please upload image first" aisa ho sakta hai to please reply me