3rd time posting this problem , still no solution

[naveen prasad]

Dear Kindly solve my problem

table t1 has fields pictures, name
in design view pictures field is ole object and
name field is text.

now in table, i have inserted some jpeg pictures in field pictures,
correspondingly written some name in name field

if we open table t1 to view.

pictures name

package n1
package n2
package n3
package n4
package n5
package n6

now i have written a small query as
select t1.pictures from t1 where name = x;

x is given in run time, like any thing as n1 /n2/n3/n4 /....
let say x is n2 now.

i am getting result as pictures
package.


I want the result of query to activate the picture when query input is given..

kindly help me how can i do it.

 

[John Spencer]

It is unclear to me as to what you want to do.

Do you want to display the picture on a form or in a report?

Or do you want to display the picture in the query's datasheet view? (I don't
believe this is possible.)

Or do you want to display the picture in some other application?

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[naveen prasad]

i just want to open picture using a query, and i want to know how can i do
it, and what should be the query ?

pls advice....

 

[John Spencer]

Good luck. You have not answered the question. I for one do not understand
what you are trying to accomplish. I asked you to expand on your requirement
and you have not done that.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[naveen prasad]

dear my problem is very simple but not getting solution ,

table t1 has fields, pictures (ole object) and name (text)
note: name is unique
i have stored jpeg pictures in table field- pictures, corresponding name in
text field

now in a form added unbound combo box c1, which displays the all the names
from name field of t1 as drop down list

my requirement is :
when i click/ selected a name in c1, it should run a query to open the
corresponding picture from table.


what should be the query to open picture.....

kindly advice...

 

[Bob Barrows]

It is probably not your intention, given that English is likely not your
first language, but that "very simple" business sounds very condescending.
This is not very simple! We are not looking over your shoulder! Also, if it
was "very simple", you would already have solved it yourself by simply
pressing F1 and finding the answer in online help.

That said, we seem to have finally reached the point where you have provided
the key piece of information to enable us to help you. You need to place an
Image control on your form and bind it to the field containing the image.
When the combo box is clicked, use VBA code to refresh the data source of
your form.

If you need help with the VBA code, post your question in one of the Forms
or VBA groups ... unless someone here is inclined to provide a generic anser
for you.

You might also search Roger's Access Library (www.rogersaccesslibrary.com)
or Allen Browne's website for a sample database containing an example of how
to do something similar to what you need. I'm sure one must exist in either
of them

 

[naveen prasad]

Dear I am sorry , if i didnt asked question in proper way..

finally I have gone through your reply, but dont mind asking again, where
can I find this image control to add on form