Click here to Skip to main content
14,601,227 members

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

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.