Apache OpenOffice Community Forum

I am working on an inventory DB for my storage building. It is a work in progress but I have two questions at this point. I have a over 100 gray totes (aka Walmart bins) that I have sorted parts into. I would like to take each one and photograph the contents in layers and then be able to call up each tote as a separate record based on content category. example:. “Plumbing , 1.2 inch PVC”; then I would like to be able to scroll through the pictures of that tote to see if the part I need is in there.

I have the DB working showing one picture but I have no idea how to be able to scroll through the other pictures. I plan to put each tote's photos in separate folders named by their location. In an ideal world, these pictures would open to full screen size (or to a second monitor).

So my two questions in short are:
1) Can you point me to some help to accomplish the above?
2) Do you know a simple Windows camera app that will let me easily save pictures to separate folders? The Windows Camera app that comes with Windows only saves to the “camera roll” and is real a PITA to change. Seeing as I have a few hundred photos to take, I would like to make it as simple as I can.
Thank You in Advance For Any Help You Can Give … I have studied this forum and learned much from you already.
Ver 4.1.9
Cburg

I uploaded a small demonstration database along with some images stored in a zip archive that demonstrates one way to scroll through a set of images on a Base form. Download from: https://www.mediafire.com/file/00t67v6q ... s.zip/file

Once downloaded and the archive unzipped there will be a database Demo18D_Teams and a sub-directory named Logos that contains the image files.
Open the Demo18D_Teams database and the form document Teams.
In the upper table choose a Team (Similar to your tub/container)
Then on the lower table scroll thru the Members/Characters (similar to the contents of the container) displaying an image associated with the selected members/characters on the form.

To display the images either full or extended screen could be accomplished with external image viewing software, using a macro coded for your specific form. In my limited test, scrolling did not work as I had hoped. Macro coding is somewhat of a Black Art, they can be difficult to get working and easy to break, so if you decide to go that direction ask your question in the Macros area of this Forum .

In my limited experience with camera apps they all store captured images in some default folder, if not Camera Roll, then usually Pictures.

Storing images (or any binary content) directly in the database is a bad idea if the native HSQLDB format is used.
It is better to set hyperlinks in table to a storage location.