Recent content by swaybright

So simple... Thanks!!

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

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

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!

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

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

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

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

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

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

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

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

Oh. I see, thank you! SW

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

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