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...
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...
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...
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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.