Landing Page last updated question

[gmazza76]

Good afternoon,

I have created a "landing page" in access that loads when the database is opened but have a question if possible.
I have a couple of buttons that run specific queries when they are pressed but want the data to appear on the "Landing Page" which I have done, but when the database is closed the dates are removed.

Is there a way I can get the dates to stay visible and not be cleared off?

thanks
Gavin

 

[JonXL]

You have to store them in a table. No other way about it. I've done similar with something as simple as a one-field table that I can just append or update the date on (can't recall which or if I've done both).

 

[gmazza76]

thanks @JonXL ,

Im fairly new to Access, but how would I amend my code in to show a title and date to the end of the code below and add it to a table called Updated
I would need this to show a name for the update ie CSV and the date/time.

Apologies as I would need to update this also on another code to align to a different name as well so it would be handy to see how you would do this.

The fields in the table are description and date.

Private Sub Command0_Click()
Dim answer As Integer
  answer = MsgBox("Have you logged onto the T Drive", vbQuestion + vbYesNo)
     If answer = vbYes Then
        Call ImportFiles
      Me.Text24 = Now()
    End If
End Sub

thanks in advance
Gavin

 

[Micron]

I'm going to assume that one can only be logged onto one drive at a time. If true, then this database must be on the T drive, otherwise one couldn't open it? If that is the case, then what's the point of the question in the code? If the issue is about drive letters (i.e. some are on T, some are on F etc.) then that still applies but you should be using UNC drive paths in your db connections? If none of that applies feel free to ignore that.

As for the append, perhaps after End If
CurrentDb.Execute "sql statement for appending goes here", dbFailOnError
or
CurrentDb.Execute "name of append query you created goes here", dbFailOnError