This is exactly what I've been looking for! The best part of this video is the fact that there's no annoying voice talking over everything that's going on. Simply and to the point. Thank you!
@matiasromera330
4 жыл бұрын
I WAS TIRED OF SEARCHING FOR THE SOLUTION, AND YOU LEFT WITH A SHORT VIDEO AND WITHOUT DIALOGUE YOU EXPLAINED ME MORE THAN ANYONE, THANK YOU VERY MUCH FROM ARGENTINA!
@McNemo9198
5 жыл бұрын
Perfect. No unnecessary rambling like most tutorials just straight up answering the question given.
@pklovek
11 жыл бұрын
This is what I was looking for. Thank you and I like the style "Not talking!"
@victorubong9328
4 жыл бұрын
fantastic. i love the silent mode too, just "click", "click", "click"
@sanjaykhanna2246
4 жыл бұрын
Great job. I was looking for such help from the last two to three weeks. This video has solved the problem I was facing. Thanks to Setha for this commendable work.
@mundonemesis
6 жыл бұрын
Excelent, i was looking for this, thank you!
@nuthouse99
10 жыл бұрын
Excellent video -- simple straight-foward
@akky3002
13 жыл бұрын
Excellent tutorial....It was truly a magnificent source of learning.... will expect more such visuals...
@erickonga8857
7 жыл бұрын
hey man! you're the best! Thank you so much!
@gouthambanala6900
10 жыл бұрын
Thanks Brother u Helped me a lot... I was searching and got it
@arjunbirsingh4823
5 жыл бұрын
RIP SQL and PL/SQL. I literally cried on the way MS has complicated things. WTF.
@VlogenLekker
9 жыл бұрын
+Setha Iech the video helped a lot! However I can not get it to add entries if the Student ID is an Auto Number generated by Access. Do you know how to input entries this way if the first field is an Auto Number but I want to insert the rest of the details myself?
@syedmajidulhassan3059
8 жыл бұрын
Awesome, its really very helpful.
@cosamian
4 жыл бұрын
A very useful tutorial!
@kuil88
7 жыл бұрын
i have no idea what im doing wrong but its not working... using access 2013. Can you upload the complete file?
@Njmaaaa
10 жыл бұрын
You are awesome !
@abdullahahmed9626
9 жыл бұрын
hi .. this was so useful , but there is one problem that the code does not work if the primary is not a number !! do you have solution for that ?
@yeakleang
8 жыл бұрын
Wow Thanks u so much bro!!
@MetalinTheSky
5 жыл бұрын
I can't seem to get it to work, I have a form where I have two dropdown menus, one with their name (pulled from a clientstable) and the second one with a car model (pulled from cartable). I want my button to port the name to the cartable under the relevant car. The cartable is littered with several cars, and the clientstable got all customers stored inside of it.
@Azerty218
8 жыл бұрын
MERCI TRÈS BEAU TRAVAIL
@bintg7533
8 жыл бұрын
Hey great video just a problem i am having by following your code is that my data seems to be being entered into the data tables but is deleted soon after; would this be due to having an auto generated primary key in the table?
@iStabbedASwordfish
11 жыл бұрын
what if you are editing/updating to a table with 2 primary keys? will that mess up the tag or do i need to write the code for it to store both tags?
@srikanthjk9
10 жыл бұрын
Thanks that helped a lot.
@brianjstarnes
11 жыл бұрын
In order to the reflect changes in the actual table you have to close and reopen the table. It will not automatically refresh itself if it is opened concurrently with the form.
@arcza
8 жыл бұрын
Thank you!
@JahGuide1990
10 жыл бұрын
good man, thanks :)
@maheshgupte1495
6 жыл бұрын
Hi Thanks the code is working fine From resolved on Update part check the data type for Id it should be "Number" instead of Auto Number Code and procedure working great thanks for posing this video Thanks Once again Regards, Mahesh Kumar
@haiderabdullah7244
6 жыл бұрын
How nice if it works for you, but for me, I'm having trouble because even if I set the ID field as a number on the data type, is still showing some bugs and when I click the debug button the yellow arrow is pointed right to the ID txt field. And by the way is it not standard when the ID field is not automatically generating a number and you have to enter the ID into the ID field manually? I hope there is a tutorial that can show us how to clear an ID field with AUTONUMBER data type.
@radekjoachim
2 жыл бұрын
Thank you! This helped me a lot. If I add too many records, they are hidden in the bottom of the table. Is there any way to view the last record in the table after clicking the Add button?
@mieqool
10 жыл бұрын
Thanks alot ^ ^
@denysuhendraproject5251
3 жыл бұрын
thank you for the knowledge
@shaiba5095
9 жыл бұрын
Thanks, helpful.
@SAMARTBO
9 жыл бұрын
thanks, values ('"&LOL &"") i got this from you :)
@MetalinTheSky
5 жыл бұрын
And it adds the ID, instead of the name that I chose from the dropdown menu.
@MinhPham-pe6oz
7 жыл бұрын
Hello, I want to add a code that pop up a message said "All Fields must be Insert" when I click on "Add" button. How do I do that? When I click Add when all Fields are empty, it prompt an error said below "Run-time error '3134': Syntax error in INSERT INTO statement. And if I put in some code to force inserting data, it didn't do anything after all Fields are insert. Please help Thanks
@klimhazellumansoc721
3 жыл бұрын
Same situation plss help me if u find a solutionb
@snmailist1470
8 жыл бұрын
definitely quite but meaningful, thx's
@Denise7260
12 жыл бұрын
That's what I'm trying to do to. To be able to type on the form and it changes the table since the table is so hard to read.
@evasusantitanryadi7380
6 жыл бұрын
Thank You.
@UnixGuy32
12 жыл бұрын
Worked GREAT!!! BUT it did NOT send data to the actual table ?? Anything I am missing???
@mostafas2604
9 жыл бұрын
انا اشكرك thank you
@molonad
8 жыл бұрын
I did this guide exactly the same in my databaze and still iam getting 3920 error.. :-/ dont know why
@mrmbeautiquethebrand
4 жыл бұрын
Thanks a lot
@ShahTV
4 жыл бұрын
nice good job
@shubhamdimri1328
3 жыл бұрын
I want to create a button to add bulk data in my ms access form excel how can we do that please help
@ednaT1991
8 жыл бұрын
Would be nice to have some explanations...
@ITWIZARDOFFICIAL
3 жыл бұрын
Please how did you insert the apostrophe in cmd add table code
@mdwaliullah8725
4 жыл бұрын
Thanks 🌷🌷🌷
@saidlozi
10 жыл бұрын
thanks
@Abuhudayfa22
11 жыл бұрын
Hey setha, Can you help me with this. I want to enter data into different tables that have an ID. I have 2 tables first table ID_people has Autonumber second table ID_people has number I hope you understand me.
@perroflamer
5 жыл бұрын
Doesnt work on access 2016
@learnmsexcel6129
Жыл бұрын
setha after close and reopen this form not working plz help me
@princessmelissa7837
6 жыл бұрын
can you pls send me this .. i cant see
@sonamupadhyay2233
5 жыл бұрын
Sir hamara find next button nhi aa rha hai usse kaise laye plz bata dijiye
@hongli9249
10 жыл бұрын
the codes is not run in my case..why
@pakudon1544
11 жыл бұрын
Go to full screen to see what he's doing
@ohmaminhaji
9 жыл бұрын
hi Setha lech ,skilled work thanks a lot,but i need this code which u writteing on the database,plz publish this code ,can not see clearly ......
@SethaIech
9 жыл бұрын
You can see in the below link: Setha.info/ict-msaccess/47-ict-msaccess-0004.html
@christopherbernal7242
9 жыл бұрын
Setha Iech Can u give me a code for Select? like searching a Data from tables? Thank you
@VVT369
7 жыл бұрын
Hello, Thanks for this tutorial, I have one question. what if i want to add data to multiple rows of a table from same user form using same button.
@jurisblu2
5 жыл бұрын
@@SethaIech not working link!
@iannward123
10 жыл бұрын
Not bothered about voice, but can't get to work... I insert the following to the Add command: 'add data to table CurrentDb.Execute "INSERT INTO completedstores(branchID, branchnumber, town, keynumber, engineer, quantity, type) " & _ " VALUES (" & Me.txtID & ",'" & Me.txtBranch & "','" & Me.txtTown & "','" & Me.cboType & "','" & Me.txtEngineer & "','" & _ Me.txtQuantity & "'.'" & Me.txtKey & "')" 'refresh data in list on form frmCompletedSub.Form.Requery End Sub As copied key for key but when adding data and selecting the ADD button is all I get is a Run-time error '3346': Number of query values and destination fields are not the same. A newby would appreciate positive comments without insults.. Thankyou
@aimv8591
9 жыл бұрын
Iann Ward Hi, I had the same issue, had to change the first bit " VALUES (" & Me.txtID & ",'" & Me.txtBranch & "','" TO " VALUES ('" & Me.txtID & "','" & Me.txtBranch & "','" = Add in two ' at for the first parameter (>>'>'
@iStabbedASwordfish
9 жыл бұрын
Iann Ward After the insert into, count how many fields you have. Then after the Values, count how many you have. You have one more value than you do insert into. Add another insert into field or delete a Values.
@vivekanandareddy1134
6 жыл бұрын
HI BOSS GOOD TO SAY VERY NICE WHAT DO YOU DONE. :) I HAVE A SMALL ISSUE WITH COMBO BOX PROBLEM IS EXAMPLE: I HAVE DROPDOWN LIST VALUES OF ABC123,DEF456,GHI789 WHEN I TYPE IN COMBO BOX A IT SHOWING ABC123 IS IT OK BUT I NEED WHEN I TYPE 123 IN COMBO BOX IT IS NOT SHOWING AS A SUGGESTION PLEASE HELP
@TheWolf3791
10 жыл бұрын
By watching the video. He shows you exactly what to do. -_-
@ronaldmukute8557
8 жыл бұрын
how to insert a row between other rows
@terrancemarshall7957
7 жыл бұрын
Hi did you solve this mystery, I am curious myself?
@thaohanh2676
5 жыл бұрын
What about EDIT?
@kelvinr.219
3 жыл бұрын
Instructor goes over that in the continuation video. See below. Be Blessed kzitem.info/news/bejne/s59ov21jamhyeKQ
@jishnubora.5082
Жыл бұрын
কেনেকৈ report create কৰে তাৰ steps সমূহ
@steveu235
11 жыл бұрын
Not very helpful for me without narration but thanks anyways
@eonshade6297
Жыл бұрын
I am baffled by the SQL syntax. Edit: Try writing out the INSERT INTO command like this if you have some syntax errors or similar errors (This is just the way it should be written, not relating to the precise example in the video): CurrentDB.Execute "INSERT INTO tablename(field1, field2, [field name like this] , field3) " & _ " VALUES('" & Me.smtn1 & "','" & Me.smtn2 & "','" & Me.smtn3 & "','"& Me.smtn4 & "')"
@viktor250290
11 жыл бұрын
Anoying Clicks.
@iGetPuddy
11 жыл бұрын
What sucks is there IS NOT a voice but a damned annoying click throught this video! You can't freakin see the steps he/she is going through.
@cholmes100
11 жыл бұрын
how in the *($%# would anyone know what he is doing? click click click.... Can this guy talk?
Пікірлер: 84