×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

insert multiple image on single row in ms access database using vba

insert multiple image on single row in ms access database using vba

insert multiple image on single row in ms access database using vba

(OP)
thread705-1678760: VBA code to display multiple images in sinfgle Form

Hi,

I am using this thread database but I don't know how to import multiple images to multiple columns. Can please help on that. I want to import 300 images daily and show this images as grid like thread database. I am using this code to insert images which is imported images from my computer.

Public Sub LogPictureFilesToDatabase(sFolderPath As String)
Dim sFileName As String
Dim sAccountName As String
sFileName = Dir(sFolderPath & "\", vbDirectory)

Do Until sFileName = ""
Select Case LCase(Right(sFileName, 4))
Case ".jpg", ".gif", ".bmp"
sAccountName = sFolderPath & "\" & sFileName
DoCmd.RunSQL "INSERT INTO tblImg (Img) VALUES (""" & sAccountName & """)"

Case Else
'Ignore other file extentions
End Select
sFileName = Dir 'Get next file
Loop
End Sub

Thanks
Sajjad

RE: insert multiple image on single row in ms access database using vba

What are your fields in tblImg? I would expect to see a primary key etc. Your insert statement doesn't include anything other than a path.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close