I have a question about append a text (txtNote) that user enter to a field named note in the database.
I found when the note is not null, it will append to it. But if the note is null, it didn't append the txtNote to note field. The following is my code. Did i do anything wrong. Thanks.
Private Sub cmdSave_Click()
On Error GoTo Err_cmdSave_Click
If txtNote.Value = "" Then
'MsgBox "The note field can't be empty"
Yes, thanks. I got it work. Thanks again! I still have a question about how to write the total amout from a query to an existing excel which is a template. I need to put the amount to a particular cell. I have no idea how to do it.