Attaching a file folder to a job - 9.04.507A - SQL

Yahoo Archive
1
I think I got this tip from here.....I use f:\foldername\.\
Slash Dot Slash at the end of the folder name

Hth,
Linda

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Bethany Rye
Sent: July-05-12 3:16 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL



Thank, Brian. I have it mostly working. It's a little clunky but something
we can work with for now. Guess I missed the post last month.

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...<mailto:brye%40cignys.com>> brye@...<mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Brian Roberts
Sent: Thursday, July 05, 2012 11:13 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I just answered this last month... here you go for 9.05, should work in
9.04.

Brian.

------------

Yes, but not easily. It worked better in Vantage 6, its possible but a
multi-step process in 9.05.

Create a new Document Association with extension \ (yes, just a
backslash) and view command of: explorer.exe "&1"

Attach a single document in the folder you want - it will create a link
to eg X:\Stuff\whatever.PDF

In External File Reference, find that link (it will be the highest#) and
change the filename to X:\Stuff\

Now opening that attachment will open windows explorer right at that
folder.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bethany Rye
Sent: Thursday, July 05, 2012 11:03 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A -
SQL

Thanks for the suggestion. That would work if files were all in the
folder
at one time, but unfortunately, the folder I want to attach will be
holding
all kinds of files that will be added continuously throughout the life
of
the job and may have some added after the job finishes. What would be
ideal
is if the link could be to open the folder instead of just a file.

Now that I'm thinking about this, maybe what needs to happen is that the
folder is zipped and then if a file gets added to the folder, the person
then has to re-zip the folder. I might try this.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Vic Drecchio
Sent: Thursday, July 05, 2012 10:52 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A -
SQL

When I've needed to attach a dozen or so files to something, I zip them
into
one file and then attach.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Bethany Rye
Sent: Thursday, July 05, 2012 10:12 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a document
to
a job, such as an excel spreadsheet, but I cannot figure out how to
attach a
whole file folder to the job (not just one document). Has anyone done
this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...<mailto:brye%40cignys.com> <mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com> > brye@...<mailto:brye%40cignys.com> <mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data
within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of
this
data by any means to a foreign person, whether in the US or abroad,
without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be
reproduced
without written consent of CIGNYS. If you are not the intended recipient
or
believe that you may have received this document in error, please notify
the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date:
07/05/12

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date:
07/05/12

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
2
I am having difficulty with attachments. I know how to attach a document to
a job, such as an excel spreadsheet, but I cannot figure out how to attach a
whole file folder to the job (not just one document). Has anyone done this?
Can it be done? If so, how is it done?



Beth



Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...> brye@...



***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.





[Non-text portions of this message have been removed]
3
When I've needed to attach a dozen or so files to something, I zip them into
one file and then attach.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Bethany Rye
Sent: Thursday, July 05, 2012 10:12 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL





I am having difficulty with attachments. I know how to attach a document to
a job, such as an excel spreadsheet, but I cannot figure out how to attach a
whole file folder to the job (not just one document). Has anyone done this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@... <mailto:brye%40cignys.com> > brye@...
<mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12

[Non-text portions of this message have been removed]
4
Thanks for the suggestion. That would work if files were all in the folder
at one time, but unfortunately, the folder I want to attach will be holding
all kinds of files that will be added continuously throughout the life of
the job and may have some added after the job finishes. What would be ideal
is if the link could be to open the folder instead of just a file.



Now that I'm thinking about this, maybe what needs to happen is that the
folder is zipped and then if a file gets added to the folder, the person
then has to re-zip the folder. I might try this.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Vic Drecchio
Sent: Thursday, July 05, 2012 10:52 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL





When I've needed to attach a dozen or so files to something, I zip them into
one file and then attach.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Bethany Rye
Sent: Thursday, July 05, 2012 10:12 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a document to
a job, such as an excel spreadsheet, but I cannot figure out how to attach a
whole file folder to the job (not just one document). Has anyone done this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@... <mailto:brye%40cignys.com>
<mailto:brye%40cignys.com> > brye@... <mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
I just answered this last month... here you go for 9.05, should work in
9.04.

Brian.



------------



Yes, but not easily. It worked better in Vantage 6, its possible but a
multi-step process in 9.05.



Create a new Document Association with extension \ (yes, just a
backslash) and view command of: explorer.exe "&1"

Attach a single document in the folder you want - it will create a link
to eg X:\Stuff\whatever.PDF

In External File Reference, find that link (it will be the highest#) and
change the filename to X:\Stuff\



Now opening that attachment will open windows explorer right at that
folder.











From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Bethany Rye
Sent: Thursday, July 05, 2012 11:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A -
SQL





Thanks for the suggestion. That would work if files were all in the
folder
at one time, but unfortunately, the folder I want to attach will be
holding
all kinds of files that will be added continuously throughout the life
of
the job and may have some added after the job finishes. What would be
ideal
is if the link could be to open the folder instead of just a file.

Now that I'm thinking about this, maybe what needs to happen is that the
folder is zipped and then if a file gets added to the folder, the person
then has to re-zip the folder. I might try this.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Vic Drecchio
Sent: Thursday, July 05, 2012 10:52 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A -
SQL

When I've needed to attach a dozen or so files to something, I zip them
into
one file and then attach.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Bethany Rye
Sent: Thursday, July 05, 2012 10:12 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a document
to
a job, such as an excel spreadsheet, but I cannot figure out how to
attach a
whole file folder to the job (not just one document). Has anyone done
this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@... <mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com> > brye@... <mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data
within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of
this
data by any means to a foreign person, whether in the US or abroad,
without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be
reproduced
without written consent of CIGNYS. If you are not the intended recipient
or
believe that you may have received this document in error, please notify
the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date:
07/05/12

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date:
07/05/12

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
6
We have a button we added to Job Entry that will open a folder on the file server based on the job number. In our case, our job numbers and folder structure are similar so it works well for us. I don't know who wrote the code originally, maybe someone from the group here - it was done before I started.

Here's the main code:

Private Sub cmdViewDataFolder_Click(ByVal sender As Object, ByVal args As System.EventArgs)
' ** Place Event Handling Code Here **

on error resume next
Dim JobNum As String = oTrans.JobNum()
Dim OrderNum As Int32 = Left((JobNum),5)
Dim OrderDir As Int32 = LEFT((OrderNum),2)
Process.Start("explorer", "(Server Name)\Job # (project specific)\"&(OrderDir)&"000\"&(OrderNum))

End Sub


Hope this helps a little.

Tim


--- In vantage@yahoogroups.com, "Bethany Rye" <brye@...> wrote:
>
> Thanks for the suggestion. That would work if files were all in the folder
> at one time, but unfortunately, the folder I want to attach will be holding
> all kinds of files that will be added continuously throughout the life of
> the job and may have some added after the job finishes. What would be ideal
> is if the link could be to open the folder instead of just a file.
>
>
>
> Now that I'm thinking about this, maybe what needs to happen is that the
> folder is zipped and then if a file gets added to the folder, the person
> then has to re-zip the folder. I might try this.
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Vic Drecchio
> Sent: Thursday, July 05, 2012 10:52 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL
>
>
>
>
>
> When I've needed to attach a dozen or so files to something, I zip them into
> one file and then attach.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Bethany Rye
> Sent: Thursday, July 05, 2012 10:12 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL
>
> I am having difficulty with attachments. I know how to attach a document to
> a job, such as an excel spreadsheet, but I cannot figure out how to attach a
> whole file folder to the job (not just one document). Has anyone done this?
> Can it be done? If so, how is it done?
>
> Beth
>
> Beth Rye
>
> IT Director
>
> CIGNYS
> Email: <mailto:brye@... <mailto:brye%40cignys.com>
> <mailto:brye%40cignys.com> > brye@... <mailto:brye%40cignys.com>
> <mailto:brye%40cignys.com>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data within
> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad, without
> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be reproduced
> without written consent of CIGNYS. If you are not the intended recipient or
> believe that you may have received this document in error, please notify the
> sender and delete this e-mail and any attachments immediately.
>
> [Non-text portions of this message have been removed]
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
7
Thank, Brian. I have it mostly working. It's a little clunky but something
we can work with for now. Guess I missed the post last month.



Beth



Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@...> brye@...



***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian Roberts
Sent: Thursday, July 05, 2012 11:13 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL





I just answered this last month... here you go for 9.05, should work in
9.04.

Brian.

------------

Yes, but not easily. It worked better in Vantage 6, its possible but a
multi-step process in 9.05.

Create a new Document Association with extension \ (yes, just a
backslash) and view command of: explorer.exe "&1"

Attach a single document in the folder you want - it will create a link
to eg X:\Stuff\whatever.PDF

In External File Reference, find that link (it will be the highest#) and
change the filename to X:\Stuff\

Now opening that attachment will open windows explorer right at that
folder.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Bethany Rye
Sent: Thursday, July 05, 2012 11:03 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A -
SQL

Thanks for the suggestion. That would work if files were all in the
folder
at one time, but unfortunately, the folder I want to attach will be
holding
all kinds of files that will be added continuously throughout the life
of
the job and may have some added after the job finishes. What would be
ideal
is if the link could be to open the folder instead of just a file.

Now that I'm thinking about this, maybe what needs to happen is that the
folder is zipped and then if a file gets added to the folder, the person
then has to re-zip the folder. I might try this.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Vic Drecchio
Sent: Thursday, July 05, 2012 10:52 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A -
SQL

When I've needed to attach a dozen or so files to something, I zip them
into
one file and then attach.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Bethany Rye
Sent: Thursday, July 05, 2012 10:12 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a document
to
a job, such as an excel spreadsheet, but I cannot figure out how to
attach a
whole file folder to the job (not just one document). Has anyone done
this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@... <mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com> > brye@... <mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
<mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data
within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of
this
data by any means to a foreign person, whether in the US or abroad,
without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be
reproduced
without written consent of CIGNYS. If you are not the intended recipient
or
believe that you may have received this document in error, please notify
the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date:
07/05/12

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date:
07/05/12

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
8
Tim,



This is interesting. I'll have to give this a try. Thanks for the tip!



Beth



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
timlester67
Sent: Thursday, July 05, 2012 2:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Attaching a file folder to a job - 9.04.507A - SQL





We have a button we added to Job Entry that will open a folder on the file
server based on the job number. In our case, our job numbers and folder
structure are similar so it works well for us. I don't know who wrote the
code originally, maybe someone from the group here - it was done before I
started.

Here's the main code:

Private Sub cmdViewDataFolder_Click(ByVal sender As Object, ByVal args As
System.EventArgs)
' ** Place Event Handling Code Here **

on error resume next
Dim JobNum As String = oTrans.JobNum()
Dim OrderNum As Int32 = Left((JobNum),5)
Dim OrderDir As Int32 = LEFT((OrderNum),2)
Process.Start("explorer", "(Server Name)\Job # (project
specific)\"&(OrderDir)&"000\"&(OrderNum))

End Sub

Hope this helps a little.

Tim

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Bethany
Rye" <brye@...> wrote:
>
> Thanks for the suggestion. That would work if files were all in the folder
> at one time, but unfortunately, the folder I want to attach will be
holding
> all kinds of files that will be added continuously throughout the life of
> the job and may have some added after the job finishes. What would be
ideal
> is if the link could be to open the folder instead of just a file.
>
>
>
> Now that I'm thinking about this, maybe what needs to happen is that the
> folder is zipped and then if a file gets added to the folder, the person
> then has to re-zip the folder. I might try this.
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
> Vic Drecchio
> Sent: Thursday, July 05, 2012 10:52 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL
>
>
>
>
>
> When I've needed to attach a dozen or so files to something, I zip them
into
> one file and then attach.
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> Bethany Rye
> Sent: Thursday, July 05, 2012 10:12 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL
>
> I am having difficulty with attachments. I know how to attach a document
to
> a job, such as an excel spreadsheet, but I cannot figure out how to attach
a
> whole file folder to the job (not just one document). Has anyone done
this?
> Can it be done? If so, how is it done?
>
> Beth
>
> Beth Rye
>
> IT Director
>
> CIGNYS
> Email: <mailto:brye@... <mailto:brye@...%20%3cmailto:brye%40cignys.com>
<mailto:brye%40cignys.com>
> <mailto:brye%40cignys.com> > brye@... <mailto:brye%40cignys.com>
> <mailto:brye%40cignys.com>
>
> ***ITAR NOTICE***
>
> This e-mail and/or the attached documents may contain technical data
within
> the definition of the International Traffic in Arms regulations, and are
> subject to the export control laws of the US Government. Transfer of this
> data by any means to a foreign person, whether in the US or abroad,
without
> an export license or other approval from the US Department of State, is
> prohibited. No portion of this e-mail or its attachment(s) may be
reproduced
> without written consent of CIGNYS. If you are not the intended recipient
or
> believe that you may have received this document in error, please notify
the
> sender and delete this e-mail and any attachments immediately.
>
> [Non-text portions of this message have been removed]
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
9
Have you tried dragging and dropping the folder onto the job number itself?



________________________________
From: Bethany Rye <brye@...>
To: vantage@yahoogroups.com
Sent: Thursday, July 5, 2012 10:12 AM
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a document to
a job, such as an excel spreadsheet, but I cannot figure out how to attach a
whole file folder to the job (not just one document). Has anyone done this?
Can it be done? If so, how is it done?



Beth



Beth Rye

IT Director

CIGNYS
Email:Â <mailto:brye@...> brye@...



***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.





[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
10
Nice.



Patrick Winter



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, July 05, 2012 02:17 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Attaching a file folder to a job - 9.04.507A -
SQL





Have you tried dragging and dropping the folder onto the job number
itself?

________________________________
From: Bethany Rye <brye@... <mailto:brye%40cignys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 5, 2012 10:12 AM
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a
document to
a job, such as an excel spreadsheet, but I cannot figure out how to
attach a
whole file folder to the job (not just one document). Has anyone done
this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@... <mailto:brye%40cignys.com> >
brye@... <mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data
within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of
this
data by any means to a foreign person, whether in the US or abroad,
without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be
reproduced
without written consent of CIGNYS. If you are not the intended recipient
or
believe that you may have received this document in error, please notify
the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
11
Doh, that works perfectly. Ignore my previous post about an awkward
method L



Thanks!

Brian.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Thursday, July 05, 2012 3:17 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Attaching a file folder to a job - 9.04.507A -
SQL





Have you tried dragging and dropping the folder onto the job number
itself?

________________________________
From: Bethany Rye <brye@... <mailto:brye%40cignys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 5, 2012 10:12 AM
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a
document to
a job, such as an excel spreadsheet, but I cannot figure out how to
attach a
whole file folder to the job (not just one document). Has anyone done
this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@... <mailto:brye%40cignys.com> >
brye@... <mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data
within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of
this
data by any means to a foreign person, whether in the US or abroad,
without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be
reproduced
without written consent of CIGNYS. If you are not the intended recipient
or
believe that you may have received this document in error, please notify
the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
12
I hadn't tried that but just did and it works. Thanks! I'm not sure if
it's because of some of the other things I've tried, but it's all good J



Beth



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ted Koch
Sent: Thursday, July 05, 2012 3:17 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL





Have you tried dragging and dropping the folder onto the job number itself?

________________________________
From: Bethany Rye <brye@... <mailto:brye%40cignys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 5, 2012 10:12 AM
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a document to
a job, such as an excel spreadsheet, but I cannot figure out how to attach a
whole file folder to the job (not just one document). Has anyone done this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@... <mailto:brye%40cignys.com> > brye@...
<mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
13
Uh. yeah, Ted. Nice tip. :-) Too simple!



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ted Koch
Sent: Thursday, July 05, 2012 3:17 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL





Have you tried dragging and dropping the folder onto the job number itself?

________________________________
From: Bethany Rye <brye@... <mailto:brye%40cignys.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Thursday, July 5, 2012 10:12 AM
Subject: [Vantage] Attaching a file folder to a job - 9.04.507A - SQL

I am having difficulty with attachments. I know how to attach a document to
a job, such as an excel spreadsheet, but I cannot figure out how to attach a
whole file folder to the job (not just one document). Has anyone done this?
Can it be done? If so, how is it done?

Beth

Beth Rye

IT Director

CIGNYS
Email: <mailto:brye@... <mailto:brye%40cignys.com> > brye@...
<mailto:brye%40cignys.com>

***ITAR NOTICE***

This e-mail and/or the attached documents may contain technical data within
the definition of the International Traffic in Arms regulations, and are
subject to the export control laws of the US Government. Transfer of this
data by any means to a foreign person, whether in the US or abroad, without
an export license or other approval from the US Department of State, is
prohibited. No portion of this e-mail or its attachment(s) may be reproduced
without written consent of CIGNYS. If you are not the intended recipient or
believe that you may have received this document in error, please notify the
sender and delete this e-mail and any attachments immediately.

[Non-text portions of this message have been removed]

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

[Non-text portions of this message have been removed]



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2193 / Virus Database: 2437/5112 - Release Date: 07/05/12

[Non-text portions of this message have been removed]