Search results

Isn’t there payroll software that does all of this for you?

Does your code compile? I don't see an "If ... Then" line in Private Sub OrderDtl_frm_Exit(Cancel As Integer). I hate using ElseIf when it is much easier to use and maintain Select Case.

Conditional formatting does allow disabling. In the following form, I have set up conditional formatting based on even or odd CompanyID values.

I have used a solution with a hidden text box in the form header to store the primary key values of the selected records. Then create a conditional formatting rule that determines if the current record's primary key is contained in the hidden text box. You would need to have some code in the...

You can test your code/functions in the immediate window (press Ctrl+G) and enter the function with some sample values ?ReturnData(1, 50000, 25000, 1000, 2500) This will run your code and return the results. Play with a variety of different values/scenarios to confirm all possibilities. You can...

What are the expressions in the detail section and form footer?

You could try Sum() the statement from the text box. =Sum([your statement here])

I took one of your expressions and began creating a function with comments about the process I go through in your other thread. You need to start the conversion and a new thread when you begin to stumble (we all do).

Here's how I would go about converting the expression into a VBA function in a standard module named modBusinessCalcs. You can test this in the immediate window by using: ? YourFunctionName(value1, value2, value3,...) You should also understand how to add a breakpoint to allow your to step...

Converting on paper could look like a process flow diagram. There are true/false questions that direct the next process/decision. As you need a new input to the process, it comes from a new argument in your function.

One of your issues is the lack of normalization. You have activities and engagements in fields across rather than creating new related records. I am attempting to normalize tblChallenges with a union query. It will take a little work. How do you calculate Planned, Engagement, and Achievement...

I question the need to save the values in a table. Most of the fields you think you need to save violate normalization rules. Your situation might be unique and require saving copies of values.

Apparently, another opinion was needed to reinforce the consensus here.

Every time you modify your code, you need to compile it to check for errors. This assumes you use Option Explicit at the top of every module.

Did you attempt to compile your code?

There is no date column, only a WeekNo. Did you want to use the WeekNo as the column heading? If WeekNo is the column heading, which columns create your Row Headings and which one column/field do you want to use the value? Can you create and share an Excel that mimics your desired result?

JohnPapa’s profile suggests Cyprus. Sadly, I had to google map it 🙁

Wow! A link to Ken Snell’s great Excel code. He’s been gone for over 4 years yet still is contributing ❤️.

With the code I suggested with the code in the link, it’s very easy to reset the SQL to the original. You can also build a fairly sophisticated where clause, apply it, and call it from any form. Using a control on a form limits you to having that form open and setting the correct value.

I would look into antivirus software. Try disabling to see if performance improves.