Adding/Deleting Photos w/captions to a fillable form

stevisdavis · October 31, 2023, 11:51am

Hello all. New to this forum so if this is already answered, please direct me to it. Here is my issue: I am building a fillable form in writer that sometimes requires the user to add or subtract photos with a caption block directly beneath it. I would like the ability to add these photo/caption block “widgets” from left to right and then down so that two stand side by side with 3 rows in a full standard page that has been set up with no headers and minimal indentation. In other words, a total of 6 of these “widgets” could be placed on one page. Attempting to show what it would look like below:

If there is anyone that could help me with this task, I would greatly appreciate it!

Villeroy · October 31, 2023, 11:59am

Download and unzip PicsDB
Open either one of BasePics_FB.odb or BasePics_HSQL.odb.
The input form shows categories and descriptions for each picture. A double-click on a picture opens a file picker dialog.
The report in that database document shows a printable representation of descriptions and pictures.

stevisdavis · October 31, 2023, 1:52pm

Awesome! Thank you for the help. Taking a look now.

stevisdavis · October 31, 2023, 2:41pm

I am sure this information would help someone that knew what they were doing but I do not. Not really sure how to bridge that gap either. Thank you for your time.

Villeroy · October 31, 2023, 2:58pm

That’s easy. Put my database document (the _FB or _HSQL version) into the same directory as your pictures. You can rename the file anyway you like.
Open it.
Call menu:Tools>SQL… and enter the following: DELETE FROM PICS; DELETE FROM C in order to remove all my sample data.
Now you can use the input form to add your own pictures with descriptions.

Anyhow, there are plenty of free picture managment applications which allow to add comments and categories to picture files.

EDIT: I added a printable “3x2 Form” similar to your screenshot to the HSQL version of my database. I can’t get this to work with my Firebird (FB) version.
Replace the BasePics_HSQL.odb with this one and if you like that, use it with your own pictures as described above. The form has a 6x2 layout of post card shaped image controls with a “navigator bar” on the left side on an A4 print page. The delete buttons and the “navigation bar” won’t be printed as you can see in print page preview [Ctrl+Shift+O].
BasePics_HSQL.odb (318.0 KB)