View Single Post
  #1 (permalink)  
Old August 26th, 2012, 03:19 PM
liamfitz liamfitz is offline
Authorized User
Points: 312, Level: 6
Points: 312, Level: 6 Points: 312, Level: 6 Points: 312, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2006
Location: Orpington, Kent, United Kingdom.
Posts: 73
Thanks: 1
Thanked 1 Time in 1 Post
Unhappy Page 411 - Adding files as an attached field ? ?

I used the code on page 411 ( very slightly modified ), and managed to load a file to an attachment field. I think the problem is around the line(s) after 'Pass "" to match all files - which is exactly what I want to do i.e E:\FolderName\*.* for example. I get ( even after deleting attachment field and recreating it ) in destination table, a duplication error. Any thoughts ? Thanks.
Should the file name automatically change in the inner loop i.e
Code:
Do While Len(strFile) > 0
?
Reply With Quote