6 Replies - 539 Views - Last Post: 02 July 2017 - 05:48 AM Rate Topic: -----

#1 suleiman8974  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 24-June 17

Have a problem of Uploading and Retrieving multiple Images/Files using

Posted 24 June 2017 - 06:58 AM

How would i upload and retrieve multiple images/files of an individual in a database. for example one can upload five (5) images/files to MR. A and 3 Images/files to Mr. B and then how would i retrieve the Images/files individually using the Mr. A or Mr. B ID as Key Using Userform in VBA.
Is This A Good Question/Topic? 0
  • +

Replies To: Have a problem of Uploading and Retrieving multiple Images/Files using

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 13491
  • View blog
  • Posts: 53,888
  • Joined: 12-June 08

Re: Have a problem of Uploading and Retrieving multiple Images/Files using

Posted 24 June 2017 - 08:23 AM

It's about table structure.

First table - a user table. This has a numeric/guid key, text column for name, and maybe a 'date entered'.
Then you have a table for pictures. Storing images in a DB isn't the best so store the path! The table would contain its numeric/guid key, a foreign key to the user table, the text path to the image, and a date entered. Voila!
Was This Post Helpful? 0
  • +
  • -

#3 suleiman8974  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 24-June 17

Re: Have a problem of Uploading and Retrieving multiple Images/Files using

Posted 24 June 2017 - 08:29 AM

Not clear with your reply but am using VBA in Excel
Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 13491
  • View blog
  • Posts: 53,888
  • Joined: 12-June 08

Re: Have a problem of Uploading and Retrieving multiple Images/Files using

Posted 24 June 2017 - 08:38 AM

Ah... then what/where is this database mentioned?
Was This Post Helpful? 0
  • +
  • -

#5 suleiman8974  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 24-June 17

Re: Have a problem of Uploading and Retrieving multiple Images/Files using

Posted 24 June 2017 - 09:03 AM

Sorry please. Am using VBA in Microsoft Excel, and i want a situation whereby i can insert/retrieve different images/pictures for an individual using Userform to insert the picture and the able to retrieve the pictures/images

See attached workbook on how the table will look like after inserting the details through userform
Was This Post Helpful? 0
  • +
  • -

#6 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 13491
  • View blog
  • Posts: 53,888
  • Joined: 12-June 08

Re: Have a problem of Uploading and Retrieving multiple Images/Files using

Posted 24 June 2017 - 09:27 AM

Ah.. excel is not a database. On that note I'll tap out of the conversation.
Was This Post Helpful? 0
  • +
  • -

#7 gibra  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 18-June 17

Re: Have a problem of Uploading and Retrieving multiple Images/Files using

Posted 02 July 2017 - 05:48 AM

Moreover, this forum is for VB6, not for VBA.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1