Prompt user for drive letter

[Rodney24]

Currently I am using a macro to copy my primary tables to a specific drive
letter (USB flash drive) but if another USB device is plugged in while the
laptop it renumbers the drive letter. Is there a way to prompt the user to
select the correct drive letter?

 

[Steve Schapel]

Rodney,

Yes it is. For example, you can put an unbound textbox on the form from
which the macro is called, where the user can type in the drive letter of
the USB drive, and then refer to this textbox in the macro arguments.

 

[PieterLinden via AccessMonster.com]

Currently I am using a macro to copy my primary tables to a specific drive
letter (USB flash drive) but if another USB device is plugged in while the
laptop it renumbers the drive letter. Is there a way to prompt the user to
select the correct drive letter?

There's an API call on www.mvps.VBNet.org -- can't remember exactly what it
was, but I used it a couple of years ago.

GetDriveType: Enumerate and Identify Available System Drives
API method to determine a system's installed drives and their type.

search for GetDriveType... and put it in its own module and you should be on
your way.

 

[Douglas J. Steele]

Randy's site is http://vbnet.mvps.org