468,484 Members | 2,041 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,484 developers. It's quick & easy.

Drop and Drag in Access2K from Windows

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.
Nov 12 '05 #1
0 2274

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Clyde | last post: by
2 posts views Thread by SamSpade | last post: by
3 posts views Thread by Ajay Krishnan Thampi | last post: by
6 posts views Thread by jojobar | last post: by
reply views Thread by Yavuz Bogazci | last post: by
1 post views Thread by Manuel Canas | last post: by
3 posts views Thread by VB Programmer | last post: by
reply views Thread by NPC403 | last post: by
2 posts views Thread by gieforce | last post: by
reply views Thread by theflame83 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.