Results 1 to 4 of 4
  1. #1
    Jon1092 is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    6

    Clicking a button to text.


    Hi There,

    I'm trying to find a simple answer for a question that should be quite easy but I can't work it out.
    So if you are a active question you will have a yes/no box. If a customer rejoined I would click yes to the yes no box. When I click yes I want it to put "The customer re-joined in this date" into the notes feild.
    I would like it added to the text not replace the text already in there.
    I've tried many things but can't seem to do it.

    Am I missing something simple

    Thanks in Advance Jon.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Code like:

    Me!fieldname = Me!fieldname & ";" & "The customer re-joined on " & Date()

    But really should have a separate dependent table for these comment entries, each comment would be a record.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Jon1092 is offline Novice
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    6
    That worked brilliant, what was the code for a new line again. Sorry just learning and trying to teach myself. When it comes to notes and important info not many people will have the access to that info. This is not important information this is only a reference so it's going in the common notes. I didn't want to have another table to only store it. Do you still think I should

    Thank you so much for your help

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    I already said you should but it's your decision.

    Another approach is to use a Memo (Long Text) type field and set AppendOnly to Yes. Then research topic Column History.

    Is your first sentence in last post a question?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Clicking a button programmatically
    By peterFisp in forum Forms
    Replies: 6
    Last Post: 09-26-2019, 06:38 PM
  2. Replies: 4
    Last Post: 08-25-2019, 12:16 PM
  3. Replies: 2
    Last Post: 05-10-2016, 08:53 AM
  4. Replies: 2
    Last Post: 09-15-2015, 03:08 AM
  5. Comments when clicking a button
    By Juan4412 in forum Programming
    Replies: 4
    Last Post: 06-23-2011, 04:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums