Search results for query: *

Hello, I'm a newbie to access and have a little problem on how to proceed. I have a form with 3 lables and 3 text boxes and a button called search. Users will be able to enter data in one, some, or all textboxes to retrieve data from one table. What I would like to do is to be able to...

Eupher and J.McBeef I want to thank you both for your patience and perservence in helping me to overcome my inadaquacy in VB. I have learned so much just from posts here and studying code, more than any class could've helped! For this I thank you! I converted the above code to ADO and...

Ken S. Yes, every record as all 40 parameters in it: table1: date parameter1 parameter2 parameter3...parameter40 now, whether they have values in it or not is totally optional. if they don't have values in it, then it really dosen't matter that a check needs to be done for that particular...

Thanks J.Beef for the reply... Acutally, i needed to check every parameter in table1 that is in table2. This does set me in the right direction, any further info would be great as well. This is very new to me and I appreciate the responses being very helpful. Thanks!

Ken, Was this the information you were looking for? I'm guessing this would be some nested for loops? Thanks again

Ken, Thanks for the reply. There is a list of about 40 parameters in table 1 and yes, the min/max is different for each parameter. I appreciate your time and effort in helping me. Thank You. jags

Re-Read my post and don't think i was too clear. table1: parameters Min Max parameter1 0 10 parameter2 5 9 table2: date parameter1 parameter2 4/2/03 11 8 I would like to see if parameter1 in table2 is within the range specified in table1, if...

Jungles and Eupher... I want to thank you very much for taking the time to help me out, both of your posts helped quite a bit in getting me started. A start for both of you... Thanks!!! If I wanted to compare the value of each field to another field in the database and error log it if it...

J.McBeef...I sincerly thank you for your time and effort, I will try this out tonite and keep you posted as to my progress. As a side note, there are about 40+ parameters (DO, BOD, PH, Zinc, Cadmium, ... n), is there anyway to automate the field selection routine instead of declaring each one...

Sorry about that J.McBeef Well, the DO and BOD are coming in through an import (Transferspreadsheet) to an access table (table1). So, there really isn't a min or max value from what i would see. Now, I do have to check to make sure that DO is between 1 and 10 and BOD is between 3 and 25. This...

thanks for the reply jungleMcBeef, the field sizes for the fields in the database are all 50 (is this waht you were looking for?) Thanks.

Hello all... I've been working on this for days and finally thought I'd post and see what other ideas I can get. I have two tables: table1: station_ID DO BOD 1 5 <20 2 <10 6 table2: station_ID DO DO_Commnet BOD BOD_Comment 1...

Lets try this again...I don't think I was totally clear...my brain is almost dead, so please bear with me! I have a table(table1) containing 10 fields(sector, case#, date, time, IBRCode, Address, suffix, direction, city, state). I also have another table called table2 containing 2 fields...

thanks for the responses...there appreciated!! :-) Could you be kind enough to point me in the right direction of where to learn more about VBA modules!? thanks

Yes, I could make another table -- how would I go about joining the tables?? Through some link of some sort?

Hello all... My first post and I'm coming from a SQL Server 2000 background. So, please be kind... :-) In my select statement I'm using the IIF statement to reference some codes, but I seem to keep getting an error saying that the Expression is too complex in the query expression. Is there...

Hello there... I'm using windows 2k professional to log on to a windows NT 4 server -- which authenticates me. My problem/quesiton is that my pc belongs to more than one domain over our network, but at login I only see the one domain that i have joined... how is possible to be able to select...