File Download Anthony Ching 12/30/2008 3:31:01 AM I have a database table that contains a list of file (by user) that users need to download from the server to their notebook (connected through a wireless network). I wish to automate the process so that when the user click a button in the access application, the file can be downloaded. How can I do this using Access Form and VBA. Thanks. -- Anthony

Re: File Download Tom van Stiphout <tom7744.no.spam[ at ]cox.net> 12/30/2008 4:01:07 AM On Mon, 29 Dec 2008 19:31:01 -0800, Anthony Ching <AnthonyChing[ at ]discussions.microsoft.com> wrote: Use a recordset to loop over the records in the table. Then use the FileCopy statement to copy each file. -Tom. Microsoft Access MVP [Quoted Text] >I have a database table that contains a list of file (by user) that users >need to download from the server to their notebook (connected through a >wireless network). I wish to automate the process so that when the user click >a button in the access application, the file can be downloaded. How can I do >this using Access Form and VBA. > >Thanks.

Re: File Download Anthony Ching 12/31/2008 3:10:01 AM Thanks, much appreciated. -- Anthony "Tom van Stiphout" wrote: [Quoted Text] > On Mon, 29 Dec 2008 19:31:01 -0800, Anthony Ching > <AnthonyChing[ at ]discussions.microsoft.com> wrote: > > Use a recordset to loop over the records in the table. > Then use the FileCopy statement to copy each file. > > -Tom. > Microsoft Access MVP > > > >I have a database table that contains a list of file (by user) that users > >need to download from the server to their notebook (connected through a > >wireless network). I wish to automate the process so that when the user click > >a button in the access application, the file can be downloaded. How can I do > >this using Access Form and VBA. > > > >Thanks. >