Recent content by DKEND

Thanks for the help everyone. This is not an Access problem after talking with the DBA I found out it is a setting for our RRDG ODBC called MaxFetchRows Thanks again Darin

I am selecting records from DB2 into a temp table in Access. My problem is that every time I run this sub it will post a Warning that says you have read 1000 rows. Retrieve another 1000 rows? Y/N..... I have set the warnings to False, but still get the message. There are 25,000 rows in this...

I have one RevOrd1. I am trying to stay clear of having multiple RevOrd1-57s. RevOrd1 has these values in it Name, Symbol, CompValue, Bothvalues(which is symbol and Compvalue combined), a,b,c. I still have 50 combos (actually 57). Each combo has the following values. Name (which is unique...

The combo actually has two other fields in it called Symbol and CompValue I set there width to 0. I joined these two fields in the combo so the user can see both it is not always =3 it could be >3 etc and called this BOTHVALUES. This allows the user to see the choices they made in the combo...

Doc_Man Thanks for helping. I do have one thing to ask. I am not actually filtering a table. I am doing the selection/filtration on a query. RevOrd1 (the qry) is ran on a db2 table. It contains all of the possible combinations of A,B,C,Name,BOTHVALUES and there are lots. can I do this same...

Combo X contains the values Name and BOTHVALUES. The query RevOrd1 contains the values Name, BOTHVALUES, A, B, and C. For exp RevOrd1 Name BOTHVALUES A B C Dog =3 1 2 3 Dog =5 1 3 4 Dog =5 1 6 8 Cat...

David, I am trying the sub that you posted, but it may take awhile with my limited VBA experience. I do understand that the AND will not work, but the OR is not what I need. For example lets say that a person selected 2 combos X and Y if they make a selection for combo X then From query...

The Message box reads as the following (([qry_RevOrd1]![BOTHVALUES] = '=2' AND [qry_RevOrd1]![Name] = 'Type') AND (([qry_RevOrd1]![BOTHVALUES] = '=Y' AND [qry_RevOrd1]![Name] = 'ALLOW-DK')) These values are correct with the ones that were chosen in the combos so everything is working...

David I am getting a runtime error 3075 that says I am missing a ) ] or item in my query expression. The syntax looks fine to me as far as the parens etc. I think the problem may be due to the structure of my RevOrd1 query. RevOrd1 has several columns; Name, BOTHVALUES, A, B, C. Now when...

David, Yes you are corect I want the rows that match the criteria selected in all of the combos my terminology was a bit backwards (I meant eliminating the rows that dont match all of the combos). I am going to try and get this in today, but I got a 4 day weekend coming up so if not I'll let...

David, I used the sub with only ORs and all was well. But I need to use it with the ANDs, and I am getting an error that InStrRev is not a valid function. I am using Access 97 on an nt machine. I am guessing that the Rev part is what access is complaining about. I also want to make sure...

David, You have it correct. The problem is that I need each combo box selection on Form2 to eliminate some of the rows in QueryA. I tried putting this in each of the criteria for Query2 [Forms]![Form2]![combo1] etc. but if the combo was not made visible then it would still ask for the value...

ok I am going to try and explain this I have a form (Form1) that has about 50 Option buttons. These option buttons control combo boxes that are located on Form2. When a combo box is activated it needs to filter data in a query. This query is used to generate a report. Now if only one combo...