Adding photos to Base
Posted: Sat Mar 16, 2019 12:04 am
I read about adding images to Base but the thread was from 2012. I must confess it was beyond my expertise.
Fast Forward to 2019
I have created a table and form in Base. It is a very simple form and the data I need to record is very basic.
I just need last name, first name, and email address (email is the primary key). In addition I need to add a photo to the base for each record (I am a photographer). My workflow is: Have a client fill out the form, photograph the client, add one photo to the record, move on to next client. I do this because I am sending each client a copy of his photo via e-mail at a later time. In the past we have done this with paper and pencil but people have terrible handwriting (in general), so the thought of having the client fill out his own database form form is very appealing. In my version of Open Office (4.1.6) there is a field option called "photo". Sure enough I designed the form with that field and I can access my hard drive where the photo files are stored (as .jpegs), and add the photo to the base. However, I get error messages when i try to save the records and the database does not save. Can anyone give me any advice? I am not a power user and i'd be hard pressed to write macros but I can follow step by step instructions. For example, do this, then do that. Thanks in advance.
Fast Forward to 2019
I have created a table and form in Base. It is a very simple form and the data I need to record is very basic.
I just need last name, first name, and email address (email is the primary key). In addition I need to add a photo to the base for each record (I am a photographer). My workflow is: Have a client fill out the form, photograph the client, add one photo to the record, move on to next client. I do this because I am sending each client a copy of his photo via e-mail at a later time. In the past we have done this with paper and pencil but people have terrible handwriting (in general), so the thought of having the client fill out his own database form form is very appealing. In my version of Open Office (4.1.6) there is a field option called "photo". Sure enough I designed the form with that field and I can access my hard drive where the photo files are stored (as .jpegs), and add the photo to the base. However, I get error messages when i try to save the records and the database does not save. Can anyone give me any advice? I am not a power user and i'd be hard pressed to write macros but I can follow step by step instructions. For example, do this, then do that. Thanks in advance.