473,320 Members | 1,881 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Masking a portion of stored link to image

imrosie
222 100+
Hi,

I need some help please. I have an image database (which so far works great) However, when I pull in a file in the form to store (actually the link), the image is shown in a subform and the name of the image is displayed in a control (on main form called 'image description). Currently 'image description' looks like this:

D:\imageDogs\ChestertheDog.jpg

Unfortunately, I need to mask out the first portion of the link, so that only the NAME portion shows (i.e. 'ChestertheDog). IIf possible 'd like to also store the .jpg in another (field/control) on the form as well. Is there a way to mask out the first portion and cutting off the .jpg? I'm a newbie so any help would be appreciated. thanks

Rosie
Jun 5 '07 #1
2 1362
cyberdwarf
218 Expert 100+
Hi Rosie

You can try:-
  1. Use StrReverse with your image path;
  2. Look for the backslash (InStr) and store its position;
  3. Use Left(ImagePath, (SlashPosition - 1)) to slice off the image name;
  4. Use StrReverse to reverse the image name back to left-to-right.
Alternatively, you could investigate the use of InStrRev to achieve the same result.

HTH
Steve
Jun 6 '07 #2
imrosie
222 100+
Hi Rosie

You can try:-
  1. Use StrReverse with your image path;
  2. Look for the backslash (InStr) and store its position;
  3. Use Left(ImagePath, (SlashPosition - 1)) to slice off the image name;
  4. Use StrReverse to reverse the image name back to left-to-right.
Alternatively, you could investigate the use of InStrRev to achieve the same result.

HTH
Steve
Thanks so much for pointing me in a direction. I'm going now to research how to do either.
If anyone has an example to show me, it would be greatly appreciated. thanks, I'll update you with the code when I get it working.

Rosie
Jun 6 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: hurricane | last post by:
Hi to all, excuse my english ( i'm an italian student... ) I have the necessity of make a stored procedure that convert one parameter passed from base64 to binary before store in a field...
6
by: bissatch | last post by:
Hi, I have a collection of images stored in a DB. They are there for the purpose of a news system. When the user views the homepage it will diplay cropped versions of the news where the user...
15
by: Anand Ganesh | last post by:
HI All, I have an Image. I want to clip a portion of it and copy to another image. How to do this? I know the bounding rectangle to clip. Any suggestions please. Thanks for your time and...
0
by: Dana Epp | last post by:
I have a ToolBarButton that when I set it to disabled (button.Enabled = false;) causes a really ugly gray masking effect to take place. This is normal and the intended way of the button, but I...
1
by: vishal | last post by:
I am using a datagrid where there is a hyperlink column. On mouseover I get the whole link in the status bar which I want to put some static message or mask it. How do I achive this in .net? If...
3
by: ara | last post by:
Hi, I have got a table which pops up when the pointer is placed over a link,as <div id="metapopup" onMouseOver="showmeta();" onMouseOut="hidemeta();"> <table border="0" cellpadding="5"...
1
by: alokw | last post by:
Hi everyone, Here's my problem. I'd like to revamp my web site, and I have this idea. I want to create essentially a border around the screen of about 100 pixels of just black. Heres where...
1
by: arad | last post by:
I need help with masking an image in Flash (8). I have an outline of a seashell image (black and white). It's a jpg image that I inserted into Flash. What I want is for the image to appear one line...
2
by: VC | last post by:
Hi I'd like to display an imagem in a picture box, but just a portion of it Example (please ignore the dots, I use them to keep the alignment) ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.