Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. VBA2007

    VBA code to display multiple images in sinfgle Form

    Thanks, Finally the download file is working. This seems perfect. I don't want too many functionalities and you helped me to make a dynamic project that could even be modified or used in future. As I wrote earlier this is just for kids and I think this is more than enough. Will put it little...
  2. VBA2007

    VBA code to display multiple images in sinfgle Form

    Its again showing the same error. Is the demo file size 564KB ?? Everytime I am downloading a .accdb whose size is 564KB thats showing the "unrecognized format" error when trying to open. I am a student but in some other stream. Have been asked to volunteer to design this for middle school...
  3. VBA2007

    VBA code to display multiple images in sinfgle Form

    The demo link is not working. After the download when I am trying to open, its showing a message "unrecognized database format". Could you please re-send the link. The whole thing sounds so complicated. Will try to take things one by one. I am just a novice and not aware of how much we could...
  4. VBA2007

    VBA code to display multiple images in sinfgle Form

    Thanks MajP Atlast, the query is executing perfectly. Along with the previous code I just added a small statement as suggested by MajP (I guess an expert in VBA) Private Sub cmdCalc_Click() Forms!frmGrid1.Requery CurrentDb.QueryDefs.Refresh DoCmd.OpenQuery ("qryGrid1") DoCmd.Requery End...
  5. VBA2007

    VBA code to display multiple images in sinfgle Form

    I just made a small change in the code for the command button on click: Private Sub cmdCalc_Click() Forms!frmGrid1.Requery CurrentDb.QueryDefs.Refresh DoCmd.OpenQuery ("qryGrid1") Now this is showing the ones that are selected instantly for the first time. In other words, working perfectly...
  6. VBA2007

    VBA code to display multiple images in sinfgle Form

    Please see the attached file. Thankshttp://www.mediafire.com/?10ntpnhb7s0yenn
  7. VBA2007

    VBA code to display multiple images in sinfgle Form

    By using order by clause, all the items are now arranged according to the ID. I don't know what I was doing. Sorry, I wasn't aware of the fact how yes/no values are stored internally. In that case my query is working properly. Right now, I am just checking if the query is functioning properly...
  8. VBA2007

    VBA code to display multiple images in sinfgle Form

    Good Morning, I am back with more problems. The query seems to be working fine but whenever I am selecting a checkbox and then de-selecting it and again re-selecting it, in the query view the "Selected Column"(yes/No Data Type) is displaying -1 instead of 1. How to fix this...
  9. VBA2007

    VBA code to display multiple images in sinfgle Form

    Elimination of blank record worked perfectly. My other question is regarding how to track the checkboxes if they are selected or not. In your earlier post you wrote that I need to use a query to do that. I made the query but don't know from where I should invoke the query and pass the values...
  10. VBA2007

    VBA code to display multiple images in sinfgle Form

    Sorry, its working I just saw that in the delete statement I did not mention the name of proper table. aahhh At last its working. Thanks a ton for your help. I still have a quick question, at the end of the form appears to blank checkboxes with no images. How to get rid of them?? I guess I...
  11. VBA2007

    VBA code to display multiple images in sinfgle Form

    Hello MajP, I did make changes in the tblGrid and its working but when should I call the "query"?? Moreover even when I made the two statements "makegrid" (calling function) and "me.requery" as comment still its showing the images. The only problem is that the same grid is repeated 10 times...
  12. VBA2007

    VBA code to display multiple images in sinfgle Form

    Thanks I will try to do this. Hopefully it will work for me. Thanks once again:)
  13. VBA2007

    VBA code to display multiple images in sinfgle Form

    Wow, you are great. Thanks a lot for your help. This is really good:). One more thing, actually this project is meant to calculate the nutritional value of fast food items. So I wanted to put checkboxes with each image. When anyone clicks on number of checkboxes I am planning to calculate the...
  14. VBA2007

    VBA code to display multiple images in sinfgle Form

    I am aware that image control could be bounded to the table but I don't know how "image control1" will map with record 1st "image1" and "image control2" will map to record 2nd "image2" from the same field and so on... I can't figure out how to connect individual control to an individual record...
  15. VBA2007

    VBA code to display multiple images in sinfgle Form

    Thanks a lot MajP for replying. I am using Access 2007 and storing the path. The coding for displaying the images in the form by extracting the path and the image names from the table is not that difficult. For the 1st option, I can definitely make a query but I don't know how it will work for...
  16. VBA2007

    VBA code to display multiple images in sinfgle Form

    Hello Everyone, Can anyone please help me with the problem of displaying multiple images in a single form?? I want to display all the images in a "grid" or something like that. But unfortunately within a form its only displaying one record at a time. The image control is bounded...

Part and Inventory Search

Back
Top