3rd time posting this problem , still no solution

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.

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 wrote:
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.

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" wrote:

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 wrote:
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.


.

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 wrote:
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" wrote:

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 wrote:
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.


.

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...


"John Spencer" wrote:

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 wrote:
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" wrote:

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 wrote:
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.


.

.

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 wrote:
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...


"John Spencer" wrote:

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 wrote:
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" wrote:

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 wrote:
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.


.

.

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

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


"Bob Barrows" wrote:

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 wrote:
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...


"John Spencer" wrote:

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 wrote:
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" wrote:

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 wrote:
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.


.

.

--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

As you seem to be interested in associating images with a record in a table
you might like to take a look at the following file:

http://community.netscape.com/n/pfx/...apps&tid=23913


This demonstrates, using a simple address list as an example, how this can be
done using Image controls in a form or report and storing the path to the
image files in a text field. Multiple images can be attached to each record
and one or more image for the current record selected and viewed on demand in
a form or report.

If you think it might be useful I do have a more developed version which
allows multiple records to be included in the report, with one or more images
selected for each record. I'd be happy to send you this later version if you
mail me at:

kenwsheridanatyahoodotcodotuk

Ken Sheridan
Stafford, England

naveen prasad wrote:
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

It is probably not your intention, given that English is likely not your
first language, but that "very simple" business sounds very condescending.
[quoted text clipped - 105 lines]

.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201002/1