Any Access experts here?

[boomam]

Hi.

Can someone help me with MS Access.

 

Im trying to create a basic database that has one table/form for pupils, one for incidents, and then all the incidents that that pupil is involved in listed on that pupil form.

With the 'menu' form on the database allowing editing of pupil information and editing of incidents.

 

Its basically something to log incidents that specific pupils do, with the ability to see what incidents each pupil has done by just looking at their name.

 

Can anyone help me with this?

[rush_tech]

I'm no expert but how about looking here

maybe there is a template there that would do the job

Theres even more in the 2007 tempates

Edited April 11, 2008 by rush_tech

[powdarrmonkey]

Yes, I can. What version of Access are you writing for?

[boomam]

2003.

 

Ive checked the templates, but cant find nout useful. .

[powdarrmonkey]

PM me your email address and I'll knock one up for you over the weekend. Edited April 11, 2008 by powdarrmonkey
a spider on my keyboard

[boomam]

PM me your email address and knock one up for you over the weekend.

 

Thanks. Appriciate it.

[srochford]

Take a look at the sample Northwind database. You should be able to do something based on one of the example forms in there. Basically what you want is a form with a sub-form; this allows you to have (eg) customer details at the top and order details (more than 1 per customer!) at the bottom

[boomam]

Already looked at that.

 

Gonna wait to see what powdarrmonkey can conjure up for me. .

[boomam]

Im having a few problems with the database that powdermonkey has made me.

I can add incidents, and it does save them, but it wont let me add new pupils for some reason?

 

Can anyone fix it for me? And possibly fix/remove/add the menu buttons ive made, like the save ones?

 

Thanks in advance all. .

incidents.zip