How To Do A "relative" Image Link To Save Space.

Sep 5, 2005

I have a database that I migrate to different locations as we change stations (military). I keep the master on my C: drive and then put a copy onto the shared network drive. I keep my images in a subfolder of the master db.

example:

C:Pirate (master db)
C:Piratedbfiles (where I store the images)

I have the images "linked" on the forms to the subfolder "dbfiles" that is on the shared drive. However, as we change locations the drive letter changes for the shared drive. I want to make a "relative" link to the pictures in the properties box as so:

Piratedbfilesimage1.jpg
or
dbfilesimage1.jpg

However, it keeps putting the C: in front of the text or else it won't find the images. I desire it to look in the subfolder of the active db (whether or not it is on the LAN or hard drive).

I know I can embed the images, but that exponentially increases the size of the db. I've played around with putting them in a table, but couldn't make that work either.

Oh, Access 2000.

Thanks,
Brian

View Replies


ADVERTISEMENT

Forms :: Relative Folder On Image Path

Jul 10, 2013

I am trying to link an images (.png) onto a form. I have a folder of all the images I want but I want the path to be relative. So that if I move the access file and the images folder to a new location, it will still work.

In the properties for the image, It works fine as C:UsersjohnDesktopimage1.png but what I am looking for is the ability to use "imagesimage1.png" as the file will always be in that relative folder to the db.

What is the correct syntax for this? putting image1.png in the same directory and just using image1.png works, but this won't be very tidy with 100+ images.

I have tried:

imagesimage1.png
imagesimage1.png
imagesimage1.png

With PictureType set as linked.

I know from searching it is possible through VBA by getting the root directory of the folder and appending the filename. Don't really want to go this root. I also don't particularly want to create a table to store the images or links.

View 8 Replies View Related

Link To A Web Image

Apr 14, 2005

i have a cars database
because it is difficult to add 4000 pictures i want to know
if is it possible to add a field that opens an ie page in google images to show results of images for that car?
ex :
model : Ferrari
foto link :http://images.google.com.gr/images?hl=el&lr=&q=Ferrari&btnG=%CE%91%CE%BD%CE%B1%CE%B6%CE%AE%CF%84%CE%B7%CF %83%CE%B7

View 6 Replies View Related

Forms :: Button To Link To Image

Apr 10, 2013

I'd like to put a button in a form that when clicked opens an image on the computer, the location of which is already specified in a field called RefImage.

When I change the hyperlink property I can only have the button open a folder or internet address rather than a unique image for each individual record.

If I use the code builder for the event on click and try to write Application.FollowHyperlink RefImage it gives me error message 490 that it Cannot Open the Specified File, but this is probably because I don't know how to write VBA.

Any simple way to make a button on a form open an image in IE or windows image viewer which has a path specified within a field of the form? Perhaps someway to use the Application.FollowHyperlink, clearly I am doing something wrong.

View 8 Replies View Related

Modules & VBA :: Save Pivot Chart As Image

Jul 11, 2014

I have a query that has a pivot chart, i need to be able to save this as an image so i can insert it into a html email but i cannot find anything, I am using access 2010 ...

View 3 Replies View Related

Reports :: How To Get Link Address To Image In A Report

Dec 4, 2013

I want to get the link adress to an image in a report using VBA. I use the following code:

PHP Code:

Dim strPath As String
strPath = [CurrentProject].[Path] & "builder" & FirstImage
If Not Right(strPath, 7) = "bilder" Then
    Me.huvudbild.Picture = strPath
Else
    Me.huvudbild.Picture = [CurrentProject].[Path] & "builder\_tom.jpg"
End If 

I get the following error (translated from Swedish): Error: 2424 The expression contains a field, a control or a property name that MS access couldnt find.

View 3 Replies View Related

Link Image Files To Access Table

May 1, 2013

I'm using Access 2013. I have a directory on my hard drive that contains hundreds of image files. The name of the image file matches a field in the Access table, which are unique. I would like to match those files to the unique number in the table and create a link in a field. How would I go about this.

View 12 Replies View Related

Forms :: Save Form / WebBrowser Control - Contents To Image

May 17, 2014

I have a form that contains one WebBrowser Control. In this WebBrowser control I interact with the Google Maps API to produce a map.

I would like to save the contents of the WebBrowser Control (Google Map) to an image file. I have not been able to figure out how to do this.

The WebBrowser Control takes up all the space in the form. Perhaps the contents of the entire Form can be exported to an Image?

View 2 Replies View Related

Modules & VBA :: Allow User To Select A Location To Save Just A Copy Of Image In JPG Format

Dec 6, 2013

Access 2010:

The database I'm working on stores label images, or better stated, it stores file paths where the label images are stored. These paths are used in reports and forms to view the label images within the database. What I'd like to do is to create a "save" or "email" button that will allow the user to select a location to save just a copy of the image in jpg format. I realize that it is possible to imbed the jpg image into a report and export it as a pdf. What I'd really like to do is find a way to save the image (perhaps by copying it from the path in the database and simply relocating it) and preserve the jpg extension if that is possible.

I am also aware that there are third party applications that will convert pdf reports into jpg files however network restrictions keep me pretty limited in my ability to download third party software.

View 2 Replies View Related

Relative Links For Linked Tables

Jan 6, 2006

Hi,

I'm buliding an access system in which the forms and tables stored in seperate databases as such:

forms: \serverdirmyDatabase.mdb
tables: \serverdirdatamyTables.mdb

myDatabase has a load of linked tables from myTables. Problem; my network drives are mapped differently from the users, so the links do not work for me.

So - does anyone know how I can set up a relative link, so myDatabase looks for datamyTables? i.e. it looks from the source directory rather than checking the whole path back to the root?

Hope this is making sense . . .

Dave

View 2 Replies View Related

General :: Identifying List Of Each Object With Their Relative Size?

May 19, 2015

I have a large database. I want to identify which objects take up the most space. Any way of identifying a list of each object with their relative size?

I can do this in sql server, but no in Access?

View 8 Replies View Related

Modules & VBA :: Changing Image Path - Set Picture Property Of Image

Dec 4, 2014

I have a form that I would like to update a picture on using VBA. The source of the picture path is in part a query that is not bound to the form. So far I have the following code that is pretty much working, but with a couple flaws.

Code:
Private Sub Form_Current()
LoadDefaultPicture
End Sub
Sub LoadDefaultPicture()
Dim db As DAO.Database

[Code] ....

This is working. However, when I change the record the picture flashes the current picture once and then loads the new picture. It is like it reloads the current picture then loads the new one. I'm hoping there is a way to get rid of the flash.

Also, the code fails here:
strDefaultPictureName = rs.Fields("AttachmentName")

When the query does not return a record. I can definitely fix this by adding an if statement to check for a record, but I'm kind of perplexed at why it is failing at that line. I would expect it to assign an empty string to that variable name and then fail on the next command where I try and set the ".Picture" property of the image.

View 8 Replies View Related

How To Embedd Image In Image Control Using Imagelist.

Feb 6, 2005

Hi all ,
Can anyone tell me about how to embedd image in image control using imagelist.
I added the 5 images in imagelist at design time and added the following code.
image.picture=imagelist.listimages(1).picture
but iam getting error.error no :2110,cannot open the file .
thank u,
Siva

View 3 Replies View Related

Modules & VBA :: Save As Dialog Box - Allow User To Save Copy Of Current Database At Desired Location

Feb 12, 2014

So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.

I am using Access 2010.

View 2 Replies View Related

Modules & VBA :: Save Access Report As PDF And Save To Folder

Jan 10, 2014

I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?

View 4 Replies View Related

Click Image Hyperlink In Form To Load Image To Form

Jun 16, 2006

Hi guys,

I'm in desperate need of help and want to know if it is possible to load an image on a form once a hyper link is created.

For example, I have a form with a hyper link to an image created, currently, when you click on the hyperlink, it opens the picture in the browser, can you change it so that it loads teh image embedded into the form instead of loading it into a browser?

If so, how?

Thanks

View 1 Replies View Related

General :: Open Save File Dialog - Select File From Text Box And Save To Selected Location

Aug 8, 2013

I need code for save dialog file ,and select the file from textbox and save it to the selected location.i have only this code and i dont know what else i can do with this because it just opens the save file dialog !

View 1 Replies View Related

How To Add A Space In Between

Oct 26, 2005

I have a query that pulls information from two different columns in a linked table, and places them together in a single column in a new table. The expression that i use in the query is: Expr1: [ARTINAME]+[ TITLE]. I need to put a space between the two. Is there a way to put a space in between these two when written to the new table?

View 3 Replies View Related

What Takes More Space?

May 19, 2006

Hi everybody,

Amongst many other things i would like to be able to see which teams in our company have access to which database. We currently use up to seven!!! different Databases which makes for tremendous fun...just kidding.

Since every Team has access to more than one Database andevery Database obviously gets used by a multitude of Teams, i thought the best way to go would be a Junction Table. Whilst building this, however, it occured to me that i could have just created fields for each Database in the Team Table which then can be ticked.

So here's my question, is it more space consuming to create a junction table, it certainly appears to be more work right now...

Thank you very much,

Dan

View 2 Replies View Related

Can I Have A Space In Field Name?

May 11, 2005

Hi!

Is it possible for me to alias the fldGroup to Function Group?

How do you alias a field name to a name that contain a space?

Please advise.

Aijun.

View 3 Replies View Related

Remove Space

May 20, 2006

I have an enormous Post Code Table 1.7 million records, which I must update every month into usable sectors for our carrier cross refs, the UK postcode is in the format CB6 3HQ, CB6 3HR, CB6 3HS, CB6 3HT, CB6 3HW etc I need to be able to remove the space then only use the first 4 chrs ie CB63, in the above examples I know I could do a search and replace " " with "" but I need this to be run automaticly where would be the best place to do this and if coded how?

Any help or alternative suggetions appriciated

View 6 Replies View Related

How Do I Know How Much Space A Table Uses Within An MDB

Jul 26, 2007

Hi there

I would like to know how to find out how much space a table uses within an MDB. is there a analyser of some kind available that you know of?

Thanks

View 3 Replies View Related

Find First Space From Right

Sep 17, 2007

I need an expression which finds the first space from the right and returns the text (variable length) to the right of it.


Ex.

AMINOPH, THEOPHY. INJ

expression should return INJ

View 1 Replies View Related

Read Right To First Blank Space

May 19, 2005

I am trying to break out a field where city, state and zip codes have been consolidated. I want to create a field where I am able to ready the consolidated right either right or left until the first blank space. For example:

"pittsfield ma 01201"

I want to read the field to break out "pittsfield"

Thanks in advance for any help I can get on this :)

View 3 Replies View Related

Not Enough Disk Space Error

Nov 21, 2005

OS = XP pro SP2
200GB IDE HD with 134GB free (NTFS)
200GB USB2.0 with 54GB Free (NTFS)
Virtual Memory = 1gb (Let Windows Manage)

Trying to copy files from a external USB drive to the Hard drive.

I have done this a million times and now it decides to foul up. When trying to copy files from the external drive to the hard drive that are 4GB or higher I get an error "Not Enough Disk Space"

Both Drives are NTFS with Plenty of free space. Also get the same error when creating files larger than 4GB. It worked before and no OS changes have been made that I know of.

View 2 Replies View Related

Adding A Space After The Decimal!

Aug 16, 2006

Hello Everyone :cool: ,

In access, I have a field in a table that I need to fix. The field contains a charge(money) value, with a code attached to it. For example:

[2345.0020680]---> The (2345.00) is the charage amount & the (20680) is the code.

[17580.04PPO]----> (17580.04) is Charge; (PPO) is the code.

**Every charge amount is different, and every codes length is different; so there is no consistency in this field.

I need to add a space, comma, backslash, or something two places after the decimal, to split the two. Once I do that I'll export to excel, and split the field into 2.

HELP!:confused:

Thanks in advance everyone,

Martian262002

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved