Results 1 to 7 of 7
  1. #1
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65

    Unhappy Refresh vs Restore

    I am trying to understand the difference between refresh and restore. One site I checked for a list of commands, it did not list Refresh as a stand a lone command.
    Restore to me means to bring back what was previously there while Refresh would update something to reflect the new information. Am I on the right track? My issue is basically when to use which one.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    Restore is a window method. It restores the window back to big if minimized.

    You refresh a form. I put messages in a text box while the program is running to tell status, but it wont do it immediatly because queries are running,
    so I must say me.refresh to get the message to appear.

  3. #3
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65
    Thanks for the quick response. I am trying to clean up some of my code and I am finding that I was using refresh but not remembering why.
    I thought "me." established a variable. I'm not at home so I am limited to internet for reference the site I referred to before does not even list "Me" as a command.

  4. #4
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65
    I've done some research on "Me". I believe I now understand the Keyword Me. If I am in the VB code window for a form then me is referring to that specific "Private Sub" like:
    Private Sub Form_Load()
    Me![lbltitle].Caption = DLookup("Proj_Ttl_ful_CAPs", "Proj_Info")
    End Sub
    Now I believe I fully understand. Me.Refresh basically up dates that specific form.
    Last edited by June7; 09-03-2014 at 12:42 PM.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    The Me keyword is an alias reference for the form or report that the code is behind.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Silvera is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    May 2013
    Location
    California
    Posts
    65
    Thanks for the concise explanation! Boy I understand now. Yours is the best explanation that I have seen this morning.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Me is faster than typing: Forms!MyAnnoyinglyLongFormName
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Restore Button
    By wolf in forum Access
    Replies: 8
    Last Post: 03-05-2013, 06:52 AM
  2. Start a from with restore
    By snoopy in forum Programming
    Replies: 8
    Last Post: 09-06-2012, 11:01 AM
  3. Replies: 14
    Last Post: 11-10-2011, 05:36 PM
  4. Restore menus?
    By rich in forum Access
    Replies: 2
    Last Post: 08-09-2011, 10:10 AM
  5. Access DB backup & restore
    By paulfr in forum Access
    Replies: 1
    Last Post: 09-09-2009, 04:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums