Search results

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.

I realize this was your version and expect the OP would understand (and possibly post text SQL versus an image). I wanted something to simply copy and paste.

Based on your location, should you use ";" in place of ","? DateAdd("m";[factor];[dailydate]) AS Expr1

Tell us exactly what you want to see in the subform and how you expect to add a new record? Did you consider changing the properties of the subform to Add mode?

Is there a reason you don't simply enter the new check at the New Record on the subform?

A method that has always worked for me is to change something in the record source of the report to limit the records returned. For instance if you have an employee table [tblEmployees] and want to limit the report to a specific EmpID, create a query [qselEmployees] with the SQL of SELECT * FROM...