Results 1 to 2 of 2
  1. #1
    snipe's Avatar
    snipe is offline Competent Performer
    Windows 7 64bit Access 2003
    Join Date
    Sep 2013
    Posts
    287

    Adding a note box to switchboard?

    Hey guys,

    My main switchboard form is unbound. I would like to add a large text box in the bottom that so my users can write notes down. Think of it like a whiteboard. I trust all 5 users, so I don't care about time stamps or restricting permissions. I want anyone to be able to edit, add, or delete text in the note. I don't want multiple records.



    I tried to bind the form to a table, and made the field a memo. Worked as I wanted, but I couldn't really think of how to restrict the enter key from creating a new record.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,772
    So you want a table with only 1 record that will be repeatedly edited?

    Set form AllowAdditions and AllowDeletions properties to No. Create the one record in table and bind form to table.

    Can also set textbox EnterKeyBehavior to 'New Line in Field'.

    Multiple users will interfere with each other's edits if trying to use at same time.

    But if don't need to save the data, why have bound textbox?
    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. Replies: 1
    Last Post: 09-27-2013, 03:53 PM
  2. Adding A Time Of Day; With Message To Switchboard
    By HMEpartsmanager in forum Programming
    Replies: 7
    Last Post: 09-26-2012, 11:12 AM
  3. Replies: 10
    Last Post: 08-25-2012, 03:25 PM
  4. Replies: 7
    Last Post: 09-13-2011, 01:38 PM
  5. Can I add a note to a Query?
    By alexc333 in forum Access
    Replies: 2
    Last Post: 07-26-2011, 11:50 AM

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