Meeting notes database

[koopmensjuh]

Hello Everyone,,

Im trying to set up a database for all of my meetingnotes,
but I cant figure out a few things that would be possible in access (or so I think)

The first problem is that I have a subForm on my home page with a datasheet of all my meetings, and what I would want is that when I (double)click on any meeting I would like to see all the notes from this meeting in a datasheet or something.

The second problem is that I have a form in which I begin a meeting (which has all the title information like meetingdate, attendents, attachements etc.) and from here i have a button to another form in which I fill in the notes (which are linked by the meeting notes no) but how can I make the textbox in which I now have to keep typing the right meeting notes no to automaticaly fill in the highest meeting notes no (unless i fill in a different number myself?

As for the setup of my database:
I have the following tables:
MeetingNotesDB
- Meeting notes no (key)
- Meeting subject
- Specification reference
- Meeting notes by
- Meeting date
- Attachements
- Location
- Short description
- Attendance
- Apologies
- CC

Notes:
- NoteID (key)
- Subject
- Notes
- Action By

Furthermore do I have the next Forms:

HomeForm:
which has a button to go to the MeetingNotesF and a button to go to notes in NotesF

MeetingNotesF:
Which has a print button to go to the report,
a next and previous button a search button and a go to new note button.
And you can input the data from the MeetingNotesDB here

Then there is the NotesF
In which you can fill out the subject, action by, notes and in which you have to fill in the meeting notes no.

And the last Form is the HomesubForm in which the list of all the meetings is on which you would (double)click to go to the notes of that meeting.

If anyone has any solutions that would be GREAT!

 

[diberlee]

I'm no expert, but hopefully I can set you on the right track.

For problem 1 I would set up a query that pulls in whatever fields you want to be viewable in your notes view. You would need to set the criteria to check what has been selected on your form. For examples the notesID may have the criteria.

=[Forms]![YourFormName]![YourControlName]

Now you just need to add some code to open another datasheet when you double click an entry in your metting list. Or you could add a sub datasheet to the existing form and set the recourdsource as the query created above. You would just need to requery in the on change event so that it updates as you select different meetings in the list.

For problem 2, you can use VBA and in the OnOpen event of the form you can say

controlName = DMax("fieldName", "tableName")

DMax will select the highest value in the field/table you supply. In your case the most recent meeting, assuming that newer meetings have higher numbers of course.

Hope that helps