Re: View contents of a folder

I was unable to find any examples in Help.

Would it be to much trouble to ask you for an example of an SQL statement
using the LOOP and DIR?

I want to be able to select the file from the listbox and have it overwrite
the backend with the selected file through code. I'm not so sure that the
other code you linked me to is what I'm looking for. I'm not really sure how
I'd go about programatically overwriting the backend with the selected file
from that code?

"Dale Fye" wrote:

> 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: ADODB Woes - Please Help Me!
    ... The DataBase isn't open, any ideas? ... The database WAS in a folder within my "My Documents" folder, ... connection open and populated the recordset) I use a statement like: ... only 1 record that should be returned by the SQL statement). ...
    (microsoft.public.vb.general.discussion)
  • 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)