Copy, Paste, Hide

[alex]

Hello all,

Using Access ’03…

I have some VBA code that copies an mdb from one directory to another;
e.g.:

FileCopy SourceFile, DestinationFile (where both are defined in
previous code)

When the file is copied to the destination, I’d like its attribute to
be hidden.

Can I do this in code?

Thanks,
alex

 

[Douglas J. Steele]

SetAttr "C:\Folder\File.mdb", GetAttr("C:\Folder\File.mdb") Or vbHidden

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Hello all,

Using Access ’03…

I have some VBA code that copies an mdb from one directory to another;
e.g.:

FileCopy SourceFile, DestinationFile (where both are defined in
previous code)

When the file is copied to the destination, I’d like its attribute to
be hidden.

Can I do this in code?

Thanks,
alex

 

[alex]

SetAttr "C:\Folder\File.mdb", GetAttr("C:\Folder\File.mdb") Or vbHidden

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)


Hello all,

Using Access ’03…

I have some VBA code that copies an mdb from one directory to another;
e.g.:

FileCopy SourceFile, DestinationFile (where both are defined in
previous code)

When the file is copied to the destination, I’d like its attribute to
be hidden.

Can I do this in code?

Thanks,
alex

Works perfectly Doug. Thanks for your help.
alex

 

[Douglas J. Steele]

Works perfectly Doug. Thanks for your help.

Of course, you realize that hidden files can be easily viewed by changing
the settings in Windows Explorer.

 

[alex]

Of course, you realize that hidden files can be easily viewed by changing
the settings in Windows Explorer.

I did know that. Most/all of my users have not changed that setting.
Besides, hiding the file is a nice-to-have; they'll be using it, but
not directly.
alex