Search results for query: *

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...

Ken thanks - yes i did try that but it didn't work - i've had no problems with the Nz before now so it seems to be working just fine. I think i have just too much data [bugeyed] I am going to try redesigning as i think there is a way i can take some data from my query and keep it separate...

thanks guys but none of those worked :( is there a way i can sum for example , TOTAL BASE: Nz([MON BASE])+Nz([TUE BASE])+Nz([WED BASE])+Nz([THU BASE])+Nz([FRI BASE])+Nz([2]![TOTAL TRIP BASE])without writing the whole lot out? Maybe this would make the query smaller/leaner. i've tried to use...

Hi I have a form which is based on a query called Payroll Spreadsheet Query - which in turn is created from 3 other queries 1,2,3. i can run all the three queries separately but when i get to the Payroll spreadsheet query - i get it is too complex and now my Form won't work either i have...

No, the Cert 3 table contains data that has to relate to each of the employees, the primary key in the employee data is their employee number but i can't make this a primary key in the other table,because there are only 23 records in the Cert 3 table and 81 employees. I can give the Cert 3...

I have an Employee database. It contains a lot of information but I am having trouble adding a new table and I am sure there is something simple i am missing. In my Employee Data Table i have fields such as Last Name, First name, address, wage rate etc.... I have all of this set up in a form...