Save files through form into a folder (drag and drop)

[anandram]

Hi,

I currently have buttons that create folders in windows in my forms. User creates folder then opens from form and puts file inside (pdf/word doc/whatever)

I was just thinking whether it is possible to be able to drag a file into a particular text box/field in the access form and for the file to be saved at the backend folder.

I basically wanted to see if i could limit the users navigating around the backend windows folders, and for everything to be able to be opened and saved from within access form itself?

Note i dont want the files as attachments in the forms (DB would get too big).

I guess this is a simple drag and drop operation? Any ideas?

Thanks for the ideas/help.

[ajetrumpet]

you can actually simulate the windows explorer in an access form. I have an example of it and it runs pretty fast actually.

If you'd like to see if I could upload it here. You'd obviously have to do the keystroke captures though, but the explorer functionality is already there. It's pretty neat.

[anandram]

I'll take a look if thats ok?

[ajetrumpet]

this is a sample FTP app I used one time.

the right side of the form is the windows explorer portion. It's just as fast as the actual explorer, if not faster.

what I was saying is that you can use this stuff the way this is set up and simply capture keystrokes. you can also use highlighted files in the directory window to copy, move, delete, or whatever. When I do it, I use the DOS command in vba. It's a one liner and it doesn't take but a millisecond to run.

[khalid]

Hi Adam,

I got the missing or broken reference to the file 'MSPPT.OLB' version 2.9 error while opening the .mdb file (I have .accdb Access-2010 installed on my pc).

I wanna study the codes of the utility

[ajetrumpet]

just go in and uncheck the MISSING references in the vba editor, my friend.

MSPPT.OLB is powerpoint for ms office. I must have it checked on accident.

[anandram]

this is a sample FTP app I used one time.

the right side of the form is the windows explorer portion. It's just as fast as the actual explorer, if not faster.

what I was saying is that you can use this stuff the way this is set up and simply capture keystrokes. you can also use highlighted files in the directory window to copy, move, delete, or whatever. When I do it, I use the DOS command in vba. It's a one liner and it doesn't take but a millisecond to run.

hey, thanks for this. although i dont understand what you mean by capturing keystrokes or why that is important. Could you elaborate please?

The other question and i hope it doesnt come across rude or ungrateful, but why would i want to use this explorer over the windows one and for the purpose i was looking for in the original post? Aside from the fact it is integrated in access? Would it not just give the same functionality as the windows explorer? Excuse my ignorance

[ajetrumpet]

I was just thinking whether it is possible to be able to drag a file into a particular text box/field in the access form and for the file to be saved at the backend folder.

THAT is what you asked my friend. the purpose of what I posted was to give you the tools (code and otherwise) to get that done.

DRAG AND DROP is extremely difficult in access. Pretty much impossible, to where it concerns developers anyway.

my point of the "key captures" statement was: say you tell your users that "X" cuts a file from it's current location and "Y" pastes it into another folder. Obviously you can use ASC() and CHR() functions to capture those keystrokes and run a DOS function to actually move the file in the windows explorer "in the background". Does that make sense to you??

The code is very difficult to understand. so obviously it's for experts. But that was the point of this whole thing. Make sure you remember what you first asked!

[anandram]

Like i said i wasn't trying to sound rude. I recall what i asked but it wasn't what i had in mind that's all.

Also, I tried to open the DB and the file said it was corrupt or something. Although i think what you have just explained above may be a bit more than what i need, and beyond my ability. Thanks for the help though, i think i'll prob just stick with "create folder", and allow users to open and drop files into the explorer window.

[ajetrumpet]

no problem. for the corruption, see KHALID's post earlier.