- 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.
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
-
80.7 KB Views: 6