473,322 Members | 1,493 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,322 software developers and data experts.

automatically image should change

140 100+
Hi

my form name master. it gets the value from task table.
according to taskname name the picture has to change in form.. i ve given like this to view it in folder but each time they have to visit folder.

Private Sub Image40_Click()


Dim filepath As String

filepath = "C:\Documents and Settings\anithing\Desktop\barn owls"
followhyperlink filepath
Image40.o

If Me.Picture = task Then
Me.Image40.Visible = True
Else
Me.Image40.Visible = False
End If


pls help me .
Nov 18 '06 #1
5 2517
MMcCarthy
14,534 Expert Mod 8TB
One solution would be to add a field to your 'task' table of data type OLE object. You could then link the pictures into the table in this field.

Add a Bound Object Frame to the form bound to the ole object.

I'm not sure what application you will need to set the bound object frame to use but you could experiment using he wizard.

Hi

my form name master. it gets the value from task table.
according to taskname name the picture has to change in form.. i ve given like this to view it in folder but each time they have to visit folder.

Private Sub Image40_Click()


Dim filepath As String

filepath = "C:\Documents and Settings\anithing\Desktop\barn owls"
followhyperlink filepath
Image40.o

If Me.Picture = task Then
Me.Image40.Visible = True
Else
Me.Image40.Visible = False
End If


pls help me .
Nov 18 '06 #2
indhu
140 100+
One solution would be to add a field to your 'task' table of data type OLE object. You could then link the pictures into the table in this field.

Add a Bound Object Frame to the form bound to the ole object.

I'm not sure what application you will need to set the bound object frame to use but you could experiment using he wizard.
hi

i ve tried that. its not working. error is coming. like close OLE server and restart the operation outside the MS office access
Nov 18 '06 #3
indhu
140 100+
One solution would be to add a field to your 'task' table of data type OLE object. You could then link the pictures into the table in this field.

Add a Bound Object Frame to the form bound to the ole object.

I'm not sure what application you will need to set the bound object frame to use but you could experiment using he wizard.

hi mary

if i accept the dataentry value as file location with ext. can i able to use it.

displaying it in the form as link to view. whats ur opinion.
Nov 18 '06 #4
PEB
1,418 Expert 1GB
Hi

Have you tried with unbound ole control and this code:

Expand|Select|Wrap|Line Numbers
  1. Set Forms!Orders!OLECustomControl.Picture = _
  2.     LoadPicture("Stars.bmp")
  3.  
Nov 18 '06 #5
NeoPa
32,556 Expert Mod 16PB
Private Sub Image40_Click()


Dim filepath As String

filepath = "C:\Documents and Settings\anithing\Desktop\barn owls"
followhyperlink filepath
Image40.o

If Me.Picture = task Then
Me.Image40.Visible = True
Else
Me.Image40.Visible = False
End If


pls help me .
Indhu,

I can't answer your main question, I'm afraid, but I may be able to post some helpful comments.
Your Image40.o line - what is that trying to do?
It doesn't look right to me.

Try to get into the habit of setting .Visible and other boolean properties to a calculated boolean value rather than putting it in If or Select structures.
In this case it could be :
Expand|Select|Wrap|Line Numbers
  1. Me.Image40.Visible = (Me.Picture = task)
If (Me.Picture = task) resolves to True - then .Visible is set to True.
If False, then it's set to False.

Just a suggestion but it should make your code more compact and easier to maintain and understand.
Nov 18 '06 #6

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

Similar topics

7
by: Phil Powell | last post by:
How do you detect an image MIME type if you know of the image in a directory? For example, I know of: if (is_file("$myImagePath/$myImageName")) { // FIND MIME TYPE BUT HOW I DUNNO } The...
1
by: Curzio Basso | last post by:
Hi all, I have a problem for which I wasn't able to find an answer anywhere else, maybe someone can give me a hint... I designed with XRCed a small GUI (the code is at the bottom of the...
1
by: Spike | last post by:
Hello! Im going to make a javascript for changing alot of images. But im not sure how to do it., where to start.. Ok, first.. this is the isue. I have 3 images(I call them 1a-3a). when u...
5
by: John | last post by:
I am rotating images at one location of my web site. My problem is if I set the width and height of the new image before I show the new image, the old image is stretched first to the new image...
4
by: Hee sejou | last post by:
Hi, I want to create a webpage with a jpg file whose hue value can automatically change when we browse it. Any one can help with the code? Thanks.
3
by: inonzuk | last post by:
Hi everyone, I'm new to javascript and have the following problem: I have two image buttons: 1) <td><a href="http://localhost/gamerules.php" target="mainwindow"><img onMouseOver="return...
6
by: ruca | last post by:
Hi gurus, I have a imagebutton in my WebForm, and I want that when I click (mouse down) on her the imagebutton change image and when I "unclick" (mouse up) change to the original image. Basically...
3
by: ACaunter | last post by:
Hi there, I was wondering how i could have a slider bar or something on my ASP.Net page to control the image quality.. like change it's sharpness, brightness, and contrast?? is that possible??...
2
by: satnamsarai | last post by:
it is possible to change page orientation to landscape from asp.net page? I am using window.print() dialog to print a page and I would like that page to print automatically in landscape view.
3
by: lmeeson | last post by:
hi guys, I am totally new to coding so please bare with me. I have a file upload field in a form on a PHP page for users to upload pictures, i also have the following fields in my MySQL database ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
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...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.