1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Adding & Tracking Comments

Discussion in 'Business Applications' started by JWhitehead, Nov 7, 2011.

Thread Status:
Not open for further replies.
Advertisement
  1. JWhitehead

    JWhitehead Thread Starter

    Joined:
    Aug 31, 2002
    Messages:
    189
    First Name:
    Jenn
    I'm using MS Office 2007.

    I've seen this done, but can't seem to get it to work. Any help would be greatly appreciated.

    I've created a DB to track all details about equipment - maintenance, preventative maintenance, etc. All that is fine. The part I'm having some issue with, is I want to be able to click on "Add Comments", and have a window open where I can enter anything else in regarding that equip. Then on the main form, have it relate to it.

    At this time, when I click on "add comments", it opens the window and I can add a new entry, only after clicking on the "Add New" option. I then have to select the user's name, equipment number, and enter the date of the note (all which is hidden).

    What I would like it to do is when I click the button, it will open to a new comment, passing the user name, equip #, and system date/time to the new entry. If nothing is entered, do not save.

    I know this isn't a good explaination without a visual, so I've attached the document. The login name is "user", and the password is "password" -- this is obviously just for the purpose of posting online.

    I had found something online, and copied it over, but being that the field names are not the same, so I've updated it to my field names, it now doesn't seem to work as it should. I am sure it will be a simple fix, but I can't seem to find it.

    Thank you for any and all assistance with this.
     

    Attached Files:

    • DB.zip
      File size:
      80.7 KB
      Views:
      6
  2. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    You should probably create another table for comments and have a foreign key relating back to the main table.
     
  3. JWhitehead

    JWhitehead Thread Starter

    Joined:
    Aug 31, 2002
    Messages:
    189
    First Name:
    Jenn
    I have set up "Comments" as it's own table. See the attached DB layout.
     

    Attached Files:

  4. Rockn

    Rockn

    Joined:
    Jul 29, 2001
    Messages:
    21,334
    Just create a button and an event for that button to open a new form for entering comments where the equipment ID gets passed to the new form and will create a new record in your comments table.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1025887

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice