Recent content by carpet

Thanks so much all - with your help and some banging of head against a brick wall I managed to get this to work with recordsets and loops eventually!

Thanks for your help chaps but for some reason this is proving to be tricky. If I use pbaldy's method then it compares the string "Tx" to the string "Tya" instead of the values. However if I string the identifyer together, as in "T" & x and "T" & y "a", print the string to the immediate window...

I may have missed some VBA basics (wouldn't be the first time!) but I think that would just compare, for example, "T1" and "T1a" rather than the values assigned to each variable. instead I need, for instance, if T1 = 875634 T2 = 13452 and T1a = -543234 T2a = 875634 to pull the T2a value...

I need to compare 2 sets of vales obtained from multiple tables and based on mulitple criteria. I have up to 100 values in set A (Named as T1, T2, etc, T100) and another potential 100 values in set B (Named T1a, T2a, etc, T100a). I need to compare each value in set A against each value in...

Have been stumped by something silly again... Following doc's recipe analogy (which really helped me think through this btw!) how do I go about searching for recipes by ingredients? I need the option to search by one, multiple with OR and multiple with AND. I've played with filter by form...

Thanks so much for your reply, Doc man I had managed to get pretty far into a design with sub forms, junction tables and forms before stalling due to some problems I could just not get around. I'll look into some of the other functionality you've mentioned and see if I can't get further...

I am trying to construct a database which tracks experiments. The aim is to log all the equipment used and track which variables were selected such that the information can be searched through later and the results (saved on the network) can be found. I have the following information needed...

Thanks so much for the info. Do you happen to know if there's a way to automate that process such that the user just inserts the string into the field and access autogenerates the ID from the table? It's cause the field/Id table will have about 150 entries and the user will need to insert up to...

I'm an access toedipper and I want to be able to designate a specific ID number to a user populated field. I'm sure I could do this in excel but it seems trickier in access so I may be approaching it from the wrong angle. To clarify, as a user populates a form I want to then be able to run...