introducing a picture in a form

[foxie foxster]

hi
i have a form which i use as menu
on that form i put the logo of the club
there the logo is introduced with the adres of the logo e.g.
c:/docuemnts/logo .....

now i made an install file with a program and i included that logo

the install file propose always to install my program (mde. file of access)
in dir c:/myprogram

so in the form i always set the logo on c:/myprogram.....

BUT: if someone don't accept my proposel of c:/myprogram and put it on e.g.
d:/my program then the logo is put there too

NOW when they start the program on d...the program goes looking for the logo
in c:/my programs....and can't find it....

now...
problem: how can i put a logo on a form and the adres is the directory where
the programme was isntalled.....

greetings
foxie foxster

 

[Guest]

The currentdb.Name will return the location of the mdb + the name.
to get only the path remove the name from the end
left(currentdb.Name,len(currentdb.Name)-the length of the mdb) & the name of
the picture

 

[Larry Linson]

CurrentDB.Name will give you the fully qualified (aka "well-formed) address
of the current database. If the file you want is, in fact, installed in the
same folder as the database, you can use everything up through the last \
and append the name of the logo file to retrieve it. On the other hand, if
the logo is just placed in whatever folder the user desires, you'd have more
of a problem.

Larry Linson
Microsoft Access MVP

 

[foxie foxster]

thx that's the solution
i put the file "logo" always in hte same directory of the mdb file....the
installer let you chose the dir but for all the files (Mdb+logo file)
thx and greetings