Click here to Skip to main content
15,742,323 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.