DRAG & DROP Tutorial in Ms Access
9:00
Пікірлер
@antoniocarlosfuertes7810
@antoniocarlosfuertes7810 9 сағат бұрын
Sobrang galing mo Pre
@EdcelleJohnGulfan
@EdcelleJohnGulfan 2 сағат бұрын
Kunti lang Pre.
@jaysonkurtyka6186
@jaysonkurtyka6186 13 сағат бұрын
Thank you for showing the exact location for where to find the App Password(s). There is ALOT of documentation online that says click on Security and then click on App Password but skips the part where you have to go to 2-Step Verification and then scroll down so it is easy to be confused. Thanks again!
@nicemedia1
@nicemedia1 Күн бұрын
Hello Sir and thanks for your nice videos. I have a big problem in first time open my database in other computer. Because bypass security automatically disable duo to trust location, so as result option meno and every things are visible..!! So I can't send my db to any one online, and I must go there and set the trust location manually and then everything works well. I want to the program works in any location without warning. Thanks.
@thatomogorosi5882
@thatomogorosi5882 Күн бұрын
radio buttons and checkbox are displaying numbers instead of their intended values when adding records using an input form how can I fix that
@iamankitkumar.
@iamankitkumar. 6 күн бұрын
Thanks
@EdcelleJohnGulfan
@EdcelleJohnGulfan 6 күн бұрын
You're welcome
@joseantoniojurado1958
@joseantoniojurado1958 7 күн бұрын
El problema es cuando dentro del subformulario son varios registros con la misma " ID " Puesto que guarda la elección pero al pasar al siguiente registro si cambias de categoría se borra el articulo anterior..!!!
@yossefavr
@yossefavr 8 күн бұрын
Why dont you show the result file?
@sergiomaia3029
@sergiomaia3029 8 күн бұрын
This video has the same problem of so many similar others: It shows how to export ONE table, but in general, users have many tables and need the code to do that.
@deepkumar3545
@deepkumar3545 8 күн бұрын
There is no video for export data from query in mutipale sheets
@deepkumar3545
@deepkumar3545 8 күн бұрын
Hello sir can you make a video export data into multiple excel sheet
@rudilbertoneitzke2810
@rudilbertoneitzke2810 8 күн бұрын
Best video in the world
@markdesens3046
@markdesens3046 9 күн бұрын
Hey Edcelle, I watched this video and I was thinking about mine. Do you have a video on how to recover a password?
@EdcelleJohnGulfan
@EdcelleJohnGulfan 9 күн бұрын
View the table using excel.
@markdesens3046
@markdesens3046 10 күн бұрын
Hi Edcelle, I'm Mark and I am wondering if you have a video on how you made your Developers login form? thanks.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 9 күн бұрын
Hi Mark, thanks for watching my videos. You can watch some parts of my Developer Control in my KZbin Shorts videos.
@markdesens3046
@markdesens3046 9 күн бұрын
@@EdcelleJohnGulfan I also watched the login part 1 and another video which gave me an idea of redoing my login on my database. Now my Director Loves it. Thanks.
@amitabha629
@amitabha629 10 күн бұрын
salamat po
@EdcelleJohnGulfan
@EdcelleJohnGulfan 9 күн бұрын
Maraming salamat din sa panonood.
@iacobradu2899
@iacobradu2899 12 күн бұрын
Mate, ur a light in the darkness. ty.
@agbedometi5940
@agbedometi5940 14 күн бұрын
Hello Sir, thank you for your videos which do us good. I have a problem regarding " RETURN ON A SEPARATE LINE WHEN WRITING A TEXT" . Please help me find a solution. Thank you for answering
@EdcelleJohnGulfan
@EdcelleJohnGulfan 14 күн бұрын
I'm glad to help you but can you elaborate this concern.
@agbedometi5940
@agbedometi5940 14 күн бұрын
@@EdcelleJohnGulfan Thank you for your attention to my request. By the way my concern is that when I write in the text box and I want to back to the line to write new text it doesn't do
@EdcelleJohnGulfan
@EdcelleJohnGulfan 13 күн бұрын
It's lock?
@agbedometi5940
@agbedometi5940 13 күн бұрын
@@EdcelleJohnGulfan yes yes
@EdcelleJohnGulfan
@EdcelleJohnGulfan 13 күн бұрын
In your On Current Event, type this... Me.AllowEdits.enabled=True
@iacobradu2899
@iacobradu2899 14 күн бұрын
Nice video mate. This procedure works to normal forms?
@EdcelleJohnGulfan
@EdcelleJohnGulfan 14 күн бұрын
Yes. Same procedure.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 14 күн бұрын
By the way, thanks for watching this video.
@Mechowski112
@Mechowski112 14 күн бұрын
thank you good man
@EdcelleJohnGulfan
@EdcelleJohnGulfan 14 күн бұрын
You're welcome and thank you also for watching this video.
@ruqayahn.k4645
@ruqayahn.k4645 14 күн бұрын
thank you 🌹
@EdcelleJohnGulfan
@EdcelleJohnGulfan 14 күн бұрын
You're welcome. Here's the latest one. kzbin.info/www/bejne/hJCtZHt5drl0Z8U
@ruqayahn.k4645
@ruqayahn.k4645 15 күн бұрын
thank you
@EdcelleJohnGulfan
@EdcelleJohnGulfan 14 күн бұрын
Welcome
@rincondeolocuilta
@rincondeolocuilta 15 күн бұрын
hello, why is the need to use a dummy box instead of using directly the search box. I think there is a benefit of doing that, but I don get it. I will appreciate your comments. Thanks in advance.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 15 күн бұрын
Nice question. ANSWER: You cannot type the whole word because the form will Automatically refresh every time you type the letter.
@venyabarinov6771
@venyabarinov6771 15 күн бұрын
Thank you very much!
@EdcelleJohnGulfan
@EdcelleJohnGulfan 15 күн бұрын
You are welcome
@user-bj4lp3fr1o
@user-bj4lp3fr1o 15 күн бұрын
I downloaded the accdb but Access says it is locked. I was able to open vba but it wants a password to view the code.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 15 күн бұрын
The password is in the video.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 15 күн бұрын
Please watch the video first.
@user-bj4lp3fr1o
@user-bj4lp3fr1o 14 күн бұрын
@@EdcelleJohnGulfan I find the password. Put the code in my program and I get transport error code 0x80040217. The server response was not available.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 13 күн бұрын
Have you change the email sender? You need to configure it. You need to have the App Password from gmail.
@user-bj4lp3fr1o
@user-bj4lp3fr1o 13 күн бұрын
@@EdcelleJohnGulfan Thanks for your help. I changed to the App password and that fixed it.
@NasirKhan-ex3ph
@NasirKhan-ex3ph 16 күн бұрын
can this application run online
@EdcelleJohnGulfan
@EdcelleJohnGulfan 16 күн бұрын
Only in local network
@eeeyaaah
@eeeyaaah 18 күн бұрын
Is there a way to put name with 2 Capitals in the correct format Like McDonald or to keep one like "de Silva" with a capital on the "de"
@EdcelleJohnGulfan
@EdcelleJohnGulfan 18 күн бұрын
Yes there's a way. I'll make a video on this.
@MicoLopez-l4f
@MicoLopez-l4f 20 күн бұрын
This code not working on me Private Sub Search_Change() Me.Dummytext = Me.Search.Text End Sub
@mrmir8279
@mrmir8279 20 күн бұрын
Hi, I need to create new project. Can I order it and what price will be (approximately)?
@EdcelleJohnGulfan
@EdcelleJohnGulfan 20 күн бұрын
Email me at [email protected]
@kamalsahu3324
@kamalsahu3324 23 күн бұрын
I have Excel 2021 but still the vstack function is not showing in it 😢
@EdcelleJohnGulfan
@EdcelleJohnGulfan 22 күн бұрын
It's available in office 365.
@ptzzycool
@ptzzycool 24 күн бұрын
This is another great video tutorial. It is very helpful indeed. I would like to request on how the pay can be calculated based on the time-in and time-out data. Thanks.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 23 күн бұрын
In part 4, i will include this one.
@ptzzycool
@ptzzycool 22 күн бұрын
@@EdcelleJohnGulfan Thanks. Looking forward to that one.
@emilythechef
@emilythechef 24 күн бұрын
Ooooooh, I very much liked this video, that is so cool! I want to use it but I don't need it, LOL. But I"ll put it in the back of my mind that it exists in case the need arises. I'll save it to my KZbin to reference later.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 24 күн бұрын
Thanks for watching this video.
@AhmadSar2
@AhmadSar2 24 күн бұрын
Hiiiiiiii
@EdcelleJohnGulfan
@EdcelleJohnGulfan 24 күн бұрын
Hello Ahmad!
@AhmadSar2
@AhmadSar2 24 күн бұрын
@@EdcelleJohnGulfan thanks.. you have a nice kid. May Allah keep you both happy and safe
@EdcelleJohnGulfan
@EdcelleJohnGulfan 13 күн бұрын
Thanks and it is highly appreciated.
@ericjhong.jagunos9698
@ericjhong.jagunos9698 25 күн бұрын
Oh nice, what about LoginQuery or LogIn Summary Form where the employee if they want to query or check their time in and time out per day?
@EdcelleJohnGulfan
@EdcelleJohnGulfan 25 күн бұрын
Maybe in Part 4.😁😁😁
@yawarabbas205
@yawarabbas205 25 күн бұрын
thanks for the valuable video. you teach in very simple way.
@EdcelleJohnGulfan
@EdcelleJohnGulfan 25 күн бұрын
Thanks for watching
@kamalhossain-hi5nj
@kamalhossain-hi5nj 26 күн бұрын
How to tbl - stock sold qty automaticly update (added) from tbl - sales qty. But tbl-sales qty will be update partially, not one many times and many sales date, please advice both table relationship and primary key. Thanks
@EdcelleJohnGulfan
@EdcelleJohnGulfan 26 күн бұрын
Hi. Use this. kzbin.info/www/bejne/mJKTdn2IeL2HhJo
@MuhammadHassan.3065
@MuhammadHassan.3065 27 күн бұрын
Sir can you please make long video of full course step by step or sequence your tutorial in another playlist. thank you sir! Your student from Pakistan
@EdcelleJohnGulfan
@EdcelleJohnGulfan 14 күн бұрын
Yes. I have already the plan.
@jopaz3780
@jopaz3780 29 күн бұрын
Thank you po sir...
@EdcelleJohnGulfan
@EdcelleJohnGulfan 29 күн бұрын
Thanks for watching.
@AdishiwotAzmerawHiwey
@AdishiwotAzmerawHiwey Ай бұрын
How to gate full tutorial of loan database system?10q instructor for teaching us#
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
10q 2 for watching this video. Your comment is highly appreciated.
@meme-ku1vs
@meme-ku1vs Ай бұрын
thankyou
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
You're welcome and thanks for watching this video.
@ekponoabasiakwaowo6236
@ekponoabasiakwaowo6236 Ай бұрын
Found this really helpful, thanks!
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
You're welcome and thanks for watching this video.
@RashidJaved
@RashidJaved Ай бұрын
Hello sir
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
Hi Sir.
@devonfernando1254
@devonfernando1254 Ай бұрын
Very useful. Thank you
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
You're welcome
@raedajailat9958
@raedajailat9958 Ай бұрын
Hi Ed , Thank you for your helpful videos. I have a question regarding the login file mentioned in one of your videos. After entering the username and password, the ribbon is hidden as expected. However, the 'File' tab in the ribbon remains accessible, allowing users to open the options menu. Could you please advise on how to hide the 'File' tab both before and after the login file is opened?
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
First of all, i would like to thank you for watching my video. Please check this short video to address your concern. kzbin.info_p1Ddn6DsjU?feature=share
@raedajailat9958
@raedajailat9958 Ай бұрын
@@EdcelleJohnGulfan Dear ED, Thank you for your Quick response; it is greatly appreciated. I am able to hide the toolbar ribbon successfully. However, upon login, Access displays the custom ribbon created by me, and the File tab appears, This allows users to open the Options menu from the File tab. I would like to prevent users from accessing or opening the Privacy Options. Best regards,
@niranjanreddy3620
@niranjanreddy3620 Ай бұрын
How to edit in sql after import
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
Check this video. kzbin.info/www/bejne/oX2vmKShi9tkfqc
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
By the way, thanks for watching!
@shabrinaalifah446
@shabrinaalifah446 Ай бұрын
Mohon bantuannya cara bikin pasword di form data barang dan form transaksi
@jopaz3780
@jopaz3780 Ай бұрын
Bakit mo delete yung tut sa coding ng send email sir?
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
Check mo ulit sir.
@jopaz3780
@jopaz3780 29 күн бұрын
@@EdcelleJohnGulfan My project kasi akung gignagawa sir, Vehicle registration query na pwd mag send ng email sa client once expired na yung rehistro ng sasakyan kaya lahat nga mga tut mo pina follow ko, napaka laking tulong isa kang alamat sir thank you so much sa mga tut mo.. Matagal na ako naka sub more videos like this po god bless..
@EdcelleJohnGulfan
@EdcelleJohnGulfan 13 күн бұрын
Maraming salamat sa panonood
@user-ry6us4ry9v
@user-ry6us4ry9v Ай бұрын
Very helpful vedio still on 2024.
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
Thanks for watching.
@RungeCarl
@RungeCarl Ай бұрын
Brilliant!!!
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
Thanks for watching carl.
@IanRoySegovia
@IanRoySegovia Ай бұрын
Pangmalakasan sir, sir ask po sana ako if paano po if around 5000 na po yung id at yung ibang tab po is ibang table na connected po via relationship sa employeeID at yung ibang tab ay many to many relationship po sa employeeID po. Patulong po sana sir.
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
Same concept parin sir. Dapat may common ground sila like ID number para sa parent and child link.
@IanRoySegovia
@IanRoySegovia Ай бұрын
@@EdcelleJohnGulfan thank you po sir. may video ka po ba for parent and child link? normalized nmn po yung tables with foreign key from employeeID table. at yung ibang table may foreign key din sa ibang table. if may video ka po sana para sa mga functions nato. 1. pwede po ba mag add ng search box at list box with view record functions para pwede po ma view lahat ng related records kasama sa tabs (katulad this video na instead employee id dropdown searchbox at list box po para sa result) 2. list box per tab para po sa records for add/edit delete/ na related po sa For. Ex. SalaryTable. . Please po. ito po kasi yung main functions na hinahanap ko sir edcelle
@EdcelleJohnGulfan
@EdcelleJohnGulfan 13 күн бұрын
Maybe this is what you want. Creating a subform. kzbin.info/www/bejne/ooqnY4x8gpiGoZI
@mohamedwado8363
@mohamedwado8363 Ай бұрын
thanks
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
Welcome
@bisyrim1030
@bisyrim1030 Ай бұрын
thanks
@EdcelleJohnGulfan
@EdcelleJohnGulfan Ай бұрын
Welcome