Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS Access VBA upload attachment

Posted on 2013-01-14
4
Medium Priority
?
366 Views
Last Modified: 2013-01-14
I want to build a form that saves attachments to folder and the path to SQL Server on select and save.

Any good links for that?
0
Comment
Question by:lrbrister
  • 2
  • 2
4 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 38775016
are you referring to A2007 attachments for Attachment Field type

see this link

How to: Work With Attachments In DAO

http://msdn.microsoft.com/en-us/library/bb258184.aspx
0
 

Author Comment

by:lrbrister
ID: 38775161
capricorn1

This is MS Access 2003 believe it or not.
I need toi select a file on click event
Load the file to a shared folder
Save the file path to sql
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 38775246
try this sample db for a starter
FileBrowser.mdb
0
 

Author Closing Comment

by:lrbrister
ID: 38775314
Perfect.
I can get where I want to go with this
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Implementing simple internal controls in the Microsoft Access application.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question