Solved

FILE LIST BOXES TO SHOW FILES CREATED AFTER A CERTAIN DATE

Posted on 2003-11-17
13
456 Views
Last Modified: 2010-05-01
I have a File List in my VB program called File1 and i have set it to show only files with extension .IDX

Unfortunatly, it brings up ALL files in that folder with that extension and I only want it to show files that have been created from 1 month ago to the present date.  Is there anyway this can be done?
0
Comment
Question by:ian1delap
  • 4
  • 4
  • 2
  • +2
13 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9764492
Nope.  You will have to define your own custom dialog box.

Anthony
0
 
LVL 1

Author Comment

by:ian1delap
ID: 9764918
This is a completly automated program that runs overnight so I dont want any message boxes or anything of the sort to interrupt the program.
0
 
LVL 9

Expert Comment

by:Dang123
ID: 9765167
ian1delap,
    You will need to make your own list. You can use the Dir() function to list the files and this link to check the file creation dates to decide if you want to work on the file or not.


http://www.geocities.com/SiliconValley/Lakes/6445/vb/025.html

Dang123

0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9765180
Than there is no need for a Form, alone a File List control or any controls for that matter.  You can put everything in a module and get your files in one of the following ways:

1. Using the File System Object.
2. Using the DIR function.

You will then need to filter out based on the extension and date.

Anthony
0
 
LVL 14

Expert Comment

by:aelatik
ID: 9765993
Put a listbox on your form and paste the following code :

Function SetList(Directory, Extension, Startdate As Date, EndDate As Date)
    Dim X
        X = Dir(Directory & Extension)
        While X <> ""
                If FileDateTime(Directory & X) > Startdate And FileDateTime(Directory & X) < EndDate Then
                        List1.AddItem X
                End If
            X = Dir()
        Wend
       
End Function

Private Sub Form_Load()
    SetList "c:\winnt\", "*.idx", Date - 30, Date
End Sub
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9768144
Again, if this is an automated program and there is no interface then there is no need for a form, let alone controls on the form.  If you need code to do this let me know.

Anthony
0
 
LVL 1

Author Comment

by:ian1delap
ID: 9777371
aelatik,
I have tried your code and it brings up no errors, it also doesnt bring up any files either.  That is the sort of idea I'm looking for though.
0
 
LVL 1

Author Comment

by:ian1delap
ID: 9777422
This may help a bit:

The program is designed to search for two different bits of text in each file and extract certain numbers from those files.

The program then goes through the files again searching for two other bits of text and again extracts ceratin text from those files.

It repeats this process several times, and in the end prints off a report of what it has NOT found.

The only problem is that it takes far too long to complete and it searches through every single file whereas, as explained above, I only want to check files from a month ago to the present date.

cheers
0
 
LVL 9

Expert Comment

by:Dang123
ID: 9779548
ian1delap,
    You could pick up a lot of speed by reading the files once and doing all your checking while you have the information in memory. And as I suggested above, using the Dir() would limit the file types. Thanks aelatik for pointing out FileDateTime to limit file age, I was not aware of that function, it would be easier that what my link suggested.

    The code posted by aelatik works fine for me. Keep in mind that as posted it looks in the "c:\winnt\" directory and files created after 00:00 in the morning are excluded (Date + Time in the call would make it to current time)

Dang123
0
 
LVL 1

Author Comment

by:ian1delap
ID: 9781646
I worked something out

It doesnt exclude any files, which in the long run, is a good thing, but it excludes searching those files.  I used the FileDateTime function which I already had in place and I used

If FileDateTime(details) < Now - 30 Then File1.ListIndex = File1.ListIndex + 1

Thanks for all your help anyway
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 9784339
Then please close this question.  Here is how:

Request a refund because you answered your own question (Refund/PAQ)
http://www.experts-exchange.com/help/closing.jsp#4

Thanks,
Anthony
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 9806105
PAQed, with points refunded (100)

Computer101
E-E Admin
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question