I'm trying to drop a file from Windows Explorer (or desktop, etc.)
onto a field in Access2K and capture the full file path.
I found an posting below that says this is possible but I cannot
simutate it.
Can anyone help?
Thanks
**************************
previous post:
Message 1 in thread
From: bruce mohr (br********@tacp.com)
Subject: Drag and Drop jpgs to an MS ACCESS text field to use as
hyperlinks.
View this article only
Newsgroups: comp.databases.ms-access
Date: 2002-09-24 06:57:40 PST
Hey Everyone,
newbie questions
When you drag and drop a jpg onto a text field it automatically places
the path of that jpg into the Textfield.TEXT value. BUT...
1. I have found that you can drag and drop a jpg directly onto an MS
Access text field and, as long as you wrap it # signs it will act as a
URL or UNC, this is great.
....the problem is that they want to drag and drop the jpg's from
anywhere on there pc (no fixed source directory) and what happens is
that URL/UNC that is created in the text field is truncated to
something like "..\..\..\folder3\pic.jpg" instead of a full absolute
path like "C:\folder1\folder2\folder3\pic.jpg".
WHY??? How can I get the full path?
2. Also, pertaining to the above, I was trying to figure out a way
to drag and drop multiple jpg's to multiple text fields
symultaneously. For instance, you can drag and drop multiple jpgs on a
standalone VBS script, and it will process one after the other.
a. Can this be done by using as ActiveX control?
b. Can I integrate the WSH/VBS within MS ACCESS so I can drop the jpgs
directly on the access form?
Any thoughts on how this can be done with ACCESS/VBA??
Thanks in advance
Message 2 in thread
From: gm******@oconnorsreports.com.au
(gm******@oconnorsreports.com.au)
Subject: Re: Drag and Drop jpgs to an MS ACCESS text field to use as
hyperlinks.
View this article only
Newsgroups: comp.databases.ms-access
Date: 2002-09-25 11:00:58 PST
I may have completely missed the point but would you be better using
memo fields.