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

    Disable auto contract on ActiveX treeview control

    So simple... Thanks!!
  2. swaybright

    Disable auto contract on ActiveX treeview control

    btw, I am using Access 2013 with Microsoft TreeView Control, version 6.0
  3. swaybright

    Disable auto contract on ActiveX treeview control

    I have an treeview control on my form and I am working on coding specific actions when nodes are clicked using the .HitTest(x,y) function. The problem I am having is when I single click (right or left) on a node that has children, the treeview control automatically expands the node so the...
  4. swaybright

    One to one relationship table design problem

    Ok, so I have a table for measurement records as Duane suggests. I am running into an issue in that some measurement values are text and others are numbers. Any suggestions as to how to keep text out of number fields? Thanks!
  5. swaybright

    One to one relationship table design problem

    Laurie, Thanks for the question, because I have thought more about the point you are making. Having stepped back from the problem, I think rather than having the awkward 1 to 1 tables, I should instead place the a Sample foreign key into the conditions table and create 3 new tables: TestList...
  6. swaybright

    One to one relationship table design problem

    I chose to make a new table for each test because each test has different measurements. So one test will measure say length and weight, while another will measure height and still another may measure softness and stretchiness. Each test has different fields to put values in, so if I were to...
  7. swaybright

    One to one relationship table design problem

    I am trying to set up a correct normalized table structure that involves what I supposed should be a series of one to one relationships, but as I am thinking through the outputs of the database, I am not so sure. The basic problem is as follows: I have a table of samples upon which I may or may...
  8. swaybright

    Finding parent records that have only specific child record values

    Thanks Duane! I think I am on the right track to solve the problem. I found the FAQ for the listboxes. http://www.tek-tips.com/faqs.cfm?fid=6326 I ought to be able to slide the items between the IN and Not IN boxes and have super flexibility to build the query to not only as I described but...
  9. swaybright

    Finding parent records that have only specific child record values

    So I created a subquery with the same syntax as above except with Where JellyBeans.JellyBeanID NOT IN (4) as the criteria for BowlID So something like this: Select BowlID From Bowls...(all the join statements) Where JellyBeans.JellyBeanID IN (1, 2, 3) And Bowls.BowlsID Not In (Select Bowl ID...
  10. swaybright

    Finding parent records that have only specific child record values

    Thanks Andy! That almost does what I want and it helps me get moving in the right direction. However, it returns all bowls that have red, white or blue regardless of the other colors that are present. I would like it to exclude bowls that would (in your example) contain black so that the...
  11. swaybright

    Finding parent records that have only specific child record values

    My actual application is a bit more complex, but this example demonstrates what I want to accomplish. I have 5 tables: JellyBeansJellyBeanID Color CupsCupID CupName CupDetailsCupDetailsID CupID JellyBeanID NumberofBeans BowlsBowlID BowlName SurveyScore BowlDetailsBowlDetailsID BowlID CupID...
  12. swaybright

    entering time without typing the colon

    Is there a way for users to enter a time into a date/time field without needing to type the colon? Specifically, users should input time in military format but if they forget to put a zero in front of times earlier than 10:00, I would like the field to correct and accept the value...
  13. swaybright

    too few parameters expected 1 in a query referencing a subform control

    Oh. I see, thank you! SW
  14. swaybright

    too few parameters expected 1 in a query referencing a subform control

    Great point, Andy. that would have certainly been my next issue. Thanks for thinking about my problem. I have implemented PH's solution with great success. I am still curious about why my query failed. It feels like some basic limitation in access; like one cannot reference that many nested...
  15. swaybright

    too few parameters expected 1 in a query referencing a subform control

    Very nice solution! Thank you. Your approach is much more elegant than mine. Any thoughts on why my approach failed? Do I have a syntax error or a logic flaw? In this case, your simple approach is best, but I may run into a future case where something like what I tried would be a necessary...
  16. swaybright

    too few parameters expected 1 in a query referencing a subform control

    I am trying to create a way for users to fill a number of default records in a subform at the click of a button. the form is structured with subforms 3 layers deep (form-->subform1-->subform2-->subform3). Subform3 is the one I want to have the button fill. My approach is to have a button that...
  17. swaybright

    Create a query field to identify records by a date range

    Thanks PH! This is exactly what I need! And it is much simpler than I made it out to be, I was really over-thinking this problem. (note my sheepish grin) SW
  18. swaybright

    Create a query field to identify records by a date range

    I am sure this has been addressed before, but I am struggling with how to ask the question properly. My basic problem is that I have multiple data streams that I am pulling together from independent sources where the only linkage is date and time. I would like to assign an ID from table 2 to...
  19. swaybright

    Vlookup error for dynamic lookup value

    The value in B4 is 1 (not calculated) the values in D are are integers (1 to 48) all cells are formatted as general. John, you hit it right on the head. The lookup value is a string and the values in the first array column are numbers. I employed the Value() function to correct the problem...
  20. swaybright

    Vlookup error for dynamic lookup value

    The formula: =VLOOKUP(B4,$D$2:$Z$95,13,FALSE) is returning the #N/A error if I replace B4 with the value in cell B4, the function returns the expected value. I have XL version 2002(6789.6714)SP3. I have noticed that this error occurs for some users, but not others. Does anyone know how to...

Part and Inventory Search

Back
Top