Results 1 to 4 of 4
  1. #1
    ATTHECROSS is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Posts
    14

    Why is my text box data gone when i re-open access?

    Hello -

    I have established unbound text boxes that I need to update with the current date time when I import data from the import button that I have created. Everything works just fine, but when I save and close Access and then open it back up the data is gone. Why won't it just stay in the text box with the value of when the table was last updated???



    Here is the code I am using as an on click event procedure:

    'Check to see when the tables where last modified
    Set db = CurrentDb
    Me.LstUdt.Value = CurrentDb.TableDefs("tP6_Activity_Data").Propertie s("LastUpdated").Value
    Set db = Nothing
    Exit Sub


    Thanks for the help

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    If it's unbound, where do you expect it to find the value? You can put that code in the current event of the form to repopulate it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    ATTHECROSS is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2017
    Posts
    14
    Just wanted to say thanks pbaldy! Your suggestion worked great! Take care and Merry Christmas!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help, and merry Christmas to you too!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 05-18-2016, 09:46 AM
  2. Replies: 7
    Last Post: 02-08-2014, 12:31 PM
  3. Replies: 1
    Last Post: 05-02-2013, 08:04 AM
  4. Change Text Box Data Source On Open Event
    By mcktigger in forum Programming
    Replies: 1
    Last Post: 01-18-2013, 12:24 PM
  5. Replies: 1
    Last Post: 11-15-2011, 07:26 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