Hello. I'm working on a bar bending schedule for construction and cost estimation and I'm new to MS Access and have no idea what the VBA look like. Though at some point, I'm working on how to lookup for an image to match the input bending code in the subform as display in my attached photo.
I tried using Dlookup from file path stored in 'description' field, it work fine but the problem is my colleagues like to move the file to other location for them to suited their preferences, so the image didn't display in the image control.
So I have an idea to store images in the table then use Dlookup for them, but it didn't work.
My point is ...
1. How to lookup for an image that match the input code?
2. The solution must be dynamic for my colleagues to move the file wherever they want but the image can still displayed.
3. If possible ... less VBA will be better for me, because I already messed up the code and ruined the whole file once.
Please help me I've been digging down on this one for months... : (
And sorry for my bad English.
I tried using Dlookup from file path stored in 'description' field, it work fine but the problem is my colleagues like to move the file to other location for them to suited their preferences, so the image didn't display in the image control.
So I have an idea to store images in the table then use Dlookup for them, but it didn't work.
My point is ...
1. How to lookup for an image that match the input code?
2. The solution must be dynamic for my colleagues to move the file wherever they want but the image can still displayed.
3. If possible ... less VBA will be better for me, because I already messed up the code and ruined the whole file once.
Please help me I've been digging down on this one for months... : (
And sorry for my bad English.
Attachments
-
forrum2.png
