VBA Code to Append a Record not working

[SteveSchapel]

Lovely, Bill.

 

[vbaInet]

By the way, you can still write them on one line too. I tend to write my strings on one line and my ints on another etc:

Dim stDocName As String, stLinkCriteria As String, strLoanMessage As String, strAppMessage As String, _
    strReason As String, strSQL As String, strUserID As String, strMesg As String
Dim LID As Integer, AID As Integer

 

[boblarson]

Is this better?

No, not perfect enough. You need to have the longest one on top and the shortest on the bottom... <lol - just kidding >

 

[PNGBill]

No, not perfect enough. You need to have the longest one on top and the shortest on the bottom... <lol - just kidding >

Nearly did though