Search results

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.

There was a recent discussion regarding the Onpaint. Use the forum search with OnPaint.

Can the code and use conditional formatting.

You asked for help without providing any information about your environment or controls. Do other forms/reports open okay?

There is a method using a single generic function for almost any multi select listbox here. It would not be the most efficient with larger numbers of records.

If the number of records isn’t large, you could add a new column to the query using DCount().FindDup: DCount("*", "[your table]", " PKField<>" & PKField & " And Year(SomeField) = " & Year(SomeField)) I typed this on my iPad so there are bound to be errors.

Elaborating would be easier if you provided a table structure and possibly significant field descriptions.