Re: View contents of a folder

You can use the Dir function and create a loop to return all of the files in
a particular directory that meet a particular format, there is an example of
this in the Access Help. You could append these files to the listbox or
combo box RowSource, or write them to a table which could be used as the
RowSource for the control.

Or, you could use the BrowseFolder API call which will popup the Windows
Folder browser and let you select a file via that mechanism. You can read
about this and get the code to copy at
(http://www.mvps.org/access/api/api0002.htm). I usually use this method.

HTH
Dale


"kremesch" <kremesch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FFBB09B8-711F-4A05-814D-6240E69A444D@xxxxxxxxxxxxxxxx
> Is it possible to view the contents of a folder instead of a table?
> Against my advice, I have to have our database functioning over a wan, and
> we've had problems with previous databases due to the instability. So, as
> a
> precaution, I have the database back itself up with date and time added to
> the copies each time it opens, before any data is entered. This keeps
> several
> backup copies which I routinely clear out.
> Restoring isn't integrated into the database and I'd like to create an
> easy
> way to do it. What I want to do is be able to view the Folder containing a
> list of the backup files through a query (like a list box), so the most
> recent or closest to the most recent can be selected from a list. I
> thought
> of using something like:
>
> Dir("C:\FolderName\")
>
> but it only returns one filename instead of all the files in that folder.
>
> I may be way off on this, if there is a better way to go about it, I'd
> like
> to know. If not, is there an equivelant statement to the one above that
> will
> return all the files in that directory?
>
> Thanks in advance.


.

Relevant Pages

  • Re: View contents of a folder
    ... For example, if your backup files are located on your D drive, in the backup ... to loop through that directory looking for other files that match the ... allows you to copy the backup file over your backend database, ... >> Folder browser and let you select a file via that mechanism. ...
    (microsoft.public.access.queries)
  • Re: Is This Possible ... ? Yes - Upload images to an Access database
    ... It looks like your databases folder is outside the root of your web ... I created a database exactly as you said, the only change I made was to ... and underneath an 'upload' button and a 'view images' button. ... Dim con As New Data.OleDb.OleDbConnection ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Have database mismatch, can I move NTDS.dit and Exchange to new identical server?
    ... Check the physical location of the Winnt\NTDS\ folder. ... Check the permissions on the \Winnt\NTDS folder. ... as it may not be the database that is the ... MCSA + Exchange ...
    (microsoft.public.win2000.active_directory)
  • RE: Sharepoint Backup & Restore
    ... even you have moved the Sharepoint database to another location. ... You can delete the $NtUninstallxxxxxx$ folder to free up space. ... Perform an online backup of the Exchange 2003 Information Store to purge ...
    (microsoft.public.windows.server.sbs)
  • Re: Help - locked out of database
    ... IT checked all the permissions and everything seems to be ok. ... "Joan Wild" wrote: ... I have poured a year into this database - is there someway to recover this? ... You need, at minimum, modify permission on the folder. ...
    (microsoft.public.access.security)
Loading