p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Access 2010 VBA Programmer's Reference (http://p2p.wrox.com/forumdisplay.php?f=597)
-   -   Page 411 - Adding files as an attached field ? ? (http://p2p.wrox.com/showthread.php?t=88322)

liamfitz August 26th, 2012 03:19 PM

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
?


All times are GMT -4. The time now is 03:41 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.