Aap Pos jo project banaye hai usme jo invoice no 1 se start ho raha hai. Jo work sheet ka max value se aa raha hai. Mein chahta hu ki usme extra jeise short name and year v satme jurke aye. Exp - NDC/JPR/2021/001
You are great Sir ji, superb and awesome video, I have not seen before. Really you are professional and well experienced developer/programmer. Once again I salute you.
Hi, i want to keep the access file in share point online and make it multiuser. But, its not taking the path for it. Can you please guide on how to link the access file while its in sharepoint.
Excellent explanation ...so far i have seen many videos on VBA..the way you explain has no comparison...please let me know when you start the next batch...i want to join ...
Hi, I need your help please. I have 1000 employees data in excel file (1000 rows). I want to move these data into pdf files with a single click. I required 10 rows data in each single pdf file. There are approximately 1000 rows data, so 100 pdf file will automatically generate with single click. The name of pdf files will automatically create in serial like 1,2,3,4,...100.
Sure will amke the video on this saon. Tab tak aap ek dedicated video list view pe bana rakha hai and dusra school manager me bhi list view ka use kar rakha hai
Namaste sir , apke video ko dekh kar ham ak multi user software bana to liye , par ishe different ek se jada pc me chalaye kaishe ? Database ko kaha rakhe ? Kaishe ek se jada users ek shat is me kam paye ? Please sir bari maharbani hogi agar ap hame shikha de to . Nahi to ham shikh nehi shakte . Or hamare kam adhura raha jayaga . Please sir please
Waise maine bataya hai ki ye kaise kam karega. Aap ise kisi ek system pe rakhe database ko aur excel ko har system me dal de. Ye dhyan rakhe ki sabhi computer LAN se juda ho (Lan Networking)
Please check is access is installed in your system, if yes then go to vba open reference then select Microsoft access object library. If access is not available then you have to install ms office
Wow it's really Great, सर! आपके समझाने का तरीका बहुत बढ़िया है, मुझे आपकी सहायता चाहिए, क्या आप लाइव ऑनलाइन क्लास करवाते हैं, अगर ऐसा है तो मुझे अपना फोन नम्बर दे दीजिये।
Hello Sir! I regularly watch u r videos and try to learn some new. I like u r way of teaching. Now come to point, Sir i want to develop an inventory system of my Computer Workshop. For example my work flow is as follow: The Computer come to my workshop and I have to fill a form in which i write Emp ID, Name, Dept, Receiving date, Problem description, Device Type, Model and Serial No. When the pc is ready i update its status "WORKING..." to "READY" and ready Date. After that 2nd time update when the Employee collect the then i change the status from "READY" to "DISPATCHED" and dispatched Date. And want some filter i.e Emp ID, Status etc. Can you help me in this. I am very grateful to you.
अध्यापकजी सादर हरि स्मरण पूर्वक नमस्कार महोदयजी पारिवारिक सदस्यों का रिलेशनशिप सम्बन्ध के लिंक का कोई डायनोमीक हाईपर लिंक का विडियो बना हुवा हो तो लिंक भेजने की कृपा करे ।
See, If you want to search with exact name then you use same sql, Other wise there is other method to search, i will create a video on that. Keep watching and thank you for comment.
I have doveleped a clint management software but I can search by file no but not possible to remember so many file no I want to search by firm name also I am using ms access database and user form in ms Excel VBA and my software is multiuser plz help Search by firm name
सर आप Variables को explicitly क्युँ define नहि करते हो।कृपया ईसका benefits अौर drawback बतादिजिए अौर कौन कौन circumstance मे explicitly define करना चाहिए अौर किन अवस्थामे नहि यह भि बतादिजिए।
Thank good question. Basically mai Unnecessary jyada code ka line likhna nahi chahta isliye nahi likhta hun. Aur agar aap ise detail me janna hai to mere new channel fresher people's join kar sakte hai jahan maine abhi vba for beginners start kiya hai usme mai datatype Or variable ko explain karunga
Very Good Sir,
Bahut kuch naya learning k liye hai🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Dhanyavaad
Aap Pos jo project banaye hai usme jo invoice no 1 se start ho raha hai. Jo work sheet ka max value se aa raha hai.
Mein chahta hu ki usme extra jeise short name and year v satme jurke aye.
Exp - NDC/JPR/2021/001
Bohut aacha hai sach me sif
Good Work👌
Tell us how to use locked Access Database
From next onwards video will upload related to access database
very nice vedio
eagerly waiting for second part
Already uploaded watch on my channel
Fantastic video sir , nice 💥💥💥💥💥😎😎
Thank you🙏
Super useful..i hope there is an english version
Thank you but my English is not very good. But you can use caption in english
Good video keep up
Awesome video sir. I'm really excited for next video
Thank you🙏🙏
Hi sir ji
Apke video bahut hi achhe hai
Mai Grampanchayat ka sachiv hu,us k hisab se 1 vba banye plz
Kis tarah ka aap video chahte hai usme kya kya information honi chahiye
You are great Sir ji, superb and awesome video, I have not seen before. Really you are professional and well experienced developer/programmer. Once again I salute you.
Thank you for your support please keep watching you will learn a lots
@@vbAFun sure
Verry well explained sir thanks a lot
Thank you very much I appreciate🙏
Salute hai sir ji
Thank you 🙏❤
Hats off. Excellent Sir.👍
Thanks
Thanks a million times
Very informative video.
Amazing
Thanks you so much sir
Welcome
Todays Session was awesome, many doubts clear by Ajay Sir, i suggest to all of you join the channel and clear your doubts
Thank you very much for supporting us.
@@vbAFun aapne jo logic bataya tha, usko laga kar meri problem solve ho gayi, thanks a lot brother
Thank you very much and next Sunday I will show you some more Easy trick to do
Best tutorial, par sir NameID no 1 hi dikhata hai, par DB me next number save hota hai, aur ek request hai photo kaise dale plz ispe video banaye
Good 👍
Realy you are great. Sir, how to insert blank page thats like Ms Word, in which user can type
You mean you want insert new page in word using excel vba then what you want to do
Valuable
Dear sir,
I needs your support for customized service report excel software for customer multiple product details
Hi yes, we can provide you for your requirement please contact me on instagram or Facebook for further discussion
hello Sir ..... will this multiuser software will work if its hosted on a LAN server and then can multiple users work on it simultaneously ??
Yes
Sir ye approx 100 users use kar sakte hai kya? ya merging my use hoga
Yes
Thanks all ....
Sir mujhe chit fund cammety application banawana hai ban jayega
Awesome video 👏👏
Thank you🙏
Hi, i want to keep the access file in share point online and make it multiuser. But, its not taking the path for it. Can you please guide on how to link the access file while its in sharepoint.
I have never use SharePoint yet
@@vbAFun ohh ok. Then how it can be multi user if its only present in individual system.
With LAN connection
Combobox value save ho sakta hai kya sar
Aur yah IP number se bhi connect ho sakta hai
Aur report kaise nikale
yes, iske liye separate video aayega
Hi pls reply to me. Is there any second part to this multi user software in excel ??????
Yes ideo is uploaded please wat h this
th-cam.com/video/4jDu-AA1kfY/w-d-xo.html
Excellent explanation ...so far i have seen many videos on VBA..the way you explain has no comparison...please let me know when you start the next batch...i want to join ...
Thank you very much we are going to start next batch from tomorrow
Hello sir kay Excel 2013 me Access 2003 kam kar sakta hai
Yes karna chahiye
Thanks
Super
Thank you
Sir list box ko dynamic kaise bana skte hai search criteria se
Iske liye super advance data entry bala video dekhe
Hi, I need your help please.
I have 1000 employees data in excel file (1000 rows). I want to move these data into pdf files with a single click. I required 10 rows data in each single pdf file. There are approximately 1000 rows data, so 100 pdf file will automatically generate with single click. The name of pdf files will automatically create in serial like 1,2,3,4,...100.
Yes it can be done please message me on Instagram or join the channel membership for exclusive support, thank you for your comment
Bro yeh kaam kaha se milta hai tumko data entry wala
Sir apse request kiya tha..esse project mai ek baar or listview ke sath userform ke liye...
Sure will amke the video on this saon. Tab tak aap ek dedicated video list view pe bana rakha hai and dusra school manager me bhi list view ka use kar rakha hai
Namaste sir , apke video ko dekh kar ham ak multi user software bana to liye , par ishe different ek se jada pc me chalaye kaishe ? Database ko kaha rakhe ? Kaishe ek se jada users ek shat is me kam paye ? Please sir bari maharbani hogi agar ap hame shikha de to . Nahi to ham shikh nehi shakte . Or hamare kam adhura raha jayaga . Please sir please
Waise maine bataya hai ki ye kaise kam karega.
Aap ise kisi ek system pe rakhe database ko aur excel ko har system me dal de. Ye dhyan rakhe ki sabhi computer LAN se juda ho (Lan Networking)
Sir ke ham database ko kishi internet storage me rakh kar kam karshakte he ?
Maine check nahi kiya hai abhi, kabhi check karta hun to uske bad video bana dunga
I look forward to that day sir. And I will try to watch your video first . Thank you sir ji
Sir ji mujhe ek program banvana hai aap bana denge kya
Next video
Print operation
sir i dont have microsoft access 16.0 object library how can i download..please help me
Please check is access is installed in your system, if yes then go to vba open reference then select Microsoft access object library.
If access is not available then you have to install ms office
Wow it's really Great,
सर! आपके समझाने का तरीका बहुत बढ़िया है, मुझे आपकी सहायता चाहिए, क्या आप लाइव ऑनलाइन क्लास करवाते हैं, अगर ऐसा है तो मुझे अपना फोन नम्बर दे दीजिये।
Yes mai new batch start karne ja Raha hun jaldi hi announce karunga
@@vbAFun सर आपका मोबाइल नम्बर मिल जाये तो बड़ी कृपा होगी।
Please insta ya Facebook pe contact kijiye
@@vbAFun ठीक है , अपनी आईडी दीजिये।
Please check video description or channel about section
sir what is best option to store database securely of more than one lac students? excel or access?
Access
@@vbAFun so plz make video on moving database from excel to access, and start new series for access. thanks
Sir, having a run time error, " invalid SQL statement; expected 'DELETE', INSERT, PROCEDURE, SELECT, or UPDATE"
Check you have given select or not before starting sql
Sir m getting a same error and i m connecting access with excel. Y this sql error is showing? I m also using the same methodology which u explained
Please check the sql statement where i javed used and also check table name
What is Next Video (2nd Part) of "Multi User Data Entry Software in Excel | Excel Vba | Data Entry in Excel Userform"
Already Uploaded
sir aisa same project ms access database per banaiye jisme data ms access me save ho aur dynamic project ho
Thank you for your support. You can also make your project in access ny using this method
With my save button its shows compile error dont know why but its display expected function or variable.
You have given any extraword between the code please check
Hallo Sir,
In Excel 2007, error in ".Open = FilePath"
Also I do not have "Microsoft Access 16.0 Object Library"
Please suggest how could I get it.
Apke pass activeex library hona chahiye access ho ya na ho
@@vbAFun but what about the error? "Open = FilePath"
I think .open should be there
Hello Sir! I regularly watch u r videos and try to learn some new. I like u r way of teaching. Now come to point, Sir i want to develop an inventory system of my Computer Workshop. For example my work flow is as follow: The Computer come to my workshop and I have to fill a form in which i write Emp ID, Name, Dept, Receiving date, Problem description, Device Type, Model and Serial No.
When the pc is ready i update its status "WORKING..." to "READY" and ready Date. After that 2nd time update when the Employee collect the then i change the status from "READY" to "DISPATCHED" and dispatched Date. And want some filter i.e Emp ID, Status etc. Can you help me in this. I am very grateful to you.
Idea is good will make the video soon
sir compiler error: user-defined type not defined aa raha hai please help me out this
Kya apne reference enable kar liya hai jaisa maine video me bataya tha
R/sir your vba code is use for 32 bit and system is 64 bit how can made update it for use on 64 bit pl
Excel should be 32 bit, you can use any windows
in vba userform how to write code for evry new invoice number.
I have used method in various video please check also in this video I have given in new button
My computer office 2013 not working Access please solve sir
Please change the reference ActiveX library 6.1 se jo bhi apke system me available hai
While click on Run Then system gives Error "Expected Function or Variable" Please help in this regard
Please watch video and follow the procedure
अध्यापकजी सादर हरि स्मरण पूर्वक नमस्कार
महोदयजी पारिवारिक सदस्यों का रिलेशनशिप सम्बन्ध के लिंक का कोई डायनोमीक हाईपर लिंक का विडियो बना हुवा हो तो लिंक भेजने की कृपा करे ।
Mujhe thoda aur detaile bataye kis type ka application ke bare me bt kar rahe hai
Sir how to search by name when data base is ms access
See, If you want to search with exact name then you use same sql, Other wise there is other method to search, i will create a video on that. Keep watching and thank you for comment.
I have doveleped a clint management software but I can search by file no but not possible to remember so many file no I want to search by firm name also
I am using ms access database and user form in ms Excel VBA and my software is multiuser plz help
Search by firm name
I want to search by key words
Sir compile error aa rha h
Expected function or variable
Apne sayad reference ko enable nahin kiya hai please watch video and follow the procesure
@@vbAFun sir pahle wo hi kiya h
Ap vba ke top pe dekhiye kya option Exiplicit likha hua hai kya agar likha hua hai to delete kar dijiye
@@vbAFun thanx sir its resolved
Now getting run time error on clearfield
Could not find the specified object
Sir please can i get the video in english
Hi, will try to upload subtitle in english
Sir completed file chahiye price sir
Isme apko aur kya chahiye or contact me in my Facebook or Instagram
@@vbAFun sir multiuser software
contact number pls
Aap mujhe please messenger pe message kijiye ya mail kijiye i will contact you
@@vbAFun ok sir
uspe saved data ko selected print karne jaisa oftion banake dena hai sir
@@vbAFun sir uspe my students ka detail add karna aur selected student ka detail print nikalna padega
How to contact ?
You can join our channel. And also let me know what is the purpose on the mail
@@vbAFun what is your mail id??
Go on my channel click in about there is email
In excel 2007, .Open=file path error at thar point
Each Ctrl me.control not working
Use each ctrl in me. Control
Dwonload karna hai
Link is given in part 2
Hi Sir, please link download with us, thank you so much!
Sure will upload once one section has completed
@@vbAFun Thanks Sir, have a new day!!!
सर आप Variables को explicitly क्युँ define नहि करते हो।कृपया ईसका benefits अौर drawback बतादिजिए अौर कौन कौन circumstance मे explicitly define करना चाहिए अौर किन अवस्थामे नहि यह भि बतादिजिए।
Thank good question. Basically mai Unnecessary jyada code ka line likhna nahi chahta isliye nahi likhta hun. Aur agar aap ise detail me janna hai to mere new channel fresher people's join kar sakte hai jahan maine abhi vba for beginners start kiya hai usme mai datatype Or variable ko explain karunga
😍🤩
Thank you
Sir iska link
Please get the link in part 2
🙏💐🙏
BetteR then Bestbsirji
Kya aap mujhe Facebook ya Instagram pe msg kar sakte hai
Sir aapka mail id pl
Please send me msg on instagram
ok sir