P
Phil Hellmuth
Is there VBA code that will allow me to test whether or not there's a
diskette in the A: drive? Thanks in advance.
diskette in the A: drive? Thanks in advance.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Daniel Pineault
Take a look at
http://www.ozgrid.com/forum/showthread.php?t=17435
it should be what you are looking for!
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
http://www.ozgrid.com/forum/showthread.php?t=17435
it should be what you are looking for!
--
Hope this helps,
Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
J
Jim Burke in Novi
The example he points you to is what you want, but I know when I declare my
FileSystemObject I don't use 'Dim FSO as Scripting.FileSystemObject', I just
use 'Dim FSO as FileSystemObject'. And like the comment in the example says,
you have to add a reference to the Script library via the VBA editor. On my
version of Access it's called Microsoft Script Host Object Model - it may
differ depending on the version you're using. If you haven't added a refernce
before, you go into the VBA editor, click Tools, then References, then scroll
down to where the scripting library name is and click on it - make sure the
check box is checked. Then do a compile.
FileSystemObject I don't use 'Dim FSO as Scripting.FileSystemObject', I just
use 'Dim FSO as FileSystemObject'. And like the comment in the example says,
you have to add a reference to the Script library via the VBA editor. On my
version of Access it's called Microsoft Script Host Object Model - it may
differ depending on the version you're using. If you haven't added a refernce
before, you go into the VBA editor, click Tools, then References, then scroll
down to where the scripting library name is and click on it - make sure the
check box is checked. Then do a compile.
B
Brendan Reynolds
Phil Hellmuth said:Is there VBA code that will allow me to test whether or not there's a
diskette in the A: drive? Thanks in advance.
Don't forget to first test whether the PC has an A: drive. These days many
don't. There's code to enumerate available drives at the following URL ...
http://www.mvps.org/access/api/api0003.htm