+ Post New Thread
Results 1 to 9 of 9
Office Software Thread, Any Access experts here? in Technical; Hi. Can someone help me with MS Access. Im trying to create a basic database that has one table/form for ...
  1. #1

    Join Date
    Nov 2007
    Posts
    554
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Any Access experts here?

    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?

  2. #2

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,414
    Thank Post
    111
    Thanked 265 Times in 201 Posts
    Rep Power
    194
    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
    Last edited by rush_tech; 11th April 2008 at 02:53 PM.

  3. Thanks to rush_tech from:

    tech_guy (11th April 2008)

  4. #3

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,866
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    Yes, I can. What version of Access are you writing for?

  5. #4

    Join Date
    Nov 2007
    Posts
    554
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    16
    2003.

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

  6. #5

    powdarrmonkey's Avatar
    Join Date
    Feb 2008
    Location
    Alcester, Warwickshire
    Posts
    4,866
    Thank Post
    412
    Thanked 777 Times in 650 Posts
    Rep Power
    182
    PM me your email address and I'll knock one up for you over the weekend.
    Last edited by powdarrmonkey; 11th April 2008 at 03:05 PM. Reason: a spider on my keyboard

  7. #6

    Join Date
    Nov 2007
    Posts
    554
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    16
    Quote Originally Posted by powdarrmonkey View Post
    PM me your email address and knock one up for you over the weekend.
    Thanks. Appriciate it.

  8. #7

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,157
    Thank Post
    116
    Thanked 529 Times in 452 Posts
    Blog Entries
    2
    Rep Power
    124
    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

  9. #8

    Join Date
    Nov 2007
    Posts
    554
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    16
    Already looked at that.

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

  10. #9

    Join Date
    Nov 2007
    Posts
    554
    Thank Post
    3
    Thanked 3 Times in 3 Posts
    Rep Power
    16
    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. .
    Attached Files Attached Files

SHARE:
+ Post New Thread

Similar Threads

  1. Any Backup Exec. experts to help with this one...
    By kennysarmy in forum Windows
    Replies: 4
    Last Post: 11th February 2008, 03:24 PM
  2. Mac experts help needed
    By Rozzer in forum Mac
    Replies: 4
    Last Post: 3rd August 2007, 08:08 AM
  3. Calling All Sophos Experts
    By in forum Windows
    Replies: 5
    Last Post: 7th June 2007, 08:02 AM
  4. WIX Experts Needed
    By russdev in forum Coding
    Replies: 0
    Last Post: 25th May 2007, 08:07 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •