Search results

Figured out the problem. It turns out one of the few queries I run didn't return any information and was then making it look like none of my DLookups were working correctly. The issue was that only certain records were lacking the needed information. Once I put that information in I had no...

The combo box has a few columns. The first column is the autonumber. All items in the combo box come from the main table called TestRequestTable. The combo box only allows items that are active and used at that facility. Originally I only had an issue with one record. It seems that more records...

I have a dlook up that I use on a form. It works on all items in the combo box except one. So all other results are working all right. So I believe my code is working alright. I have checked the record to ensure that nothing seems out of place to cause the issue. I have run the query that the...

Cool thanks for the help. I will keep that in mind for the future. I was just trying to elimate duplicate code and simplify things that can be simplified.

Is there a way to pass the err.number & err.description to a function. For example On error goto errorhandlersome codeErrorhandler:Call errorhandler functionI tried something along those lines and it sets the err.number & err.description to 0.

Ok I think I understand what you are suggesting for the length of the code. If i am wrong please point me in the right direction. I should break some of the code off into fuctions as I am looking for a result. Then to avoid a exit sub put things into a big "If" statement as many results could be...

How would I go about breaking the code down into a sub routine? The reason that I put exit subs in there was because I have the system checking things with the use or checking the form. If certain criteria isn't met then I don't want to code to continue. So what recommendations would you offer...

at i have is a user form that is used for requesting work in out test lab. When a user clicks submit the system does things like ensure that the test request number is unique, checks to see if the user is resubmitting a test request, checks for blank fields, and eventually creates a folder on...

Just want to say hello. Started using access about a year and a half ago. Had a supervisor mention some things that he had at his last job and I took it upon myself to make them happen here. Since then I have designed a database that logs all testing that is submitted to our lab here. I have...