We have a memo field that serves as a scratchboard-type of notes field. Several command buttons allow users to enter common phrases to the memo field by just clicking on them.
Me.reqnotes_memo = Me.reqnotes_memo & " " & vbCrLf & date & "(" & Me.txtinit & ")-" & " Waiting on programming. "
The design is terrible, but for what it is used for- it serves a purpose. Having said that, here is my question:
I need to have a user add data to reqnotes_memo field in this table from a screen other than the one mentioned above. So his data will be appended using an update query. I know how to do that with the exception of the vbCrLf. How can I do a carriage return in SQL?
Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works
The attack works by targeti…
Learn how to number pages in an Access report over each group.
Activate two pass printing by referencing the pages property:
Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …