Recent content by kattz

Thanks guys, I actually know about normalization but i couldn't see a way to do it with this one. Anyway, have changed it and trying to do the Junction Table. It's been a long time since i have worked with Access cheers

I only have Access 97 with no wizards and no add ins and do not have access to the templates so i can't even play around with them. I am trying to create a database which will have: Client Name Contact details within that client (could be more than one) Functions that can be invited to RSVPs...

Unfortunately i can't download the 97 template, for some reason my computer won't let me, so i have to do this on my own. I can't even find anything thru Google either :( I have completed the company and the contact details tables with a head form and subform and that works beautifully even...

Hi everyone Just to let you know I only have Access 97 to play with and do not have access to the templates so i can't even play around with them. I am trying to create a database which will have: Client Name Contact details within that client (could be more than one) Functions that can be...

Thanks Skip, that worked a treat [thumbsup2] I know that was probable very simple, but we all have to start somewhere [tongue] what code do i use to close the userform once i have finished entering the data and cleared the userform? (as per the example code below) Private Sub cmdok_Click()...

Thanks Electricpete, for the OK button code, do i start it off with just the code you gave me? the example which points to rows and offsets etc, starts off with "With worksheets("sheet1").range (A1") I am lucky that i only have text boxes to deal with and no combo or list boxes. Also, I...

I don't have any idea on writing VBA so I need it to be kept really simple if possible. I like to learn and teach myself but I need a really good starting point for this one. I read a previous thread but I didn't understand it at all %-) I have a worksheet called Noticeboard. This will be...

i would just like to say a HUGE thanks to Richard (Willir) for the valuable advice he has given me - for the very first time i have a database which is totally normalised and works the way i always wanted it to. The guys at work are sick and tired of hearing me talk to the computer and now they...

thanks Richard (sorry i got your name wrong before) I was also thinking the CostDetail is really an InvoiceDetail. Just a few more questions if i make the CostDetail the InvoiceDetail - i just have to do a query between the two Invoice tables to do my form? Each purchase order has a number of...

Hey Willr Robert hope you still have this linked. your feedback has been amazing in getting me to understand normalisation. the database that is was putting the management table in wasn't normalised and now i am in the process of normalising it. i have done the tables as you have said plus...

I have an employee database already set up with their personal details, work details, training details which i am currently trying to normalise What i need is a form where i enter start time and end times for each day of the week - then it needs to calculate different things like overtime, meal...

thanks guys I have read the 'fundamentals' it has helped in that i know now what is normalisation but it hasn't 'clicked' yet on how i can make my tables normalised. I find it a little difficult to understand because whenever i read anything on normalisation it is always about customers and...

I have the following data in a spreadsheet which i need to place in an existing database. In my existing database, i already do the invoice required and have the rates for the various charges, i need to create a form that my boss can enter the data of no of working days, overtime shift hours...

Thanks Jonfer I will give it a go and let you know - i have to do some more investigating into crosstab queries. thanks again kattz

Hi Jonfer Sorry this has taken so long but i had to leave it for a while unfortunately - more important issues to deal with. One of the tables i have underlying my spreadsheet query is a 'time card table' this consists of some of these field names (obviously for every day of the week). emp id...