1Setelah lama vakumisasi ( 😀 bahasa trend saat ini ) hehe.. Maksutnya setelah lama tidak menulis artikel di dalam blogiin, nah kali ini melanjutkan artikel sewaktu ada waktu agak sedikit longgar mengenai modifikasi Form Ms.Access sehingga lebih menarik dan efisien dengan minim code.

Access yang saya contohkan adalah sedikit tetapi mungkin anda bisa kembangkan kedepannya lebih menarik dan lebih bermanfaat untuk para pembaca semua. Dari Modifikasi Part I sudah di jelaskan pembuatan FORM nya. Untuk part II ini melanjutkan bagaimana list tersebut bisa menjadi sebuah inputan data yang menarik.

Berikut langkah-langkahnya :

  1. Kita modifikasi dari file yang telah kita buat pada PART I . Buka dalam mode desain form tersebut. Kemudian pada bagian textbox “kodebarang” dan propertisenya kita atur. Diantaranya link => always, Default value => *NEW*
    Seperti gambar dibawah ini.
    1 

    2

  2. Tampilan Form setelah dirubah seperti di bawah ini
    3
  3. Kemudian kita atur lagi ketika kita meng-click kode barang jika bagian kosong maka akan menambah data baru dan jika kodebarang sudah ada maka akan menjadi posisi edit data. Propertise kodebarang event On Click kita modifikasi. Click tombok ” … ” maka akan masuk kedalam jendela script. Tulis script seperti gambar dibawah.4

    5Penjelasan sedikit mengapa disana di bawah script else di sebutkan kodebarang, karena disesuaikan dengan field tabel anda masing-masing. Karena kebetulan saya menggunakan kodebarang.

    6

  4. Karena  kodebarang tidak menggunakan autonumber maka saya menambahkan default value dengan *NEW*

    7
  5. Oke beres dulu untuk masalah pertama.  Sekarang kita membuat form baru lagi dengan autoform dan modifikasi sendiri sesuai keinginan agar menarik. Form ini nantinya digunakan pada waktu anda meng-click kodebarang pada list tadi.
    8
    Pada gambar form diatas telah saya modifikasi dengan menambahkan tombol simpan secara wizard. Tampilan mode form sebagai berikut.
    9
    Modifikasi lagi form ini tambahkan sedikit script pada tombol simpan. Event => On Click10
    Script seperti di bawah ini.
    11
     Jika anda menggunakan wizard untuk tombol simpan anda cukup menambahkan code pada bagian
    =====> “DoCmd.Close acForm, “Form Barang”, acSaveYes” <=====
    Karena kode yang lain sudah otomatis ada ketika menggunakan wizard. Simpan form baru dibuat dengan nama “Form Barang”
  6. Nah selesai deh tugasnya. Untuk lebih jelasnya bisa mencoba mendownload dibawah ini.  http://goo.gl/GDHXAM
    Selamat Mencoba 😀
Modifikasi Form pada Ms.Access Part II

You May Also Like

35 thoughts on “Modifikasi Form pada Ms.Access Part II

  1. I as well as my guys happened to be examining the good tactics on your web blog then then developed a horrible feeling I never thanked you for those techniques. All the men were definitely as a result very interested to read through all of them and now have in actuality been taking advantage of them. Many thanks for actually being well accommodating and for selecting variety of impressive resources millions of individuals are really needing to learn about. My personal sincere regret for not expressing gratitude to you sooner.

  2. Thanks for every one of your hard work on this website. My niece delights in participating in internet research and it’s really easy to see why. I learn all about the lively mode you provide helpful suggestions by means of your website and in addition cause response from other ones about this point and my simple princess is certainly studying a lot. Take advantage of the rest of the new year. You are always carrying out a really good job.

  3. I really wanted to send a quick note so as to say thanks to you for these fantastic tips you are showing here. My particularly long internet lookup has finally been recognized with professional knowledge to share with my relatives. I would admit that many of us website visitors are very blessed to exist in a decent place with so many lovely individuals with beneficial tactics. I feel truly happy to have used the weblog and look forward to really more excellent times reading here. Thank you once more for everything.

  4. My wife and i were so delighted when Jordan could conclude his survey through the entire ideas he made using your web pages. It’s not at all simplistic to just continually be releasing techniques which often people today have been trying to sell. We really fully understand we’ve got the writer to give thanks to for this. These explanations you’ve made, the straightforward site navigation, the friendships you make it possible to foster – it is everything wonderful, and it’s really assisting our son in addition to the family feel that that concept is fun, which is tremendously serious. Thanks for everything!

  5. I would like to express my appreciation to this writer for rescuing me from such a crisis. Right after browsing through the internet and getting advice that were not helpful, I thought my entire life was well over. Existing without the presence of approaches to the difficulties you’ve fixed through your entire post is a crucial case, as well as the kind which might have in a wrong way damaged my career if I hadn’t come across your web site. Your main expertise and kindness in playing with all the pieces was very useful. I’m not sure what I would have done if I had not discovered such a thing like this. I can at this point look forward to my future. Thanks a lot so much for your expert and results-oriented help. I won’t hesitate to endorse your blog post to anyone who should receive direction on this area.

  6. A lot of thanks for your entire hard work on this blog. My aunt loves going through internet research and it’s obvious why. I notice all regarding the dynamic manner you provide both interesting and useful tactics through the blog and therefore boost contribution from other individuals about this content while my daughter is undoubtedly understanding so much. Take advantage of the remaining portion of the new year. Your carrying out a good job.

  7. I’m just commenting to let you know what a beneficial encounter my child encountered using your web page. She noticed several issues, with the inclusion of what it is like to possess a great teaching nature to make the others smoothly learn various problematic issues. You actually did more than my desires. I appreciate you for offering these interesting, trusted, revealing and in addition fun tips about the topic to Tanya.

  8. Thank you so much for providing individuals with an exceptionally pleasant chance to read from this site. It’s usually so awesome plus full of a great time for me and my office mates to visit your website really three times every week to find out the new items you have got. And indeed, we’re at all times impressed with your terrific solutions served by you. Some 4 ideas in this posting are unequivocally the simplest I have ever had.

  9. I want to express my appreciation to the writer just for rescuing me from such a incident. Because of surfing around through the the net and finding notions which were not beneficial, I figured my life was gone. Living devoid of the approaches to the problems you have solved as a result of this article is a serious case, and those which might have badly affected my entire career if I hadn’t noticed your blog post. That mastery and kindness in maneuvering all areas was very useful. I’m not sure what I would have done if I had not come across such a point like this. I am able to at this time relish my future. Thanks a lot so much for your reliable and sensible help. I will not think twice to propose your site to anyone who should receive direction about this situation.

  10. I抎 need to test with you here. Which is not something I normally do! I enjoy studying a submit that can make people think. Additionally, thanks for permitting me to remark!

  11. These days of austerity plus relative anxiety about taking on debt, most people balk up against the idea of having a credit card in order to make acquisition of merchandise or pay for a vacation, preferring, instead just to rely on the particular tried as well as trusted technique of making transaction – cash. However, in case you have the cash there to make the purchase in whole, then, paradoxically, this is the best time to be able to use the card for several motives.

  12. I simply desired to thank you so much once again. I’m not certain the things I might have achieved without those concepts documented by you about that area. Completely was the distressing case for me, nevertheless noticing your specialised approach you treated the issue forced me to jump over fulfillment. I’m just grateful for your support and as well , hope that you recognize what a powerful job you happen to be getting into educating many others by way of your web site. I know that you haven’t come across all of us.

  13. I wanted to send you the little remark so as to give many thanks again on your gorgeous information you’ve contributed above. This is quite remarkably generous of people like you to allow publicly exactly what a lot of people might have marketed for an ebook in making some profit for themselves, mostly since you might have tried it if you considered necessary. These inspiring ideas additionally served to become easy way to fully grasp other people online have the same dreams just like my own to know the truth much more on the subject of this matter. I’m sure there are millions of more pleasant moments ahead for folks who discover your website.

  14. My husband and i ended up being very fortunate when Edward could do his inquiry through the precious recommendations he made while using the web page. It is now and again perplexing to simply find yourself releasing tricks which often other folks have been trying to sell. Therefore we do understand we’ve got you to be grateful to for that. The type of explanations you made, the simple blog navigation, the friendships you make it easier to create – it is many unbelievable, and it’s really assisting our son and us consider that the idea is thrilling, which is incredibly serious. Thanks for everything!

  15. I happen to be commenting to let you know what a helpful encounter our child developed checking your web site. She mastered so many things, most notably what it’s like to possess a marvelous teaching mindset to let many more with no trouble master several impossible issues. You undoubtedly surpassed readers’ desires. Many thanks for giving the practical, healthy, edifying and also easy thoughts on the topic to Jane.

  16. Thanks so much for giving everyone remarkably special possiblity to read articles and blog posts from this web site. It’s always so excellent and as well , stuffed with amusement for me and my office colleagues to search your blog at the least 3 times weekly to learn the newest issues you will have. Of course, I am just actually amazed concerning the tremendous principles you serve. Selected 1 points in this post are certainly the finest we have all ever had.

  17. My husband and i felt very fulfilled that Peter managed to finish up his investigations with the ideas he came across out of your web page. It is now and again perplexing to just always be releasing secrets and techniques many people could have been selling. And we all figure out we need the writer to be grateful to for this. The entire explanations you made, the straightforward web site menu, the friendships you aid to create – it’s everything exceptional, and it’s really helping our son in addition to the family believe that that content is entertaining, and that is truly important. Many thanks for all!

  18. I just couldn’t depart your site before suggesting that I extremely enjoyed the standard information a person provide for your visitors? Is going to be back often to check up on new posts

  19. I truly wanted to write down a small word in order to express gratitude to you for all of the lovely tactics you are showing on this website. My incredibly long internet research has now been paid with good quality content to share with my contacts. I ‘d claim that we website visitors actually are extremely endowed to live in a decent network with many brilliant professionals with interesting strategies. I feel really lucky to have discovered your entire web site and look forward to so many more fabulous minutes reading here. Thanks a lot again for all the details.

  20. A lot of thanks for all of the hard work on this site. Kim enjoys setting aside time for research and it is easy to understand why. Many of us know all relating to the powerful manner you present powerful tips by means of your web site and therefore invigorate contribution from some other people on that subject and our favorite girl is now discovering a great deal. Take pleasure in the remaining portion of the year. You are always performing a powerful job.

  21. I simply wanted to appreciate you once again. I am not sure the things that I could possibly have tried in the absence of those thoughts shown by you on this question. It actually was a very terrifying matter in my circumstances, but witnessing a new skilled manner you treated it took me to weep for happiness. I’m thankful for your help and in addition pray you find out what an amazing job you are always providing educating men and women through the use of your site. More than likely you haven’t encountered all of us.

  22. I wish to point out my respect for your kind-heartedness giving support to folks that actually need guidance on this important subject matter. Your very own dedication to passing the message up and down had become particularly advantageous and has truly empowered others just like me to get to their targets. Your entire valuable advice can mean much a person like me and much more to my fellow workers. Thanks a lot; from each one of us.

  23. I simply wished to appreciate you again. I’m not certain the things that I would have carried out without the type of tips shared by you concerning that topic. This has been an absolute intimidating crisis in my view, but observing a new specialised tactic you solved it made me to leap for contentment. Now i’m happier for the work and pray you comprehend what a great job you were doing training many people using your websites. I am certain you haven’t encountered all of us.

  24. My husband and i have been very fortunate when Michael could conclude his research by way of the precious recommendations he obtained using your web pages. It’s not at all simplistic just to continually be giving away helpful hints that many men and women might have been trying to sell. And we do understand we have the writer to appreciate for that. All the illustrations you’ve made, the easy website menu, the friendships you will help to create – it is many unbelievable, and it’s making our son in addition to our family recognize that the concept is amusing, and that is tremendously important. Many thanks for the whole thing!

  25. A lot of thanks for all of your efforts on this site. My mom loves carrying out internet research and it’s really simple to grasp why. All of us hear all about the dynamic manner you produce important ideas via this website and even attract response from people about this situation plus our favorite girl is always being taught a great deal. Enjoy the remaining portion of the new year. You’re carrying out a glorious job.

  26. I want to show appreciation to the writer just for rescuing me from this particular challenge. Just after looking through the internet and meeting tips which are not productive, I was thinking my entire life was gone. Living devoid of the answers to the problems you’ve solved through this article is a crucial case, as well as the kind which may have in a wrong way affected my entire career if I had not discovered your website. That understanding and kindness in handling everything was precious. I’m not sure what I would have done if I hadn’t come across such a point like this. I’m able to at this point look ahead to my future. Thanks for your time so much for your reliable and result oriented guide. I will not hesitate to suggest the website to anyone who would like tips on this matter.

  27. I and also my guys have already been analyzing the great advice from your site and then at once I got a terrible feeling I never thanked you for those techniques. These young boys came warmed to learn them and now have surely been taking pleasure in these things. We appreciate you really being quite helpful as well as for deciding upon varieties of tremendous subject matter most people are really wanting to discover. My sincere regret for not expressing appreciation to you sooner.

  28. I precisely desired to thank you very much once more. I’m not certain what I would’ve created in the absence of these secrets shared by you about this question. It previously was the challenging issue in my position, nevertheless looking at this skilled style you processed it forced me to jump over gladness. I’m just thankful for the work and then believe you are aware of a powerful job you have been carrying out training the mediocre ones with the aid of your web page. Most likely you’ve never come across all of us.

  29. I must express some thanks to this writer for bailing me out of this particular setting. As a result of surfing around throughout the online world and seeing principles which were not pleasant, I assumed my entire life was done. Living devoid of the answers to the issues you have resolved through the blog post is a serious case, as well as ones which may have in a negative way damaged my career if I had not noticed your website. Your own personal capability and kindness in touching everything was valuable. I am not sure what I would have done if I had not come across such a subject like this. I’m able to now look ahead to my future. Thanks a lot so much for this skilled and result oriented help. I won’t think twice to propose your site to anyone who would like guidance about this subject matter.

  30. I want to show my thanks to this writer for rescuing me from this challenge. Just after looking out throughout the online world and obtaining solutions which were not productive, I figured my entire life was gone. Existing without the approaches to the issues you’ve solved through your main posting is a crucial case, as well as the ones that would have adversely affected my entire career if I had not discovered your web blog. Your own personal skills and kindness in taking care of everything was very helpful. I am not sure what I would’ve done if I had not discovered such a thing like this. It’s possible to at this point look ahead to my future. Thank you so much for the specialized and result oriented help. I won’t hesitate to recommend your blog post to any person who needs and wants assistance about this subject.

  31. Awsome submit as well as right to the idea. I am not sure if this is actually the best place to inquire about however would you individuals have any thoughts on where you’ll get a few ghost writers? Thx

Leave a Reply

Your email address will not be published.