Hi, nice video. Just one thing: If you write the User_ID Uppercase or Lowercase is the same. You may login succesfully. How can we solve this, so the input in the field User_ID matches the text exactly as in the database?
wonderful video PK - Thank you - I have encountered two problems for clear button- 1) when I click the clear button it clears the text box 1, However, there is a single * in textbox 2 2) After clicking the clear button - there is one space after the cursor ni textbox 1 so even if I enter the correct name and password - I get a message invalid username as space is also considered - Please help me fix the issue - Thanks in advance
Dear P.K hope you are fine. Very useful. Can you guide me where we can take Advanced excel training and VBA Macro. Or someone give to Training on that. Please help me out.
Nice video sir, i have an issue while trying to attempt this. I am not able to add 2.8 Library as my reference. It will show "Name conflicts with existing module, project, or object library". Can you help me sir?
Hi pk project is owsome but please tell me if we want to open a password protected access database where I have store user details so how to do this task because we do not want to share it with anyone else and if we will not protect it with pass anyone can see the pass.
You can use developer tab in Excel 2007 or above version. Please watch below video, how to enable the developer tab- ruclips.net/video/q8AZ2TGbY7M/видео.html
Its good sir. ... . I have a task. pls pls help me sir. my people are working on different-different locations. everyday they fills a excel form and they sends me. i am planning to create a excel vba form(login form & requirement form) but i want store all database into my Access database. normally we can create vba form and connect with ms access which runs in same computer. but here problem is my people are working in different location...so i am looking online database storage. ms access or any other database which are free. in this scenario i am sharing same copy of excel vba file to all. they will open excel vba file then will log in & fill up requirement form and submit. once they submit their form they can see below their updated form row in below grid. like every location people will do same thing.. only i being admin, with admin login i can see all filled form. and i should have access to make changes. will this work. do we have any option online database. pls can you give me sample. ps sir. pls guide me sir Sir google form and Microsoft forms are not suitable for me. i want to use excel vba form as frontend interface and back end will be MS Access or any other.. please help me . do we have any online FREE database systems like access or ms sql..or any other so that we can able to connect our excel vba form to that database..
Sure, I will create the complete series of Outlook and Excel connectivity- You can watch below given videos wherein I have connected Outlook with Excel- ruclips.net/video/drttEdY6xDw/видео.html ruclips.net/video/aD-lo81I5C4/видео.html ruclips.net/video/A6tggcOV6ts/видео.html
Thank you Sharing video..Very nice explained ..keep up the good work..
Thanks for your valuable feedback
Fantastic job. Well explained. Thank you so much. Look forward have more videos to share with friends
Thanks for your valuable feedback
I' ve been eagerly waiting for this video, your method of teaching is out of the box.
Hope you enjoyed it!
Brilliant, keep the good work. Yes, for some people it is fast, but I guess your description fulfills every need.
Thanks for your valuable support and motivational words
Please upload more this type of videos using VBA and Ms access
amazing, nice tutorial
Thanks for your valuable feedback
Great thank you sir
Thanks for your valuable feedback
It's really very helpful
Thanks for your valuable feedback. Request you to please share this with your friends and colleagues
Definitely sir
Thanks, a lot for you good job.
Pleas, Don't stop and keep up in that application with excel and access
Thank you my best friend
Thanks for your valuable comments.
bro, well explained rdbms concept
Thanks for your valuable feedback
Good job bro
Thanks for your valuable feedback
I hope you can continue from here.
Great :)
Plz upload more video on vba access
Thanks a lot for this. One question: will it work in Microsoft Activex Data objects 6.1 library?
Hi, nice video. Just one thing: If you write the User_ID Uppercase or Lowercase is the same. You may login succesfully. How can we solve this, so the input in the field User_ID matches the text exactly as in the database?
Thank you, Pk! Do you have a tutorial on how to convert an excel to .exe with an activation key that works on one computer only? Thanks.
thank u PK: An Excel Expert
how do i link this to my data entry form
wonderful video PK - Thank you - I have encountered two problems for clear button-
1) when I click the clear button it clears the text box 1, However, there is a single * in textbox 2
2) After clicking the clear button - there is one space after the cursor ni textbox 1 so even if I enter the correct name and password - I get a message invalid username as space is also considered - Please help me fix the issue - Thanks in advance
Dear P.K hope you are fine. Very useful.
Can you guide me where we can take Advanced excel training and VBA Macro.
Or someone give to Training on that.
Please help me out.
Nice video sir, i have an issue while trying to attempt this. I am not able to add 2.8 Library as my reference. It will show "Name conflicts with existing module, project, or object library". Can you help me sir?
Sir, when I insert the user form in visual basic the error pop up class root not registered. How to solve this in window 7.
Why there is a debug when i run this code
“Syntax error in FROM clause” ?
Hi pk project is owsome but please tell me if we want to open a password protected access database where I have store user details so how to do this task because we do not want to share it with anyone else and if we will not protect it with pass anyone can see the pass.
Hi sir can you help me my personal project?
Excuse me which excel version has developer
You can use developer tab in Excel 2007 or above version.
Please watch below video, how to enable the developer tab-
ruclips.net/video/q8AZ2TGbY7M/видео.html
@@PKAnExcelExpert alright i got it!! thank you sir!
Its good sir. ... . I have a task. pls pls help me sir. my people are working on different-different locations. everyday they fills a excel form and they sends me. i am planning to create a excel vba form(login form & requirement form) but i want store all database into my Access database. normally we can create vba form and connect with ms access which runs in same computer. but here problem is my people are working in different location...so i am looking online database storage. ms access or any other database which are free. in this scenario i am sharing same copy of excel vba file to all. they will open excel vba file then will log in & fill up requirement form and submit. once they submit their form they can see below their updated form row in below grid. like every location people will do same thing.. only i being admin, with admin login i can see all filled form. and i should have access to make changes. will this work. do we have any option online database. pls can you give me sample. ps sir. pls guide me sir
Sir google form and Microsoft forms are not suitable for me.
i want to use excel vba form as frontend interface and back end will be MS Access or any other.. please help me . do we have any online FREE database systems like access or ms sql..or any other so that we can able to connect our excel vba form to that database..
I still don't understand what the excel was for...
How do I enter anything and turn it off in the "X" and I'm still on the page?
Mr. Create VBA exel connection for ms outlook
Sure, I will create the complete series of Outlook and Excel connectivity-
You can watch below given videos wherein I have connected Outlook with Excel-
ruclips.net/video/drttEdY6xDw/видео.html
ruclips.net/video/aD-lo81I5C4/видео.html
ruclips.net/video/A6tggcOV6ts/видео.html