We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
11 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Loading default image if the image is not found in external folder
Posted on 2016-09-15
I want to load a default image if the specified image is not found. Below are my code in form load event.
The image file name will be the Workorder_ID & the file extension. Images in the external folder are named that way. In the event that the images are not available, I want the controls ImgHolder1.Picture & ImgHolder2.Picture to load the same default photo. Help with vba code preferred. Thanks
Dim ImgPath As String
Dim ImgFile As String
Dim ImgFile1 As String
Dim ImgFile2 As String
ImgPath = "D:\Img\"
ImgFile = Me.Workorder_ID
ImgFile1 = ImgFile & "F.png"
ImgFile2 = ImgFile & "B.png"
ImgHolder1.Picture = ImgPath & ImgFile1
ImgHolder2.Picture = ImgPath & ImgFile2
The image file name will be the Workorder_ID & the file extension. Images in the external folder are named that way. In the event that the images are not available, I want the controls ImgHolder1.Picture & ImgHolder2.Picture to load the same default photo. Help with vba code preferred. Thanks
Dim ImgPath As String
Dim ImgFile As String
Dim ImgFile1 As String
Dim ImgFile2 As String
ImgPath = "D:\Img\"
ImgFile = Me.Workorder_ID
ImgFile1 = ImgFile & "F.png"
ImgFile2 = ImgFile & "B.png"
ImgHolder1.Picture = ImgPath & ImgFile1
ImgHolder2.Picture = ImgPath & ImgFile2
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
6 Comments
Active today
you can use FSO's FileExists function to check the existence of a file:
Function isFileExist(yourFile)
Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")
isFileExist = fso.FileExists(yourFile)
End Function
...
ImgFileDefault = "yourDefault.png"
if isFileExist(ImgPath & ImgFile1) then
ImgHolder1.Picture = ImgPath & ImgFile1
else
ImgHolder1.Picture = ImgPath & ImgFileDefault
end if
...
I would have to place the function in a module and call the function from the sub? If so, please elaborate a bit more on where in the sub I would call the function. Thanks
Active today
yes, you can place that function into a Module.
>>If so, please elaborate a bit more on where in the sub I would call the function.
Thought, this is clear enough... just similar to your codes, like:
>>If so, please elaborate a bit more on where in the sub I would call the function.
Thought, this is clear enough... just similar to your codes, like:
Dim ImgPath As String
Dim ImgFile As String
Dim ImgFile1 As String
Dim ImgFile2 As String
Dim ImgFileDefault As String
ImgPath = "D:\Img\"
ImgFile = Me.Workorder_ID
ImgFileDefault = "yourDefault.png"
ImgFile1 = ImgFile & "F.png"
ImgFile2 = ImgFile & "B.png"
if isFileExist(ImgPath & ImgFile1) then
ImgHolder1.Picture = ImgPath & ImgFile1
else
ImgHolder1.Picture = ImgPath & ImgFileDefault
end if
if isFileExist(ImgPath & ImgFile2) then
ImgHolder2.Picture = ImgPath & ImgFile2
else
ImgHolder2.Picture = ImgPath & ImgFileDefault
end if
I did not know about the FSO before. I have 2 files to check for ImgFile1 and ImgFile2. What do I put in the function? Thanks again
Function isFileExist(yourFile)
Dim fso
Set fso = CreateObject("Scripting.Fi
isFileExist = fso.FileExists(yourFile)
End Function
Function isFileExist(yourFile)
Dim fso
Set fso = CreateObject("Scripting.Fi
isFileExist = fso.FileExists(yourFile)
End Function
Featured Post
Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 11 hours left to enroll
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.