How to display last file opened after program is closed reopened

Question

1.00/5 (1 vote)

See more:

I have built a movie theater library in VB6. But keep forgetting which was the last movie watched. Want to make a text box that holds that information and automatically changes it when watching the next movie. All data for movie is held in DBGrid1. Which is movie Name, Description, play time and hard drive location. Want to add a new text box that shows which was the last movie viewed. Using VB6.0 on Windows 10 have been trying to figure this out for weeks. I believe it has to be saved differently from the DBGrid be able to exit program come back next day or so and in the text box show which was the last movie watched.

What I have tried:

Books I have don't address this so just been playing around with unknow acts to see what happens

Posted 2-Jun-23 13:16pm

Member 16020707

Updated 2-Jun-23 18:50pm

Dave Kreskowiak

v2

Add a Solution

Comments

Dave Kreskowiak 3-Jun-23 0:53am

Why does it sound like you're making the MASSIVE mistake of relying on controls to store your data instead of creating actual data classes and structures to hold the data and just using the controls to display and edit the data?

Controls are for displaying and editing data, not storing it!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2023-06-02T18:12:00

VB6? Seriously? A new VB6 project in 2023? You do realize it was superseded over 20 years ago by the .NET version?

Anyway ... You need to store the info somewhere, and presumably the DataGrid is backed up by a database of some form (but without any idea of your code, we can't tell). The way I'd do it is to add a new column to the DB table which holds a timestamp, and update that each time a movie was played.

Then when you want to see the last-watched movie (or the last ten in order even) you just query the DB and return the latest entry (or the last ten for example).

In an SQL database that's simple:

SQL

SELECT TOP 1 * FROM MyMoviesTable ORDER BY LastViewedAt DESC

But since we have no idea how your code works, we can't give you actual code to work with your app!