If i leave the DAO i cant add the 14.0 Access database, i can only use the existing 15.0
Load attachments via VBA
- Thread starter freddykat
- Start date
If i leave the DAO i cant add the 14.0 Access database, i can only use the existing 15.0
That other problem got solved mate. Thanks but now when the file dialog pop opens and you chose the files i got error in this line, i tryed add the me.prefix but didnt solve.
"Set rsAttach = .Fields("Me.Anexo412").Value"
The mensage is item not found in collection
Maybe i have to say what is the form of this field?
"Set rsAttach = .Fields("Me.Anexo412").Value"
The mensage is item not found in collection
Maybe i have to say what is the form of this field?
Last edited:
It clearly states...
I put "Set rsAttach = .Fields("Anexo412").Value" but same mensage error. Cant find item in collection.
I guesse i change it as you said. Youre the man. Im putting preview foto name and not the collumn on the table. Now is uploading right.
Im gonna test the multi upload now to see if is doing right
Well now is uploading right the way i wanted but i have 8 attachment fields that can be populated with photos. Do you have an ideia how to upload the max of 8 photos at once?
I need it to be that way to make after another button for download all populated photo fields at once
I need it to be that way to make after another button for download all populated photo fields at once
Because i tough that it was the right way to do it.
I need to see the 8 previews at same time. Im putting a print screen to see what i have. I think that you will have an idea what im saying.
If you teach me how to put one box showing all of 8 photos can be a simple solution
Attachments
Last edited:
To be honest, my suggestion of saving the path alone would have been a much better solution.
I'll investigate how you can extract the 8 images and display them in the attachment controls, and I'll let you know much later. I think you can use just one attachment field and display the images in the 8 unbound attachment controls.
I'll investigate how you can extract the 8 images and display them in the attachment controls, and I'll let you know much later. I think you can use just one attachment field and display the images in the 8 unbound attachment controls.
I only need to be able to see the 8 photos in the form, i can use your solution.
I tried to change the view property to see more photos but i cant find the solution. I'm not kidding about the donation. We help who help us.
I missed your other post #30. We do what we can to help 
I hope your business is doing well!
Ok, I can get the images to display from top to bottom (i.e. vertically - see attached), but if you want the images to be laid out horizontally it can be done but the form would need to be in Single Form view. What's the default view of the form at the moment?
You could use an OLE Object data type and create 8 of these but this is a waste of space and it isn't as compressed as the attachment field.
The much better solution I was talking about was the one I mentioned here:
I hope your business is doing well!Ok, I can get the images to display from top to bottom (i.e. vertically - see attached), but if you want the images to be laid out horizontally it can be done but the form would need to be in Single Form view. What's the default view of the form at the moment?
You could use an OLE Object data type and create 8 of these but this is a waste of space and it isn't as compressed as the attachment field.
The much better solution I was talking about was the one I mentioned here:
Have you given this some thought? You would only need to put the images in a specific folder.
I missed your other post #30. We do what we can to help
Ok, I can get the images to display from top to bottom (i.e. vertically - see attached), but if you want the images to be laid out horizontally it can be done but the form would need to be in Single Form view. What's the default view of the form at the moment?
You could use an OLE Object data type and create 8 of these but this is a waste of space and it isn't as compressed as the attachment field.
The much better solution I was talking about was the one I mentioned here:
Have you given this some thought? You would only need to put the images in a specific folder.
It could be a solution.
I think its a single form. But I don't know how to use the OLE Object Data type to create a view horizontal. Right now the code is copying the photo or the path? I agree with your idea, but can i program it to save the path but copy the files from the Photo machine SD Card to the pre determined folder and then save the path?
I put my project in this URL http://www.4shared.com/file/80pXUwuwce/SOCAR_TERA_30_06_12_00.html
If you don't understand what is written ask me because its all in Portuguese.
Last edited:
I can make a video show you and explaining what i need to do and why.
I need that after the form shows all photos to when i double click the photo to maximize it for viewing.
Just need to use the command maximize?
My father and i talked about the possibility that we can make a few donations and you become like a database advicer, and help me programming at distance.
I dont know if you have time for that. That could be an litle more money on your accont, we are happy to help you because i think that if we booth get down to program the database it could be finished in a few weeks.
You talked about the OLE and attach it withing the database whats the better for a big database? Im expecting have 80.000 auto parts with a normal attachemnts of 5 per item.
I need that after the form shows all photos to when i double click the photo to maximize it for viewing.
Just need to use the command maximize?
My father and i talked about the possibility that we can make a few donations and you become like a database advicer, and help me programming at distance.
I dont know if you have time for that. That could be an litle more money on your accont, we are happy to help you because i think that if we booth get down to program the database it could be finished in a few weeks.
You talked about the OLE and attach it withing the database whats the better for a big database? Im expecting have 80.000 auto parts with a normal attachemnts of 5 per item.
The better option is to put the images in a specific folder, save the path to the image in a Text field and then use 8 Image controls to display the images.
I wasn't able to download your db, I think the site is down at the moment. Upload it on here by clicking the "Go Advanced" button below and you will then see where to attach the files.
Can you confirm that the form is a Single Form? Have a look at the Default View property in the form's property sheet.
I wasn't able to download your db, I think the site is down at the moment. Upload it on here by clicking the "Go Advanced" button below and you will then see where to attach the files.
Can you confirm that the form is a Single Form? Have a look at the Default View property in the form's property sheet.
I cant upload as you said. The form is defined as Dynaset.
Im uploading to another source and send you the link.
Link to database: http://www.megafileupload.com/hl9J/SOCAR_TERÇA_30_06_12_00.accdb
Last edited:
Is set to Continuous form
What's the difference between single and continuous form?I didn't find the advanced to upload the project