By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,649 Members | 2,142 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,649 IT Pros & Developers. It's quick & easy.

Problem in designing forms for database in MS Access 2007

P: 3
Hi all,
I am designing a database named grants in MS Access. It basically deals with
1) A group of people write a proposal for projects that they want to do.
2) The proposal is submitted to a funding agency for consideration.
3) At some time in the future, the funding agency may or may not accept the proposal and make an award to fund the project.
For this I have created 5 tables
1) Proposals: ProposalID(Primary Key), ProfessorID, Project Number, Title, ProposalBeginDate, ProposalEndDate, ProposalAmount, SubmitDate, Notes.
2) Professors: ProfessorID(PrimaryKey), Role, FirstName, Lastname, College.
3) Agencies: AgencyID(Primarykey), Agency, Program, Agencyfundingtype.
4) Awards: AwardID(Primarykey), ProposalID, Increment, BeginDate, EndDate, Amount, AwardDate, AccountNumber.
5) Departments: DepartmentID(Primarykey), Departmentcode, Department.

--Proposals and agencies have many to many relationship so I created a temp table Proposals_Agencies with fields- ProposalID, AgencyID.
--Professors and Departments also have many to many relationship, so I created temp table Professors_Departments with fields- ProfessorID, DepartmentID.

Professors and Proposals have one to many relationship.
Proposals and Awards have one to many relationship.

Now the problem im not able to figure out how to create the forms and corresponding subforms to the above database so that data is correctly entered into the tables. I need your help in this regard. I have tried so many examples but im getting errors in entering the data. If you have any template similar to this one it will be really useful to me.

I would be grateful for any assistance with this database.

Apr 5 '08 #1
Share this Question
Share on Google+
4 Replies

P: 16
What are the errors you get when you enter data in the tables?
Apr 5 '08 #2

Expert 2.5K+
P: 3,072
My general approach is to use a datasheet subform with buttons to [Add], [Update], [Delete], [Print], etc. to manipulate the table occurrences. (It's called the Object/Action principle, just check my sample:

When there is a relation between tables the "lower" table will be added as a subform on the mainform of the "master" table.
For the many to many relation table I use the same mainform/subform approach and depending on the situation I use one or when needed two forms, one for each "main" table.

Apr 6 '08 #3

P: 3
Actually I have to create a main form for professors which has subforms of proposals and departments.( departments subform should be in such a way that I can select multiple departments). Also the proposals subform should contain 2 subforms awards and agencies. (agencies subform should be in such a way that I can select multiple agencies).
I am able to create only one subform in the main form using form wizard. But I am able to understand how to put a subform in a form which is a subform for another form.

If you know have any template for this type of design it would be really helpful.

Apr 7 '08 #4

Expert 2.5K+
P: 3,072
Access supports sub, but also sub-sub forms.
Having Access 2000 and higher will allow to add a [+] relation to the table to goto the "lower" level, but in general I would split such a grandparent/parent/child combination and have a button on the first Main/Sub form to open the Sub/SubSub form for the same Professor.

Getting the idea?

Apr 7 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.