Search results

cool down men☮️🤣

i never see anything like that on the thread, not a single clue. while on your part, lots of doubt on your own code.

just link the 2 objects on those 4 or 5 fields.

see the query now in design view and datasheet view.

the OP on the different thread did not say anything that it works. you just assumed it did.

i am guessing it should be grouped on those 5 fields

does it conform to what microsoft said: https://support.microsoft.com/en-us/office/irr-function-64925eaa-9988-495b-b290-3ad0c163c1bc it need At Least 1 negative value. the OP might not be having a negative value (or 0) on the start his data.

from chatgpt: Function IRR(CashFlows As Variant, Optional Guess As Double = 0.1) As Double Dim MaxIterations As Integer Dim Iteration As Integer Dim Rate As Double Dim NPV As Double Dim Derivative As Double Dim Epsilon As Double Dim CashFlowSum As Double...

what is the data type of the variable you are assigning the result? double also? the Initial (first value) to pass to your IRR function should be of Zero (no income yet) or Negative value (initial investment you put to the business).

lock file on BE side will not be deleted until none is using the be.

actually you only need 1 field, [ReceivedDate] and the other is Calculated using a query, use the query as Recordsource of your form. Select [receivedDate], DateAdd("ww", 1, [receivedDate]) As DeliveryDate From YourTableName;

here is your db using Query as Recordsource of your dashboard.

resolve Post#8 first before anything else. goto VBA, on menu->Debug=>Compile.. and see the errors you have on the code.

i would go with Josef P. solution. you will still get error on your 1st solution if there is a double quote (") on your [Film Title] field.

back to my old skul..🤣

Skol is also an Access add-in developer.

the query now is filter using: IIf([Forms]![home11]![Text8]="(All records)",[Nationality],[Forms]![home11]![Text8]) i change the Recordsource of the Text8 combobox, check it out. added Load Event Macro to the form.

here test your db.

change the filter of your query to: IIf(IsNull([Forms]![home11]![Text8]),[Nationality],[Forms]![home11]![Text8]) then you can blank the combobox and press the command button on your form.

SmartPension.DefaultValue = """" & DLookup("EmployeePensionContributions", "tblSalary") * -1 & """"