Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Save Record with Me.Refresh
John Walker 
     
9 months ago
Just yesterday I watched a video (I think it was a "Fast Tips" video about saving changes to a record by using the Me.Refresh command in VBA. Now today, I can't find it anywhere. Can you tell me where I can find it?
Donald Blackwell  @Reply  
       
9 months ago
Hi John,

Here are two videos that discuss refresh:

Immediate Refresh
Refresh v Requery

Let me know if these don't cover what you're looking for and I'll dig deeper.


Don
Kevin Robertson  @Reply  
          
9 months ago
John Walker OP  @Reply  
     
9 months ago
Thank you Donald and Kevin. These videos do cover the Me.Refresh command for saving a record. But neither of these were the video that Google took me to yesterday. I think that video was classed as a "Fast Tip", and the title was something like "Save a Record." In the video, Richard demonstrated that if you add a new customer in the CustomerF and click on Orders, the customer record is not there. So, in the After Update event of the Customer name (I think, I'm just working from the weak instrument of my memory here) he puts the code line (Me.Refresh). This also works if he has just changed a name from say, Rost to Rostaaaaa. I would like to find that video, but I cannot locate it with any of the search tools on 599cd.com. Why can't I find it. I certainly did not dream of watching it.
Kevin Robertson  @Reply  
          
9 months ago
John Walker OP  @Reply  
     
9 months ago
Thanks Kevin, but no cigar. The "Save Button" video that you suggested is still not the one I watched yesterday. This is very weird. I know I watched it. It did demonstrate adding a new customer to CustomerF and then immediately clicking on the Order button and seeing that the new customer was not there. Then adding the code line: Me.Refresh, to make a new customer appear immediately when click on the Order button. However, it did NOT demonstrate the addition of a "Save" button. But I can't find that video today and apparently no one else can either. Isn't that strange?
Donald Blackwell  @Reply  
       
9 months ago
He does something similar with Fast Tips: Reports Not Updating where he shows how to make sure you get the most current data before opening an invoice report

John Walker OP  @Reply  
     
9 months ago
Thanks, Donald. You're right. This is a very similar video to the one I am searching for. But the one I watched yesterday was about how data was not updating in a form. It just amazes me that I cannot find that video. But please don't struggle with it any more. I have the idea. Thanks again to you, and to Kevin, for trying to locate it for me.
Alex Hedley  @Reply  
           
9 months ago
Is it not listed in your Views page?
Donald Lader  @Reply  
      
9 months ago
Requery in place.
John Walker OP  @Reply  
     
9 months ago
Alex, I don't know what my "Views" page is. This video came up on a Google search I did looking for why DoCmd.RunCommand acCmdSaveRecord was throwing an error (2406). So I watched Richard's now unfindable video from the Google hit. I should have saved the URL but I figured I could get back to it by a Google search. Fat chance of that!
And Donald, yes I have seen the Requery In Place video and it does have valuable info, but it's not the video I saw yesterday. And, Yes, it was a Richard Rost video. In fact, the first thing he showed was how adding letters to his last name did not get saved when he went to the orders form.
But really, fellows, don't bother with this any more. Maybe some day Google will show it to me again in some totally unrelated search.
Jeffrey Kraft  @Reply  
      
9 months ago
If you watched it on this site it would be in Views.  And if on YouTube the video would be in the History unless you cleared it.
Donald Lader  @Reply  
      
9 months ago
I believe you may be looking for Forms Not Updating which is a Fast Tip.
Alex Hedley  @Reply  
           
9 months ago
Did you click on the blue link I posted?
John Walker OP  @Reply  
     
9 months ago
Alex Alex, I did not think to click on the blue link. Did not recognize it as a hyperlink, which I am used to seeing as blue underlined lower-case font. Also, I have since seen that in the Menu bar above the Access Learning Zone banner, there is a menu item named "Views". But, as Jeffry Kraft noted, the video that I watched will not be in Views because I did not watch it on this site. I watched it on YouTube after it came up in a Google search. And, unfortunately, because of a completely unrelated problem, I did have to delete all cookies and history from Google after the time that I had watched the video about using Me.Refresh to update forms. But it's okay. I know how to do it. I've used it. My form is working. No mas problemas!
John Walker OP  @Reply  
     
9 months ago
Donald Donald, the title you gave "Forms Not Updating" sounds like it might be the video I've been trying to find, but I have searched Google and still cannot find a Fast Tips by that name. Can you give me a link to it?
Donald Lader  @Reply  
      
9 months ago
You can find it on this site: https://599cd.com/ReportsNotUpdating
Donald Blackwell  @Reply  
       
9 months ago
John Glad you figured out what you needed.

That being said, on YouTube, you have a "Watch History" that keeps track of all the videos you've watched for the last 36-months (unless you've changed the settings or manually cleared your watch history).

On the left hand side of the YouTube screen, if you click the "You" icon, it will bring up any playlists you've saved, videos you've liked, anything you marked to watch later, and of course, your "Watch History"

You can also go exclusively to your Watch History by expanding the YouTube Menu (3 little lines to the left of the YouTube logo) and then choose Watch History under the You category.

Your Watch History reportedly is independent of browser cookies.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 7:31:34 AM. PLT: 0s