Picture - Database - Form

G

Gilberto

On access I need to specify the full route/path?

I want to specify just with the absolute path, like ../Images/

Sorry, I am newby on access. I usually work just with Webpages I an use
always the path like ".." for the current folder
 
D

Douglas J. Steele

You need a full path. However, you can determine where the application is
running, and build the full path in code, so that you essentially get the
benefit of a relative path.

To determine the folder where the application is running in Access 2000 and
newer, you can use CurrentProject.Path

In older versions of Access, you can use Left$(CurrentDb.Name,
Len(CurrentDb.Name) - Len(Dir$(CurrentDb.Name)))

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)
 
G

Gilberto

Thank you. I am working on it.

Actually I am at work and I am unable to make it work, however I will try it
later on home to try to make it work. I am really new on access, just 2 weeks
and this is my first mission......

this is the badge system. It had the images on the same access document. I
found a program that export them. I just export them with the ID code.

Now I have to remake the form to use the images outside from a server folder
because the old system took about 1.5 gigabytes with only 300 images.....
actually all same 300 images on jpg have 15 MB, almost incredible.....

I usually work just on excel ... this is my first access mission (New job).
 
Top