MS Access Drag & Drop

Graeme Howard

unread,

Mar 8, 2003, 5:19:19 AM3/8/03

to

Hi,

Does anyone have the code, or even better, can I download an example
database which allows Drag & Drop commands.

I've been using The Access Web for the past year which is absolutely
brilliant, but I can't get this particular code to work.

Cheers

Graeme

Allen Browne

unread,

Mar 8, 2003, 5:43:48 AM3/8/03

to

For anything graphical in Access, see:
www.lebans.com

--
Allen Browne - Microsoft MVP (Most Valuable Professional)
Allen Browne's Database And Training - Perth, Western Australia.
Tips for MS Access users - http://allenbrowne.com/tips.html
Reply to the newsgroup. (Email address has spurious "_SpamTrap")

"Graeme Howard" <graeme...@ntlworld.com> wrote in message
news:f3141955.03030...@posting.google.com...

Mark Johnson

unread,

Mar 8, 2003, 5:53:22 AM3/8/03

to

graeme...@ntlworld.com (Graeme Howard) wrote:

>Hi,

The OLEDragDrop in a control works fine. But I remember coming across,
repeatedly, a complaint by someone about A97, that it didn't expose
enough properties, and didn't implement drag/drop _between_ controls
very well. But the OLE stuff is available for various controls, as you
can see in the 'F2' browser in Access.

Peter D.

unread,

Mar 8, 2003, 2:24:27 PM3/8/03

to

Graeme,

There are some third-party tools that may help:

A shareware version of Drag-N-Dropper for MS Access is available at this web
site: http://www.peterssoftware.com/dd.htm

Stephen Lebans has an example of a FieldList control that supports drag and
drop: http://www.lebans.com/vb_listbox.htm

The Forms Sample database provided by Microsoft has an example called
"Simulating Drag-And-Drop Capabilities". You can download the sample
database here:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;175066

Hope this helps,

--
Peter De Baets
Peter's Software - MS Access Tools for Developers
http://www.peterssoftware.com

"Graeme Howard" <graeme...@ntlworld.com> wrote in message
news:f3141955.03030...@posting.google.com...

Graeme Howard

unread,

Mar 11, 2003, 11:49:10 AM3/11/03

to

Cheers Allen

I'm suprised its you of all people to get back to me. I've seen loads
of your stuff all over the internet.

The only thing is though..
I've tried what you said, but thats just a kind of fake drag and drop,
just plopping items from one box to another.

What I need is a true Drag & Drop, where a user can drag files from
explorer straight into an access form - to simplify importing files

The nearest thing I can find is on The Access Web. After downloading
their sample API code, AddressOf, and vba332.dll, it still doens't
seem to work. I can't force it to look in the dll. It still says it
cant find it, even though it should... its in the system folder.

It would be handy to have a simple mdb file. Nice and portable so
people can use it when they need it? When I find one, and finally get
it working, I'll distribute it myself for other. It would be so handy
for people to have.

Cheers

Stuart MacKinnon

unread,

Mar 26, 2003, 4:23:06 AM3/26/03

to

Graham,

Tomorrow, I'll email you a copy of an Access 97 version I just got
working today (based on the Access Web stuff). I got it working with
version 3.0.7019 of the VBA322.DLL running on NT 4.0 (in case that
makes the slightest difference).

Repeating my call yesterday though, (in:
http://groups.google.com/groups?dq=&hl=en&lr=&ie=UTF-8&selm=56db38fe.0303250332.74785419%40posting.google.com)

If anyone has this code working in Access 2000, please let me know.

I will supply beer if you can get to a bar in Auckland, New Zealand!

:-)

Regards
Stuart MacKinnon

graeme...@ntlworld.com (Graeme Howard) wrote in message news:<f3141955.03031...@posting.google.com>...