Search results

I learned a long time ago (but not soon enough) that sometimes you need to simply accept someone’s opinion of you and move on. Change what you have the capacity and desire to change and be the grownup in the room.

I mentioned this forum about a year ago to a very well-respected Access developer and he/she stated the forum was avoided because of the contentiousness. Maybe others avoided participation for the same reason. I have had a few moments where I considered buggering off for that reason only.

With your original code all you would have had to do to get around your error was to set a break point and step through your code. That's why you should have structured your code with Select Case like: Select Case Me.cboqueries Case "FILENO" Me.lstsearch.RowSource = "qryFILENO"...

Wow! A question asked and within about four hours there were seven great answers from our pool of volunteer experts. Kudos to this site and all members (those who ask and those who answer).

Replace the multiple If Then statements Select Case.

Do you have contracts without a related customer record? Is there a default value in the Customer field of the contracts table?

Your post mentions "SpecializedAssignment columns, Active (checkbox), and columns Month/Year columns". This implies you are storing data as field names which goes against normalization. For instance, if you have column names like "DaysTardy", "DaysExcused", "DaysNotExcused" then you are creating...

My wife has drug me into watching all of these.

Ken, it’s a bit suspicious that you have such a deep understanding of these laws 🤨

Do you get intellisence when typing DAO.

The calculations the production supervisor wanted me to use were wrong creating higher bonuses. I’m not sure why I was let go, if it was because I found his error or I found his error 😁. I also avoid using yes/no fields since the future holds lots of “maybes”.

I had two manufacturing clients at the same time and was creating similar production reports. One client was basically averaging averages or something similar that overstated production which over paid bonuses. I was called into a meeting to explain my findings with the production manager (hired...

I had an internal customer who designed the fields for me and stated there would always only be two steps in a process so there is no need to normalize. I actually built the application with the proper structure under the hood. After a few months the customer asked what it would take to add more...

I’ll hoist a white flag with my red one 😁

This question raises a red flag to me. If the two queries, q_Male and q_Female, have the same fields and source data (other than the gender), I would consider adding a gender column to one query with either an M or F value. Then use the Link Master/Child properties of the report and subreport to...

Is the label on the subform in the header or detail section? I would first make sure it’s in the subform header.

Is it possible to provide a sample of your desired output?

I have found that an Access VBA function name or other reserved word might have been defined elsewhere in the code but it doesn't seem plausible with vbDefaultButton2.

I'm not sure how we can help without seeing the complete expressions in you text boxes. Are the totals adding the names of text boxes from the detail section? The use of many DSum()s doesn't look efficient to me. Your table structures or other may dictate this. Also, the alignment (or lack of)...

I never program my If statements on a single line. I would dim response as integer, split the lines, set a breakpoint, and walk the code to confirm the values.