OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

How to Add link to a folder of images in my form

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
ladybird
General User
General User


Joined: 10 Feb 2010
Posts: 23

PostPosted: Mon Feb 15, 2010 2:43 am    Post subject: How to Add link to a folder of images in my form Reply with quote

Hi, i already able to add image in my form using image control but i noticed that the file size of my database becomes bigger, is there a way to create a link to the folder instead for each record? thanks
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Mon Feb 15, 2010 3:55 am    Post subject: Reply with quote

Hallo

Point your image field to an url.
http://www.oooforum.org/forum/viewtopic.phtml?t=73329

Romke
Back to top
View user's profile Send private message
ladybird
General User
General User


Joined: 10 Feb 2010
Posts: 23

PostPosted: Wed Feb 17, 2010 3:25 am    Post subject: Reply with quote

RPG wrote:
Hallo

Point your image field to an url.
http://www.oooforum.org/forum/viewtopic.phtml?t=73329

Romke


Hi the macro dont seem to work for me, is there any other way?
My table contains fieldname - "RecordNumber" and the image for each recordnumber is in a folder "Images"
ex. RecordNumber - 00001
Image filename in the folder - TC00001

how can i link them? thanks
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Wed Feb 17, 2010 3:37 am    Post subject: Reply with quote

Please details?

Romke
Back to top
View user's profile Send private message
ladybird
General User
General User


Joined: 10 Feb 2010
Posts: 23

PostPosted: Wed Feb 17, 2010 3:57 am    Post subject: Reply with quote

RPG wrote:
Please details?

Romke


I have a table called tblMain, it contains more than 20 fields for each records. I dont have a field to hold an image, because i just want to use a link, do i need to add another column for the image link or not? anyways here's a sample data, each record number has different photos of trays which are stored in a folder in the hard drive. I want to display each tray per record number.

RecordNumber Title Manufacturer
00001 A1 Company1
00002 A2 Company2
00003 A3 Company3

The filenames of my images is in this format - TC00001, TC00002, ....

I hope these details are enough... thanks
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Wed Feb 17, 2010 4:13 am    Post subject: Reply with quote

read first before question
Back to top
View user's profile Send private message
ladybird
General User
General User


Joined: 10 Feb 2010
Posts: 23

PostPosted: Wed Feb 17, 2010 4:19 am    Post subject: Reply with quote

RPG wrote:
read first before question


hi, i tried to insert the macro in the form events (after record change)

sub begintoon(oEv as object)
'begintoon means begin-show
' Call this macro every time when you load a new reord
' bind this to the form to the event go to new record
' this is not bound to the picture control
' The picture control has a empty date field
dim beginform
'dim UrlField as string

beginform=oEv.Source
Yourpicturename="ImageControl" 'Here comes the name of your control for the picture
UrlField="Path" 'Here comes the url of the picture out your data base
beginform.getbyname(Yourpicturename).ImageURL= beginform.getstring(beginform.findcolumn(UrlField))
end sub

but it doesnt seem to be doing anything, I inserted a new column in my table called Path with fieldtype text(varchar). In the table, i inserted "c:/pics/00001.jpg" for each record.
Sorry im new to OoBase, thanks
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Wed Feb 17, 2010 9:59 am    Post subject: Reply with quote

Hello

Use an image control for displaying the image.

Read care full the complete thread there all information is there.

Romke
Back to top
View user's profile Send private message
ladybird
General User
General User


Joined: 10 Feb 2010
Posts: 23

PostPosted: Thu Feb 18, 2010 1:39 am    Post subject: Reply with quote

RPG wrote:
Hello

Use an image control for displaying the image.

Read care full the complete thread there all information is there.

Romke


Hi, i have an image control already. its just that the image doesnt display in that control. Thanks
Back to top
View user's profile Send private message
RPG
Super User
Super User


Joined: 24 Apr 2008
Posts: 2697
Location: Apeldoorn, Netherland

PostPosted: Thu Feb 18, 2010 4:35 am    Post subject: Reply with quote

Hello
Read the end of page two there I have a lot of things explained. It was always for people who are new to OOo-base. Read first global and then those things you need. When you are working with OOo3.2 then only page two is maybe important.

I think you need no more macros, but read the information how to work.

Romke
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group