[Off Topic] Access Question

Yahoo Archive
1
Wonderful - thanks Mark.



Have a Nice Day,



Dina Hieber

Vamco International, Inc.

Phone (412) 963-7100

Fax; (412) 963-7160



www.vamcointernational.com

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Tuesday, June 06, 2006 2:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [Off Topic] Access Question



> My other question is -- as soon as a File is created in Access can I have
> it create a folder on the network? Can I do this by creating a macro??
> What I am attempting to accomplish with this is - everytime I create a
> serial Number for a machine - someone needs to go to a directory on the
> network an create a folder where everyone stores information regarding
this
> job. I want the folder to automatically create it self when the S/N is
> assigned in access. This maybe wishful thinking but it is worth the
> question.

This is very doable. You will do it in a module and you can call the
function
from a form or a macro.

See http://www.techonth
<http://www.techonthenet.com/access/functions/file/mkdir.php>
enet.com/access/functions/file/mkdir.php

Mark W.





[Non-text portions of this message have been removed]
2
Hello Group,



I am doing some changes to an Access Database I wrote a lot of years ago.
I am hoping someone can answer this question for me.



I have a table with A Field Name Called "Link to Files" with a data type as
Hyperlink. Which this hyperlink works fine from the table but as soon as I
add this field to a Union Querry - the hyperlink no longer works in the
querry. It adds # before and after. Any ideas?



My other question is -- as soon as a File is created in Access can I have
it create a folder on the network? Can I do this by creating a macro??
What I am attempting to accomplish with this is - everytime I create a
serial Number for a machine - someone needs to go to a directory on the
network an create a folder where everyone stores information regarding this
job. I want the folder to automatically create it self when the S/N is
assigned in access. This maybe wishful thinking but it is worth the
question.



Have a Nice Day,



Dina Hieber

Vamco International, Inc.

Phone (412) 963-7100

Fax; (412) 963-7160



www.vamcointernational.com





[Non-text portions of this message have been removed]
3
> My other question is -- as soon as a File is created in Access can I have
> it create a folder on the network? Can I do this by creating a macro??
> What I am attempting to accomplish with this is - everytime I create a
> serial Number for a machine - someone needs to go to a directory on the
> network an create a folder where everyone stores information regarding this
> job. I want the folder to automatically create it self when the S/N is
> assigned in access. This maybe wishful thinking but it is worth the
> question.

This is very doable. You will do it in a module and you can call the function
from a form or a macro.

See http://www.techonthenet.com/access/functions/file/mkdir.php

Mark W.