 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / August 2006Adding an optional field or be able to add a field using a command
I am trying to find a way to be able to add a filed by using a command button. I have a notes field and I would like to be able to puch a button on the side of my form and then have another field of "notes" come up and be able to do that any number of times. If you need an unlimited number of notes associated with a record, you will need to modify the design of your database and your form. Database: You will need a child table to the table you are working with. If all it needs is a memo, then the table only needs a primary key of its own, a field to carry the primary key of your main table (as a foreign key), and the memo field. Form: Take the memo field off the form. Add a subform based on the memos table. Use the subform to enter your notes. > I am trying to find a way to be able to add a filed by using a command > button. I have a notes field and I would like to be able to puch a button on > the side of my form and then have another field of "notes" come up and be > able to do that any number of times. This isn't really working for me, I guess I need step by step instructions. Is there a way I can use a command button to add this? > If you need an unlimited number of notes associated with a record, you will > need to modify the design of your database and your form. [quoted text clipped - 11 lines] > > the side of my form and then have another field of "notes" come up and be > > able to do that any number of times. There is no way to do all this with a command button. You can't have an unlimited number of fields in a table. What I suggested in my prior post is the correct way to handle this. What is your skill level as an Access Developer? > This isn't really working for me, I guess I need step by step instructions. > Is there a way I can use a command button to add this? [quoted text clipped - 14 lines] > > > the side of my form and then have another field of "notes" come up and be > > > able to do that any number of times. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.