So after trying out the subform, I would rather use something like the example that you posted.
I could get it to display the attachments per record for the bound subform, but you had to use the arrows to inidividually navigate them (which there will be WAY too many records to do that in a timely manner), plus the database size is an issue that bugs me fairly badly, admittedly.
I was looking through your example (and admittedly I copied it over to my current project, keeping the copyright notices intact), but when it's in my project I'm getting a #Name? error in the boxes (form header/footer works as in the example, though). Experimentally, the error it gives me when I click View File is "Run-time error '2424': The expression you entered has a field, control, or property name <project name> can't find."
I know it seems like I want to be spoon-fed here, but after looking at the modules (I had originally intended to design my own so I wasn't ripping anyone's ideas off), I honestly was completely and totally lost. I looked on your site, but it seems no more examples are listed, and I was wondering if you might have a few more hidden away (possibly a readme with some hints on how to implement it?).
All I have left in the current project I'm working on is figuring out a way to attach them initially (initial input), be able to go back and add more at a later date (for more PDF's added, up to 3 total), have a way to open the current attachments for a particular record easily, and a way to remove them.
In any case, you have helped me ridiculous amounts so far, and I greatly appreciate it.
EDIT: The error seems to have been just from me being retarded and doing the whole unbound form thing, lol, but I'm still unfortunately at a standstill on the implementation of the desired operations.
I also see that it will add them to the record (ie where the file is currently stored). Is there a way to copy the file to the directory and do the whole file name concatenation thing? Also is there a way to display the ones associated with the NUMBERONE field on the form "Look Up" (unbound form)? At the moment it just shows ALL (well, only one) of the files that are linked for any of the entires.
I current use the FileSytemObject (FSO) for the file manipulation. (Move, rename, delete, get file properties etc.)
I've looked at the MSDN articles for it but I'm still kind of struggling, but I'll try to see what I can figure out in the meantime. And the MSDN article I found at:
http://msdn.microsoft.com/en-us/libr...50(VS.85).aspx
Acts like it's only for txt files, though I'm sure I'm just mistaken.
I was thinking perhaps having the input screen create a folder upon initial input (titled after the NUMBERONE field), then using that "Document Folder" field and adding the file folder name for concatenation, but it still begs the question for removing said files and copying/renaming them and placing them in the appropriate dir.
EDIT2: In trying to make it do something of that nature, I edited the on load event from:
Code:
Me.txtFolder = CurrentProject.Path
To
Code:
Me.txtFolder = CurrentProject.Path & "\" & Forms![Look Up].NUMBERONE.Value
And the Document Folder value seems to be working correctly, but for some reason it's only showing a slot for one value for the attachments.
Plus, when I open it in different directories, it's still listing the attachments for all the entires. Not sure if I'm doing something wrong, though.
If I'm just talking in circles and making no sense, you can feel free to PM me your e-mail and I can send you a copy (it's only about 1.5 MB compacted total, pre FE/BE split). Otherwise I won't trouble you with it and just keep the questions general and try to work with it.