Access Database help

[chasdrury]

One of my friends has asked for my help with an access Database - I have done a few simple ones in 2003, but really struggling with this in Access 2007

It should be realy simple. Basically it's for client management at a hair salon. So it stores client details - name, address, telephone number and date of birth.

When a client comes in, they need to able select the client and see the history of appointments they have had and add details of todays appointment - these details are Date, Colour(s) Used, Price charges, Stylist (dropdown) and Other Notes

I have been fiddling for ages and any (a little) knowledge I had about 3 years ago has vanished. I have looked for a template to no avail for anything suitable!

Where do I start!

Thanks

Chas

[Mook]

If your friend has already bought Access, then this is probably not an option, but I would start with FileMaker - dead easy to use and you don't need to be a programmer to set up databases in it.

[chasdrury]

If your friend has already bought Access, then this is probably not an option, but I would start with FileMaker - dead easy to use and you don't need to be a programmer to set up databases in it.

Thanks for that, Mook... Will look into it but Money is tight (new business) and like you say, they already got access with office when they bought the machine!

Chas

[Mook]

It's only about £300 IIRC - they'd save at least that much in having an Access database programmed by someone

[Irnbrukid]

What about going to local college to see if one of the IT students would do it, they may do it for free (throw in some beer money) as a little project for a class.

[chasdrury]

That's a good idea!! I will suggest that!

[Hopsta]

Just have to wait a month as they're on 'olidays

[chasdrury]

OK, I've nearly, very nealy done it!

I have got part I can't solve though. I have a form that you enter the persons name, address etc etc or you can search for an existing contact. There is a button on that form called Appointments which opens a linked form, that displays the history of the appointments for that person, and has a blank entry at the bottom for a new appointment. But, it required that you fill in a drop down of the persons name, I want that to be filled in automatically with the correct person (ie the person in specified by the first forms filter when they press appointments.) Not sure if that makes any sense whatsoever.

If there are any Access gurus that could help I will try and explain better!

Cheers

Chas

[Teacake]

I presume that the contact details are in one table and the appointments table in another? Have you linked these two tables?

If you have, the appointments can be very easily achieved by a subform on the contacts form. You may just be able to drag and drop your Appointments form onto the design view of the contacts form and Access may well be able to work out the parent and child fields to link on. Job done.

Alternatively, you can have the button that opens the Appointments form run a macro or code that auto fills various fields in the Appointments form based on values on the Contacts form. I can help you with a macro, but I'm not really much good with code if you want to go that way.

I'd stick with the form-subform myself.