Search results

Did you ever come up with a solution? I have the same problem

Thanks, my prototype search form does the job much more efficiently than the old way-of course-I may have opened Pandora's box because I will probably have to create search forms for every form in the database. Anyway, Do you know why the control F method was not all that slow when the tables...

Brilliant, I did some reasearch and the search form looks like it is much more efficient(and it looks like building them could be some fun on a Tuesday Morning)+I won't have to bug IT. Thanks again!

Thanks, that makes sense.

I have an SQL table with 19000 records. everything running off of this table is very slow. If I go to the table and try to Control F find the last record using a clustered index field, the search takes about 45 seconds. Is this normal? the weird thing is that If I were to create a query and type...

Thanks. Never used Modules. I will investigate. Thanks again.

oops, Me.Today was the code I put originally on the switchboard (Format(Date(), "dddd") =Me.Today default value). I guess that won't work in this situation, though.

Is it possible to run VBA code within a macro? What i want to do is run one macro for certain days of the week and another macro for other days of the week. I could just stick the code in the button on the switchboard but I could see an overzealous user changing the switchboard and then the code...

Thanks, That worked like a champ. Am I right in assuming that Dlookup can only lookup the value in a table and not preform a query? Even so, this is a cool tool to have. Thanks

I want to set the "Fee" Field on a form to the penalty value in the Penalty table where Penalty = "Non-Compliant Docs" This is what I came up with but it keeps telling me there is an error in the From clause. This is my first time using SQL on Forms. Any glaring flaws. Would this even work...

thanks a lot. I know only the basics of SQL. I am doing this in the graphical access query. Do you know the appropriate syntax using access instead of SQL?

I get an excel report from outside the company that contains a text field that can have a range of values but all we want to import is the letter code before the / sign. The field may be CFS or CFS/CY or CY/CY/CY or anything but all we would want to import in each case is the data before the...

I tried to improve your rep but I guess you helped me last time on a project so I can't. Thanks nonetheless

Thanks for your help. I'll just change to small integer and all should be well. Thanks!

thanks, So I can change to small integer and then set it up as True false in Access and it will accomplish what I'm trying to do? I have set up many bit fields and they appear to work. I guess the server picked this one to mess up.

yep---Is Null and Is Not Null work for True and False. I'm thinking maybe I should get back into enterprise manager and delete/add the field again.

also, I'm writing queries graphically, not in SQL

Thanks, good to know so simply adding True or False will no longer work? Oddly enough, it looks like it shows the appropriate records when I select Is Null.

I recently added a bit field to an SQL table. The table already had bit fields in it before that worked properly. I added a new one. In access, when I run a query on it, no records are returned when I enter anything as a criterion. True, False, o, 1...doesn't matter. when I leave the criterion...

I am trying to adopt a consistent naming scheme for my forms. When I try to change the name on a subform, the mainform no longer dsiplays it and I can't find an easy fixt to change the name. Does anyone know? thanks.