Access 2016 - Creating Forms - New Record Button - How To Add Delete Design and Modify a Form in MS

[@andresvoid4429]

7 years later and this video is still helpful🙏

[@ProfessorAdamMorgan]

Thanks, I appreciate it.

[@gracematalang5554]

Omggggg. So lucky I found ur videos Sir. I am really struggling in my Data Management subject and ur videos is a big help for meeeeee.thankkk youuuuu very muchhh

[@onezingerboxplease]

Cheers bro, im a CIT student in highschool and these are saving my life lmao

[@ProfessorAdamMorgan]

Hey Tadiwanashe, good luck in your class. Glad my videos are helping you out. Have a nice day.

[@XBbit0xKbronsit0x13X]

Your Tutorials are very simple.

[@ProfessorAdamMorgan]

I hope that you're learning from them. Thank you for watching and have a nice day.

[@XBbit0xKbronsit0x13X]

@@ProfessorAdamMorgan Thank you, but I already know most of that stuff. I'm looking for advanced tutorials. I have a form and two subforms. I need a button to cancel the new record from the main form and subforms. I know there is the Cancel function but only cancels from the main forms and not the subforms.

[@ProfessorAdamMorgan]

Typically I don't cover too many advanced topics due to the fact that most of my students are beginners. Hope that you're able to find what you're looking for.

[@ASCGR18]

Omg thank you so much! There’s so much video on internet but your ones are definitely the best!

[@ProfessorAdamMorgan]

Thanks Sofia, I'm glad you enjoyed this video. Have a great day and thank you for watching!

[@ryanwporter]

Thats a hell of a compliment man. *Smacks top of internet, you can fit so much video in this bad boy, but yours man, yours are definitely the best. lol Cheers.

[@ProfessorAdamMorgan]

Ha best comment ever!

[@aristidesjunior9195]

Really good explanation, thanks very much Professor and for sure my friends will also get good results watching your videos.

[@ProfessorAdamMorgan]

So nice of you and your friends to watch. I am glad you're learning, thanks!

[@QHealer]

Hi Prof. Morgan, your videos are sooo good because you have the gift of presenting with clarity and focus. I am so glad I have discovered your channel. I would be very grateful is you could teach us how to transform a normal field of a form, into a MEMO cell (if i can call it that..) so it can contain more than the 255 characters by default, and where I could key in lots of info. I also want to make it a variable size, and be in a place on the form where it does not affect the size of the other field in the same row.My form contains two columns of fields. I did something similar for a report but that was looong time ago and i forgot how i did it..It must have been an option in the dropdown menu of the field properties...

[@ProfessorAdamMorgan]

Hi QHealer, Thank you for the kind words, I appreciate it. To create a field that allows more than 255 characters, you will need to switch the field type to long text. I think the video below will get you going in the right direction: kzbin.info/www/bejne/mJaqoo2NhNxjpck Thanks for watching!

[@denysuhendraproject5251]

Thank you for the knowledge, have a great day !

[@ProfessorAdamMorgan]

Thank you for watching, Deny! Have a great day.

[@jamesfowler6343]

How were you able to get those Table Headings that appear in bold in the left column?

[@ProfessorAdamMorgan]

Hi James, Are you talking about the filed names on the left side of the form or the + signs on the left side of the table records?

[@luciano.nania11]

Ur the Goat thanks

[@kingming3948]

It is my homework in mylabit, and thanks for your help. - - - thanks from 2021

[@jamestobar4910]

adam , thanks for the tutorials, but i need your help , it is possible create wrap text in list box. i want 1 paragraphs but i cant find any tool for create. thanks for your help.

[@ProfessorAdamMorgan]

Hi David, I am not too sure if wrap text is an option in a list of choices. Unfortunately, Access doesn't have as many text/paragraph formatting options as other Office programs, since it's more strictly data focused. I'll look into this and post if I find anything.

[@jamestobar4910]

hi adam. the answer is 100% no choice it isn't possible. but I found other option and i really happy bucause works for me. i will create a video explain it the proceso very soon. thanks again for you answer.

[@ProfessorAdamMorgan]

Good to know, thanks David. I'll keep an eye out for your video.

[@xornedge8204]

My Access doesn't have the Design tab so i can't add the new fields into the databse. Is there another way of doing it? Or is there a way to add the missing tab to the program?

[@ProfessorAdamMorgan]

Hi Xornedge, Yes, you should be able to right click on any of the fields and in a new field that way. You can then assign the field name and data type using the Home Tab. I hope this helps you.

[@a64mtp1]

Is it possible to create new record, enter data, create another new record all from keystroke command? Switching mouse to add a new record and then back to kb for data entry is driving me buggy.

[@ProfessorAdamMorgan]

Hi David, You could set up a macro to do this. I don't have a video on that, but here is a link that should get you started. I hope it helps: support.microsoft.com/en-us/office/introduction-to-macros-a39c2a26-e745-4957-8d06-89e0b435aac3

[@isaiahmy8ko7moedwards14]

Help me!!!! I am only seeing one of the two records menu when viewing the form

[@javiercollado5533]

Wow this helped so much thanks

[@dhruvsoni4657]

I needed this for my practical exam thanks so much.

[@ProfessorAdamMorgan]

I'm glad it was helpful for you exam, MC Seed Guide. Thank you for watching!

[@YlmazDALKIRANscallion]

I will try it. Upvoted!

[@ProfessorAdamMorgan]

Thanks Yilmaz, I appreciate that. Good luck with your database.

[@microsecure2612]

if u can help me with this pls access database all fields shows as ( #Deleted ) knowing that this form was perfectly working and this error happened suddenly

[@RafaelBCastillo]

Thanks for the video! Straight to the point! Do you have videos on how to create graphs in MS ACCESS?

[@sareekashinde1404]

I created Navigational panel on which i have another subform which has command button - create new emp ,but when i click for creating new emp nothing haapens it does not create new emp. Button works good on form only but if i used on navigational panel it does not work.Please help me to understand why it does not work on navigation form where i have subform with new record button.Thanks

[@ProfessorAdamMorgan]

Hi Sareeka, Unfortunately it's a little difficult for me to figure out the problem here without seeing your actual database. I recommend removing the current new emp command button and adding it back in. Other than that, I am not sure what else can be done here.

[@KamrulHasan-fj4uz]

byDefault form fields will be in last new record, how to do that

[@Nathan-H]

In the form say you wanted to editthe field title from Publisher to author but keep the data i.e Pub-0001 can we do that? if so how

[@ProfessorAdamMorgan]

Hi Family Prepper, I am a little confused by the question. Which minute in the video are you referring to? If you provide more clarification, I can try to help out with this. Thank you for watching!

[@robertchua7876]

Prof. In the form, after filling in the data, I want new row below. How I do I do this. Thanks

[@sujayshil5830]

Sir, please make me understand how to creat both 'Save and Next' in one button in access form . For example, this button has in ms access's local contact template.

[@ProfessorAdamMorgan]

Hi Sujay, When you're in Form View, entering the data on your form, press Enter after you finish the last entry. Once you do that, it'll save and move to the next blank form. I hope this helps.

[@samerabusaleh7527]

How did you add the subform in data sheet view? Could you make changes to that?

[@ProfessorAdamMorgan]

Hi Samer, Yes, I can show you a video here all about subforms in detail including how to create and edit them. Please watch this video for more details: kzbin.info/www/bejne/roG0lZmQl9Z2h80

[@stephaniewhitley1613]

Hi Professor -- I've been looking for a solution to my problem. I have a simple table with an autonumber as the primary key. I created a data entry form off of this table. But when I try to add a record, it doesn't automatically populate the primary (autonumber) field, therefore, I have to type it in each time in order for it to be saved. I don't know how to code, so is there a simple way to add a record without typing in the next primary key (I wish to hide it on my form so users don't see it). Many thanks and hoping for a reply. Stephanie

[@zikarazafarullah2848]

Thanks.It helped me alot

[@rhizzadecierdo6884]

thank you for this educational vedio, looking for the next tutorial

[@ALEX-ut4pp]

do you know how to add the codes for add, delete, view , edit and create.

[@ProfessorAdamMorgan]

Hi Alex, Are you missing something that is displaying on my screen?

[@ALEX-ut4pp]

@@ProfessorAdamMorgan Hi, no i'm looking for vba codes to program commands for thos button.

[@ProfessorAdamMorgan]

Hi Alex, Sorry, but I don't use programming codes within Access. I found a website that can help you, so hopefully this points you in the right direction: support.office.com/en-gb/article/introduction-to-access-programming-92eb616b-3204-4121-9277-70649e33be4f

[@evaid4436]

Thank you, this really helped me!

[@ProfessorAdamMorgan]

Glad it helped! Thank you for watching!

[@Dubaidaytour]

Pro. Can you guide me how i can make my Enter key to save the data ??

[@ProfessorAdamMorgan]

Hi Ali, You do not need to save data changes in Access, as they're auto saved. You can use the Enter key to finalize data, but only if you're in the last column of the data. I hope this helps you.

[@calicojack556]

Excellent vid and very helpful.

[@greenorb189]

Thank you so much for this!

[@ProfessorAdamMorgan]

No problem, Green Orb. Thank you for watching!

[@khalidal-tamimi8519]

Hello Mr.Adam I have Questioned about the last record of each primary key Such As when I try to find an empty apartment in Apartment Table the access result appears the history of the apartment I.m Tring to find a query that shows me only the last record

[@ProfessorAdamMorgan]

Hi Khalid, I don't know of a way to show the last record within a query. You can always jump to the last record in a table by clicking the last record button in the navigation pane at the bottom of the table. I hope that is a helpful solution for you.

[@jamesandrew8894]

Hi there! Would anyone help me? I'm using MS Access 2010 then everytime I pop up my form once when I click it to pop up "yes" in property sheet, I have unavabled to click View Tab for Design View to edit again the form.

[@ProfessorAdamMorgan]

Hi Mikel, I haven't used 2010 in a while and I've never had this issue before. It's it's not a customized form, perhaps you should delete the form and just create a new one. I hope that helps!

[@atebamorris26]

Thank you - So Much 🙏🙏🙏🙏

[@tsywanicz8430]

I have relationships with other tables but It doesn't create subforms like yours does? I have a 1 table for ALL employees that has a one to one relationship with 10 other tables?

[@TYapril]

Very clearly illustrated!

[@mutupatterson7760]

Cheers that was helpful good explanation 👍

[@ProfessorAdamMorgan]

Hey I'm glad to hear that helped you out Mutu. Thanks for the comment and have a nice day.

[@balasubramanyamjavvajivenk9663]

How we can enable the new record option in MS access 2007 which is in disable? Can you give me Answer ASAP.

[@ProfessorAdamMorgan]

Hi Bala, You need to make sure you have the ability to edit the database. If you cannot edit it, try saving it to a new location and you should see full functionality return.

[@Decan198]

Question for you. I’m not familiar with Access, but I think I might be able to use it to make work easier. I have a large list of employees at the company I work for who routinely need paperwork filled out and submitted for events. Is it possible for me to build a database, select the names of the members attending the event and then have a macro transfer the information needed into each document? My concern is the docs I’m looking to have auto populated are word and pdf files. Is this possible? If so, do you have a video giving a walkthrough of how to create something like this?

[@adolfyuda3459]

its possible, all you need is to import them over mate, they are other people with videos on that here on youtube!

[@mmatlanyalepadima6596]

How do you add calculations to reports?

[@ProfessorAdamMorgan]

Hi Koketso, In reports, you need to be in the design view to do this. From there, click on the Design Tab, and look in the Controls group for the type of control you'd like to add. From there, position the pointer where you want the control to be on the report. then select the control, and display the property sheet. Switch to form view and add an expression using the = sign. From there, you can add calculations like =[Price]*.50 or to create a calculated field. Take a look at this video, because I think I covered it in here: kzbin.info/www/bejne/amial5JqqrWra9E

[@skullalpha1]

how do you delete field(s) in a form?

[@ProfessorAdamMorgan]

Hi Skullalpha1, You should be able to click on the field you'd like to delete, as well as the form data field, then press the delete key to remove them form the form.

[@venugopalramakanthan5047]

Hi can u help me to build form with submit for the different weekday working hour. After week I want to import to table

[@ProfessorAdamMorgan]

Hi Venugopal, You will need to add the fields for each week, I have a video covering field entry for tables below. Hopefully this helps you: kzbin.info/www/bejne/iWWnmYxsd8-NbtU

[@dilipraval6456]

How command button wizard is related to form

[@ProfessorAdamMorgan]

Hi Dilip, I need more information to help you here. Can you rewrite the question?

[@myanjels]

What if you add data and you can’t find it? What do I do?

[@moodyrcf]

is there a way incan use a button to add in subform?

[@ProfessorAdamMorgan]

Hi Raphael, I made a video covering this topic, please check out the link below: kzbin.info/www/bejne/roG0lZmQl9Z2h80

[@peggyboone6254]

If I want to add a form (say a pedigree), how can I create a form that looks actually like a peddigree?

[@ProfessorAdamMorgan]

Hi Peggy, You can only edit the field names and types for your forms. The style and look of the form cannot be customized very much. Access has mostly functionality features, not design features.

[@suegmur2314]

My sub form isn’t displayed, how do I get it to be displayed?

[@ProfessorAdamMorgan]

Hi Sue, I made a video on Subforms and how to use them. Here is a link to it, I hope it helps you out: kzbin.info/www/bejne/roG0lZmQl9Z2h80

[@vrushtimonani7350]

How to use length function in query?? In M S ACCESS 2007

[@ProfessorAdamMorgan]

Hi Vrushti, I am sorry but I don't have Access 2007, so I cannot make a video on this. I did find a page that can help you though, good luck! www.techonthenet.com/access/functions/string/len.php

[@vrushtimonani7350]

@@ProfessorAdamMorgan Thank you for your help.

[@ProfessorAdamMorgan]

No problem!

[@aroobaabid4791]

can u tell me what are table,fields,queries,record,form and referential integrity?

[@ProfessorAdamMorgan]

Hi Arooba, I explain all of these concepts in detail on my Access 2016 playlist. Here is a link to it, I hope that you find it helpful: kzbin.info/www/bejne/pqSve32vg9GFjrs Thanks for your comment!

[@frangkyezra3809]

idk why but I can't press the new blank (record) button to add a blank form

[@ProfessorAdamMorgan]

Hi Frangky, Try opening the table that references the form. Are you able to add records there? If not, then it may be because the database cannot be edited. I hope this helps.

[@sumitExplains]

AWESOME Sir

[@ProfessorAdamMorgan]

Thanks Sumit, I appreciate you watching my video. Have a nice day!

[@deepanathilinda5747]

Sir my database has relational table just i won to insert update delete how we do thats (using form and button plz

[@deepanathilinda5747]

Have a nice day

[@ProfessorAdamMorgan]

Hi Deepana, I am sorry, but I do not understand the question you're asking. If you can clarify, let me know. Have a nice day and thank you for watching!

[@theresamayfield]

Hi Adam, thanks for the great content! Super glad I found this site. By chance, how can I freeze the header row in Access? Thanks!

[@janderaedt9472]

Thx now it finally works

[@ProfessorAdamMorgan]

Great, glad this helped you out. Thanks for the comment Jan de Raedt, have a nice day!

[@rawanab6897]

Thank you!!!

[@ProfessorAdamMorgan]

No problem, R. Thank you for watching!

[@malindaredford3641]

Make the proper adjustment to the ServiceID field to make sure every record in this table is unique. Then save your changes to this table.

[@ProfessorAdamMorgan]

Hi Malinda, You will need to make sure your ServiceID field is the primary key. That'll make every record unique. I hope this helps, thanks for watching!

[@aroobaabid4791]

how to get more than one record?

[@ProfessorAdamMorgan]

Hi Arooba, At the bottom of your form, find the * button and click it. It will take you to a new record so that you can enter new data. Thanks for the comment and for watching the video.

[@elissaemmons1831]

Thank you for doing these! I would fail college if not for you!!

[@your_nightmar3]

Thank you

[@MamaLaaa18]

Thank you so much!!! I thought I was driving myself crazy and that the form was disappearing hahah I'm a dummy

[@ProfessorAdamMorgan]

No problem Mirella, thank you for watching! I'm glad this helped you out, good luck learning Access.

[@savanpatel2183]

where is the button man?

[@haroldbaize1361]

Uh... title says "New Record Button" so I expect you to show how to create a button on the form. Video didn't seem to have anything to do with "New Record Button".

[@ProfessorAdamMorgan]

Hi Harold, At the 3 minute mark, I explain the buttons at the bottom of each record. One of the buttons at the bottom navigation is called the New Record Button. That is what I am explaining in this video.

[@haroldbaize1361]

Okay. Just confusing to me because those buttons are already there, you're not creating them. I misinterpreted the title as meaning creating both the forms and the buttons.

[@ProfessorAdamMorgan]

Hi Harold, Got it, well then what are you looking to do with your form? I can try to make a video on it if you still need help.

[@haroldbaize1361]

Oh no, I don't need help. Figured it out. Just wanted to let you know that I found the title confusing. Thanks for your videos.

[@spudster2541]

You made this entirely too long and complicated. A simple macro tied to a button to generate a blank new record.

[@truthful8292]

May Allah guide you

[@ProfessorAdamMorgan]

Thank you for watching Truthful. Have a nice day.