If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
A simple "notes" sub form
I have a contacts form and table which I'm pleased with. On that form I want
to place a simple subform that a user can add ad hoc notes against the contact by date. How is this done so all the notes per contact show up and that if there are many to have a scroll bar...thanks |
#2
|
|||
|
|||
A simple "notes" sub form
If you want to have multiple notes per contact, you will need a ContactNotes
table. It would need to include the Contact record's primary key, a date/time stamp, and a memo field for the note. You use the Link Master Fields and Link Child Fields properties of the subfom control to have the notes for the selected contact presented. You can turn on the Vertical Scroll Bar option in the form being used as a subform. -- Dave Hargis, Microsoft Access MVP "Simon Lang" wrote: I have a contacts form and table which I'm pleased with. On that form I want to place a simple subform that a user can add ad hoc notes against the contact by date. How is this done so all the notes per contact show up and that if there are many to have a scroll bar...thanks |
#3
|
|||
|
|||
A simple "notes" sub form
Thank you so much, works a treat, I've noticed though that now within the
main"form view" I can't scroll down the main form, i have to physically pointer over the vertical scroll bar to drag it down "Klatuu" wrote: If you want to have multiple notes per contact, you will need a ContactNotes table. It would need to include the Contact record's primary key, a date/time stamp, and a memo field for the note. You use the Link Master Fields and Link Child Fields properties of the subfom control to have the notes for the selected contact presented. You can turn on the Vertical Scroll Bar option in the form being used as a subform. -- Dave Hargis, Microsoft Access MVP "Simon Lang" wrote: I have a contacts form and table which I'm pleased with. On that form I want to place a simple subform that a user can add ad hoc notes against the contact by date. How is this done so all the notes per contact show up and that if there are many to have a scroll bar...thanks |
#4
|
|||
|
|||
A simple "notes" sub form
The scroll bar I suggested should be on the subform.
-- Dave Hargis, Microsoft Access MVP "Simon Lang" wrote: Thank you so much, works a treat, I've noticed though that now within the main"form view" I can't scroll down the main form, i have to physically pointer over the vertical scroll bar to drag it down "Klatuu" wrote: If you want to have multiple notes per contact, you will need a ContactNotes table. It would need to include the Contact record's primary key, a date/time stamp, and a memo field for the note. You use the Link Master Fields and Link Child Fields properties of the subfom control to have the notes for the selected contact presented. You can turn on the Vertical Scroll Bar option in the form being used as a subform. -- Dave Hargis, Microsoft Access MVP "Simon Lang" wrote: I have a contacts form and table which I'm pleased with. On that form I want to place a simple subform that a user can add ad hoc notes against the contact by date. How is this done so all the notes per contact show up and that if there are many to have a scroll bar...thanks |
Thread Tools | |
Display Modes | |
|
|