Unanswered: Need to link files to DB with Access 2003
I want to 'attach' images to my 2003 DB, and after doing a bit of research am thinking its best to just link to image files that will be stored in a network folder. (This is because I want the DB to be able to grow beyond the 2GB limit of Access DBs....)
Assuming this is the case, I'd like some help in setting up my form so the user can:
1) Browse to the image file
2) Hit an 'Attach' button which then saves the image file in a specific folder (where all images are stored)
3) Save the image file with the proper naming convention (which happens behind the scenes) so that the image has an ID and can be queried as desired
4) Display the image at the bottom of the form (I realize there will need to be a limitation on the image dimension)- not sure if this one is possible!
Let me know if this makes sense.
thanks very much!
Ha, you're lucky, I remember I made a text file out of this one for easy finding
I haz pr0 filing skillz
Dim fdSaveAs As FileDialog
Dim strFileName As String
Set fdSaveAs = Application.FileDialog(msoFileDialogFilePicker)
.AllowMultiSelect = False
.InitialView = msoFileDialogViewDetails
.Filters.Add "Please select a CSV File", "*.csv"
.InitialFileName = "F:\Database Projects\Production Database\"
If .Show = -1 Then
strFileName = .SelectedItems(1)