Prompt user for drive letter

R

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?
 
S

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.
 
P

PieterLinden via AccessMonster.com

Rodney24 said:
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?
Click to expand...

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.
 
Top