Help with creating Attachments in forms

[boblarson]

database is too big unfortunately...

1. Run Compact and Repair (Tools > Database Utilities > Compact and Repair
2. Use WinZip (or something like it) to zip the file
3. If, after doing that, the file size is still larger than 393Kb (limit for posting here), post back and I'll send you an email address you can send it to for me to take a look at.

 

[crumpet]

ok i did what you said and now it will fit , here it is , when you open it , open the customer form and you will see on the subform i have 3 attachment paths all with a browse button next to them , i need those paths to be filled by the choice made of the browse button

thanks for all your help

 

[boblarson]

You weren't assigning the path to anything. You should use it like this:

Private Sub Command52_Click()
    Me.Attachment_Path = fGetFileFolder
End Sub

 

[crumpet]

yippee it works i tells ya , thanks so much bud
when you said i didn't assign anything i removed all i had done so you could start from scratch

the problem was i didn't use a _ between assignment and path, i didn't realise i had too

thanks again mate

 

[boblarson]

No problem. I'm much more visual anyway and I can usually find problems faster, if I can see them, rather than trying to think of all possible questions.

 

[crumpet]

dam , looks like i spoke top soon
seems that the file path that gets copied across inst behaving like a hyper link
if i copy and paste a path from explorer it works but from the browse button its like dead link , any ideas ?

 

[NotVeryTechie]

I have just tried this code too, and am stuck! I get an error that points to the line

.Filters.Add "All Files", "*.*"

Not sure what to do.

 

[NotVeryTechie]

Ok, spoke too soon. I removed this line and now the button works. Problem is - it puts the link in my hyperlink field, but when i click on the hyperlink, it does nothing. It doesn't go to the folder.