Home working so taking the time to develop a database of litter bins (1 Viewer)

Gary Somerset

New member
Local time
Today, 23:37
Joined
Mar 26, 2020
Messages
3
Hiya, hopefully that got your attention. It is for work, my name is Gar and I have created a database that links to a sql server that receives data from a mobile monitoring app. This has forms that can ask questions. This particular one is a litter bin asset survey. Captured photos are available to view via their URL. I want to display these on my form in MS Access Web browser. Pasting the URL into the control source achieves this. However, I want to store the URLs in a table or query.
I have tried for days with no success. Can someone please tell me how I can simply get the control source to look at a field in a table to retrieve the URL. I want this to change with the record.

If it is not being too greedy can someone please let me know how to set the size of the inserrted jpg photo.

Thank you very much if any genii can help me.

Gar
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:37
Joined
May 7, 2009
Messages
19,169
bind your form to the table where the URL fields are found.
add a textbox and bind it to the URL field.
you can add a Webbrowser Control to your form.
on the Current Event of the form, navigate to the URL.

If IsNull(Me.urlTextbox) Then
Me.webBrowser1.Object.Navigate "About:Blank"
Else
Me.webBrowser1.Object.Navigate Me.urlTextbox
End If
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:37
Joined
May 7, 2009
Messages
19,169
you may also elect to use Image control and bind it to the URL field.
 

Gary Somerset

New member
Local time
Today, 23:37
Joined
Mar 26, 2020
Messages
3
bind your form to the table where the URL fields are found.
add a textbox and bind it to the URL field.
you can add a Webbrowser Control to your form.
on the Current Event of the form, navigate to the URL.

If IsNull(Me.urlTextbox) Then
Me.webBrowser1.Object.Navigate "About:Blank"
Else
Me.webBrowser1.Object.Navigate Me.urlTextbox
End If
Thank you. What I did in the end of was to bring a text box onto the form that contained the URL and then put =[textbox] in the control source. It has worked and is simple enough for me to understand. Thank you for your solution and time taken to help. Kind regards Gar
 

Gary Somerset

New member
Local time
Today, 23:37
Joined
Mar 26, 2020
Messages
3
Hi Gar,

Welcome to AWF!

See if this old post on another forum can give you some ideas.

hth,

d

Hi d,

Thank you for sharing that potential solution with me. I am new to VB but have been using it in my applications but only when I can find some written code and a few tweaks are obvious. The code you shared with me seems a bit complication. Can I just past it into a On updated event Private Sub routine. Isn't it possible just to put something like:

Private sub zoom out ()
img.style.height = '50%';
img.style.height = '50%';

End sub

I was looking for something as simple as this but written properly.

If you can help I will pay it forward.

Gar
 

theDBguy

I’m here to help
Staff member
Local time
Today, 16:37
Joined
Oct 29, 2018
Messages
21,358
Hi Gar. Welcome to AWF!
 

Users who are viewing this thread

Top Bottom