Ask Your Question

Can you dynamically link images in a form in Base?

asked 2017-02-17 01:11:20 +0100

Garimba gravatar image

I'm new to Base, using Ubuntu 16. In Access, I entered "=C:\path\"&[picture] into the image field. picture is the name of the field containing a .jpg filename for each record. Then each time I clicked "next record" in the form, I'd get the related picture. How can I do this in Base? Browsing for each of the 1800 records isn't workable.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-02-23 23:24:56 +0100

Garimba gravatar image

Yes, I figured it out. On main page go to Tools, sql. Enter a generic path name into a varchar field and execute. My generic path name is UPDATE "INV" SET "PathToPicture" = LEFT("BestPicture", 2) + CHAR(47) + "BestPicture"

Then in the form, rightclick on the content box for "PathToPicture", and click "replace with", click "image control." Now the picture changes with each record, as long as I keep the pictures in the right folders.

edit flag offensive delete link more

answered 2017-02-17 01:29:24 +0100

Ratslinger gravatar image

See my answer in this post - click here.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-17 01:11:20 +0100

Seen: 122 times

Last updated: Feb 23 '17