473,245 Members | 1,844 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,245 software developers and data experts.

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 2568

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Clyde | last post by:
I am trying to implement the user feedback provided by Windows Explorer when draggng a filename from one place to another. I have the drag and drop action worked out but have had no luck in...
2
by: SamSpade | last post by:
There seems to be two ways to put things on the clipboard ( I don't mean different formats): SetClipboardData and OleSetClipboard If I want to get data off the clipboard do I care how it was put...
3
by: Ajay Krishnan Thampi | last post by:
I have a slight problem implementing 'drag and drop' from a datagrid to a tree-view. I have pasted my code below. Someone please advice me on what to do...pretty blur right now. ==code== ...
0
by: Norbert Heidbüchel | last post by:
Hi all, I have read a lot of postings and web pages about drag and drop and treeviews, but could not find an answer to my problem. Sorry, if I missed something. I am trying to drag and drop...
6
by: jojobar | last post by:
Hello, I look at the asp.net 2.0 web parts tutorial on the asp.net web site. I tried to run it under firefox browser but it did not run. If I want to use this feature in a commercial product...
0
by: Yavuz Bogazci | last post by:
Hi, i have build a form with a listbox and the function that he user can drag and drop files from the windows explorer in this listbox. this works for me when i start it on my localmachine. ...
1
by: Manuel Canas | last post by:
Hi there, This is the code that I am using to drag items from a list box and drop them into a text box. I'm not sure, but from what I know, each item on a list box is an object. Let say I get a...
3
by: VB Programmer | last post by:
In VB.NET 2005 (winform) any sample code to drag & drop items between 2 listboxes? Thanks!
2
by: ViRi | last post by:
I am wringing a small and lite Media Player to fit my custom needs for usage while programming. I had written some drag and drop functionality like i do with other programs, but hey, the ActiveX...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.