Adding & Tracking Comments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

JWhitehead

Jenn
Thread Starter
Joined
Aug 31, 2002
Messages
189
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.
 

Attachments

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.
 

JWhitehead

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

Attachments

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.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Top