Ubuntu
openoffice.org package

How to attach a picture to an OpenOffice Base Entry

Asked by Kevin Baxter

Is it possible to attach a photograph to an OpenOffice 3.2 Base Entry - like attaching an image of the item in an inventory?

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Tony Pursell
Solved:
Last query:
Last reply:
Revision history for this message
Best Tony Pursell (ajpursell) said : 		#1

Hi Kevin

Yes it is perfectly possible to store photos in OOo Base,

I would suggest you make a trial database to try out what you need. If you create a new table using the Wizard and select Category = Personal, you will see Photo as a listed field. If you add that to the table, this will show you the data type that Base uses for images.

To put Images into a database you will need to create a Form with appropriate fields on it. This is fairly straightforward if you haven't done it before. There is a toolbar down the side with the controls you can add to the form. Towards the bottom of this toolbar, is a More Controls button. This opens a second, floating , toolbar which has the Image Control on it.

When you add the first control, you will need to right click on it and select Form. This brings up the form properties. On the data tab, you specify the table that contains the data. Then for each control, you need to right click and select Control, and on the control properties data tab you specify the data fields.

When you toggle Design Mode Off, you will see that you can right click in the Image control and select 'Insert graphics from...'

If you need more help, do ask, but if this answers your question, please mark it as Solved.

Tony

Revision history for this message
Kevin Baxter (kevin-h-baxter) said : 		#2

Thanks, Tony. That's a great help. Still fumbling my way through database development. Will mark the question solved. KHB

Sent from my iPad

On Feb 18, 2011, at 7:07, Tony Pursell <email address hidden> wrote:

> Your question #145826 on openoffice.org in ubuntu changed:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/145826
>
> Status: Open => Answered
>
> Tony Pursell proposed the following answer:
> Hi Kevin
>
> Yes it is perfectly possible to store photos in OOo Base,
>
> I would suggest you make a trial database to try out what you need. If
> you create a new table using the Wizard and select Category = Personal,
> you will see Photo as a listed field. If you add that to the table,
> this will show you the data type that Base uses for images.
>
> To put Images into a database you will need to create a Form with
> appropriate fields on it. This is fairly straightforward if you haven't
> done it before. There is a toolbar down the side with the controls you
> can add to the form. Towards the bottom of this toolbar, is a More
> Controls button. This opens a second, floating , toolbar which has the
> Image Control on it.
>
> When you add the first control, you will need to right click on it and
> select Form. This brings up the form properties. On the data tab, you
> specify the table that contains the data. Then for each control, you
> need to right click and select Control, and on the control properties
> data tab you specify the data fields.
>
> When you toggle Design Mode Off, you will see that you can right click
> in the Image control and select 'Insert graphics from...'
>
> If you need more help, do ask, but if this answers your question, please
> mark it as Solved.
>
> Tony
>
> --
> If this answers your question, please go to the following page to let us
> know that it is solved:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/145826/+confirm?answer_id=0
>
> If you still need help, you can reply to this email or go to the
> following page to enter your feedback:
> https://answers.launchpad.net/ubuntu/+source/openoffice.org/+question/145826
>
> You received this question notification because you are a direct
> subscriber of the question.

Revision history for this message
Kevin Baxter (kevin-h-baxter) said : 		#3

Thanks Tony Pursell, that solved my question.