Search results

I've not consider that yet. I thought there might be a way of using the already registered personal identification number which all people have here in Norway. But solution is maybe easier the way you describe. Pser

I have a challenge with a query. I have a table person which are in a table department which is in a company table. The PK in person is a personal id, the 9. number in the key to tell if you're male or female, i.e. if the number is odd then the person is male and if it's even it's female. What...

I've solved it. Solution is like this and it's so simple. ctlSource.ItemData(ctlSource.ListIndex) Pse

Yes, maybe you misunderstod me. The two listbox works fine but i've got this extra click on the button show detail for particualr person. What i'm looking for is to get update after just click on the person listbox. The thing which doesn't work is in this code: Dim ctlSource As Control Set...

Hey, i have problem getting something to work. It's like this i have a listbox person and if i click i want to list what is register on that particular person in another listbox. I have something which work, but i have to click a button in order to update the other listbox. I want to update...

Thanks guys. So far i solved it with traverse two recordset, then so the calculation, insert it into table and then requery which will then get the correct result. This means double loop which i think will affect the speed with increased number of person register. I'll check out your suggestion...

Hi, i have a query salary which contains a this: "SID PK, autonum", "personId FK, text", "year, 4 digit, text", "General raise, number", "personal raise", "percent increase, double", and "total sum, number" Ok, here's the challenge. Let say they you start in 1999 with a salary, next year which...

Ok. I was considering this when i start looking into this database development, but i tried to see if there where other ways od solving it. But you're right, it's important to keep the database normalize. Thanks David R. Pser

If i understand you correct in the table personmoney i would get the number of employees multiplied for every year i register. So if this company have 350 employees and they want to register for let say 10 year i would get 3500 record in that table? Pser

Nice tip, i've already consider this. But the fact is that this is a system to look at development of yearly income for a manager in a company. Let say this company have 300 employees and you want to register income and general/personal raise every year for each person. Then you want to generate...

That would work, but i want this to go automatic. It's going to be used by a user which is not familiar with Access at all. Maybe you have other suggestion to solve this issue. It could be that it not should be solved with subform. But i have some column with calculation depending on what user...

Hi i have a challenge with a form included a subform. Subform is based on a query which show the column last year and current year and some other stuff from the table person. A user can click on a button which will insert a new column in the table person, the new columname would then be...