Comments by Pat O'Brien

Pat O'Brien 11-Sep-17 9:28am View

but a cell with a formula is NOT a null, even if it returns a null string.

Sub test()
Dim rng As Range
Set rng = [testcell]
Debug.Print "x+CellValue+x", "Has Formula", "IsNull", "Formula"
Debug.Print "x" & [testcell] & "x", rng.HasFormula, IsNull(rng), rng.Formula

End Sub

Run the above and you get:

x+CellValue+x Has Formula IsNull Formula
xx True False =IF(G7>G8,"big", "")

Pat O'Brien 14-Jul-17 8:00am View

Why do you add Total_RecepFee to the new record's Total_RecepFee?

![Total_RecepFee] = Nz((Me.txtConsFee + Me.txtIOPFee + ![Total_RecepFee]), 0)

Pat O'Brien 30-Jun-17 7:46am View

or could it be something as simple as adding an ORDER BY clause to your SQL select statement...

SELECT * FROM [TableName]
ORDER BY [slno]

Pat O'Brien 5-Jun-17 7:02am View

Then I guess that you didn't read the whole post. You DO NOT have to close and reopen the office application to see it. In fact, it can be done outside of the application.

Comments by Pat O'Brien (Top 4 by date)