Search results

Hi, I am getting the "Procedure too large" error in a search form that I am creating. I know this is because my procedure is way to big. I was wondering if anyone can give me hints on how to break up the code, but still use it in the command button. Basically the code is a number of if...

Hi, I am getting the "Procedure too large" error in a search form that I am creating. I know this is because my procedure is way to big. I was wondering if anyone can give me hints on how to break up the code, but still use it in the command button. Basically the code is a number of if...

Hi, Do you think it is possible to create a form which will search a table which has over 18000 entries based on 13 criteria and 14 statistics. This means that for each statistic there are 13 criteria. I am trying to decide if it is feasible to code this type of form, and what type of code I...

Hi, Do you think it is possible to create a form which will search a table which has over 18000 entries based on 13 criteria and 14 statistics. This means that for each statistic there are 13 criteria. I am trying to decide if it is feasible to create this type of form. Tracy

Hi, I have a large if statment which is used more than once in the code for a form. I was wondering if it is possible to place the if statment in a function or module and then to call it. I have tried to place the if statement into a module, but have gotten a compile error "Invalid...

Hi, I have a database which is used by about 6 people on a network. Lately we have been getting the following error: "*Form_Name* has been changed since the last time you opened it, either by another user or because of another instance of it was open on your own machine. Do you want to sace...

Hi, I am using Select Case, and have been getting the following error: "Case without Select Case." I know that the select case is there. The help also said that there could be and End If missing. I have check my code and there does not seem to be an End If missing. Does anyone have any...

Hi, I have to create a search page for a large database, where the users can select the criteria they want to search for. I am basically at a loss as to how to start. I know I have to populate a where statement, where the criteria are not null, but I have no other ideas. Does anyone have any...

I am writing a querydef and am getting the run-time error '2001'. There is nothing in help on what this run-time error is. Could someone help me out and let me know. Tracy