User attachment

[RufussMcGee]

There is no way in access that I can tell to put in a user sketch form area where as they can draw a picture if need be. Thus my idea was to allow the user to attach files to the user form and have access save the path name. I need help working this out. How do I do an user interface on the form to allow the user to go out and attach the file? Thanks.

 

[Remou]

Unless you are using Access 2007, or intend to use BLOBs, it is not a good idea to store files in an Access database. You can get the path to a file by using some code:

http://www.mvps.org/access/api/api0001.htm