If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
3rd time posting this problem , still no solution
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. |
#3
|
|||
|
|||
3rd time posting this problem , still no solution
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. . |
#4
|
|||
|
|||
3rd time posting this problem , still no solution
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. . |
#5
|
|||
|
|||
3rd time posting this problem , still no solution
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. . . |
#6
|
|||
|
|||
3rd time posting this problem , still no solution
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" |
#7
|
|||
|
|||
3rd time posting this problem , still no solution
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" . |
#8
|
|||
|
|||
3rd time posting this problem , still no solution
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 |
Thread Tools | |
Display Modes | |
|
|