|
Free Lessons Courses Seminars |
TechHelp Fast Tips Templates |
Topic Index Forum ABCD |
|
||||||
|
|
Save Button By Richard Rost 
4 years ago
How to Add a Save Button to Your Access Forms Access automatically saves records to the underlying table whenever you move from record to record, or close a form. However, sometimes people want to click a save button to feel good about themselves. In this video, I'll show you how to create one. Suggested CourseSave RecordA few people have asked me why I use Form Operations > Refresh Form Data instead of Record Operations > Save Record. Honestly, it's because I forgot about Save Record. I never use the Command Button Wizard unless I'm teaching a class. I always just make a button and put one line of code in it: Me.Refresh. So that's why my brain was leaning towards Refresh Form Data. Both work exactly the same.
Keywordsaccess 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, save button, floppy disk button, dirty, dirty record, refresh, save record
IntroIn this video, I will show you how to add a Save button to your Microsoft Access forms, giving users the option to manually save their records. We will talk about how Access normally saves data automatically, identify when a record is "dirty," and step through creating a custom Save button using the command button wizard. You will also see how to choose an icon for your button, give it a meaningful name, and position it on your form for easier access.TranscriptWelcome to another Fast Tips video brought to you by accesslearningzone.com. I am your instructor, Richard Rost.In today's video, I am going to show you how to add a Save button to your Microsoft Access Forms. Microsoft Access automatically saves changes to your data when you move from record to record or if you close a form. For example, when I come in here and start editing this, notice a little pencil appears there. That means this record is dirty. It has not been saved yet. Records are only on the form and they have not been saved to the table underneath yet. But if I move from record to record, notice that pencil goes away. If I go back to the record, you can see the changes are made. If I come in here and delete that now, the record is dirty again, but if I close the form and then open it back up again, you can see the changes are saved. Some people like the reassurance that the record has been saved. Most other applications like Word or Excel, you have to click on the Save button to save your work. So you can put a Save button here on the form if you want to give those people confidence that they have saved their work. So how do we do that? Let's go into design view, come up here into your control box, grab a button, a command button, and just drop that anywhere on the form that you want. Then we are going to go to Form Operations, Refresh Form Data. This tells Access to save the data, save any changes to the table underneath. Click Next. Now, you can put the word Refresh on here, or you can put the word Save on here if you want. Or, if you want to put a picture of a floppy disk like most Save buttons, show all pictures and then come down to Save. Where are you? Right there - Save or Save Record. The joke, of course, is that kids today do not even know what a floppy disk is. They have a picture of a floppy disk kind of button meaning Save. Only those of us over 35 years old even know what that is. Next, give it a meaningful name. Command30 is not very meaningful. Let's call this SaveButton or SaveBTN or whatever you want. No spaces. It is going to be the name of the actual button and you do not really need that unless you get into VBA programming. That is not super important. Then hit Finish. There is my button and you can put it wherever you want. You can resize it. You can make it bigger or smaller. There is my Save button. If you want to put your own picture in there too, you can browse and select your own picture if you have an image that you would like to have in there. Save that form. Control-S, Save. Hit the Save button. I am going to close it and then reopen it. There we go. There is my Save button. If you make some changes and you want to manually click that Save button, click it. There you go. The form data is refreshed, the dirty pencil goes away, and everybody is happy. If you want to learn more cool stuff like this, come and check out my free Access Level 1 class. It is four hours long. It is absolutely free. It is on my website. It is on my YouTube channel. I look forward to seeing you there. How do you become a member? Click on the Join button below the video. After you click the Join button, you will see a list of all the different membership levels that are available, each with its own special perks. Silver members and up will get access to all of my extended cut TechHelp videos, one free beginner class each month, and more. Gold members get access to download all of the sample databases that I build in my TechHelp videos, plus my Code Vault where I keep tons of different functions that I use. You will also get a higher priority if you decide to submit any TechHelp questions to me, and you will get one free expert class each month after you finish the beginner series. Platinum members get all the previous perks, plus even higher priority for TechHelp questions, access to all of my full beginner courses for every subject, and one free developer class each month after you finish the expert classes. These are the full-length courses found on my website, not just for Access, too. I also teach Word, Excel, Visual Basic, and lots more. You can now become a Diamond Sponsor and have your name or company name listed on a sponsors page that will be shown in each video as long as you are a sponsor. You will get a shout out in the video and a link to your website or product in the text below the video and on my website. But do not worry, these free TechHelp videos are going to keep coming. As long as you keep watching them, I will keep making more, and they will always be free. QuizQ1. What does the pencil icon next to a record in Access indicate?A. The record is new and has not been saved to the table yet B. The record is read-only and cannot be edited C. The record is dirty and changes have not yet been saved D. The record contains invalid data Q2. How does Access save changes to form records by default? A. Only when the user clicks the Save button B. Automatically when moving from record to record or closing the form C. Only when the database is closed D. Only after running a macro Q3. Why might some users want a Save button on an Access Form? A. They like to switch databases frequently B. Other applications require explicit saving, providing reassurance C. It prevents all accidental changes D. It is required for Access to work Q4. What is the purpose of selecting Form Operations > Refresh Form Data when creating a Save button? A. To undo recent changes in the form B. To delete the current record C. To print the form data D. To save the current data and refresh the form Q5. What image is often used for the Save button in many programs? A. A printer icon B. A pencil icon C. A floppy disk icon D. An envelope icon Q6. What should you consider when naming your Save button in Access? A. Use only numbers and symbols for the name B. Give it a meaningful name without spaces C. Use the default name like Command30 D. The name is always required for all tasks Q7. What does clicking the Save button (created as shown in the video) do? A. It deletes the current record from the table B. It opens a new form window C. It refreshes form data and saves changes to the table D. It exports the data to Excel Q8. What benefit do Platinum members receive that Gold members do not? A. Becoming a Diamond Sponsor B. Access to only free videos C. Access to all full beginner courses for every subject and higher question priority D. Access to just one extended video per month Q9. Who can become a Diamond Sponsor and what is a main perk? A. Anyone, and their name or company is shown in each video and on a sponsors page B. Only Gold members, and they can submit unlimited questions C. Only students, and they receive free merchandise D. Anyone, but only their name appears on one video Q10. What assures viewers that TechHelp videos will remain available? A. They require a paid membership B. They are uploaded once a year C. They will always be free as long as viewers keep watching D. They are only available for a trial period Answers: 1-C; 2-B; 3-B; 4-D; 5-C; 6-B; 7-C; 8-C; 9-A; 10-C DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks. SummaryToday's video from Access Learning Zone covers how to add a Save button to your Microsoft Access forms. By default, Access automatically saves any changes you make to your data whenever you move to a different record or when you close the form. For example, if you start editing a record, you'll see a small pencil icon appear, which indicates that the record is 'dirty' - meaning the changes exist only on the form and have not been saved to the underlying table yet. However, as soon as you move to a different record or close the form, that pencil icon disappears and your changes are saved.Despite this automatic behavior, some users feel more comfortable having an explicit Save button, much like in Word or Excel, where you always have to save your work manually. If you want to provide users with the reassurance that their changes are saved, you can easily add such a button to your form. To do this, open your form in design view. Select the command button tool from your controls toolbox, then place it anywhere on your form. After that, use the option for 'Form Operations' and choose 'Refresh Form Data'. This option will save any changes to the records in the underlying table. When prompted, you can label the button either 'Refresh' or 'Save' - whichever you prefer. Alternatively, you can use a picture instead of text, such as the old floppy disk icon that has traditionally symbolized saving. It's a funny side note that many people today may not even recognize the floppy disk, but it remains a familiar icon for saving files. After adding the button, give it a meaningful name, such as SaveButton or SaveBTN, without spaces. This is more important if you plan to do any VBA programming, but having descriptive names generally helps keep things organized. Once you finish, you can re-size and reposition the button as needed. If you want a custom image for your button, you can browse your files and select any image you prefer. Remember to save your form once the button is in place. Now, when you reopen the form and make changes, you can simply click the new Save button to commit your edits, and the pencil icon indicating unsaved changes will vanish. This manual save option gives you extra peace of mind that your data has been stored. If you're interested in learning more tips like this, I encourage you to check out my free Access Level 1 class, which is about four hours long and available on both my website and YouTube channel. If you've wondered about becoming a member, you can find the Join button below the video. After joining, you'll see several different membership levels, each with its own set of perks. Silver members and higher get access to all of my extended cut TechHelp videos, plus one free beginner class every month and additional benefits. Gold members can download all of the sample databases I've created in my TechHelp videos and get access to my Code Vault, which is filled with useful functions. You'll also receive higher priority if you submit TechHelp questions and a free expert class each month after you complete the beginner series. Platinum members get everything from the previous levels, plus even higher priority for questions, full access to all of my beginner courses in every subject, and one free developer class each month after you finish the expert series. These are comprehensive courses found on my website for Access as well as Word, Excel, Visual Basic, and other topics. Best of all, the free TechHelp videos will always continue. As long as you keep watching, I'll keep making them available at no cost. You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends. Topic ListAdding a Save button to a Microsoft Access formUnderstanding when Access saves form data Identifying the "dirty" record indicator (pencil icon) Switching to design view in Access forms Inserting a command button onto a form Using Form Operations Refresh Form Data for saving Customizing the button label or icon (Save, floppy disk) Renaming the command button for clarity Resizing and positioning the Save button on the form Adding a custom image to a form button Testing the Save button functionality in Access |
||||||||||||||||
|
| |||
| Keywords: FastTips Access ave button, floppy disk button, dirty, dirty record, refresh, save record PermaLink Save Button in Microsoft Access |
