Search results

Hi, and thanks for reply. I know that I could do this with append query, but this wouldnt be good for employees to do. There must be some easiest way or even some programe or vba code or something that someone has. Also append query appends all data from one table to another, but I want to...

Hello everyone! As you can see in title of this post, I need to merge data from one DB into another. Let me explain a little bit more. I have a split database with front end DBcompanyFE and back end DBcompanyBE. BE is on the server so users at company (3 users) can access it with their own...

Hello friends of Access ;) Lately I've been struggling with some issue and I've come to this point that I need some help, because it is driving me a little crazy :( So, I would like to have a form, where I would chose year and month and also employee name and then I would be able to write down...

First of all thanks for all the help and replies. I've managed to handle the problem and now in the empty field there is no #type. Maybe someone else will find this helpful so here is the code: =IIf(IsNull([Opravil]);"";DateAdd("m";[SolanjeVeljavnost];[Opravil])) Thanks again and have a nice...

Hi! Thanks for the reply and yes, two fields in the function are within the subform and that the #type appears in the last (empty) record. I've tried with test (iif function), but it doesn't working properly. To explain a little bit more: Field 1 is date, that shows when user completed some...

Hello! I have a form which has subform with 5 fields. One of them is calculated like this: =DateAdd("m";[SolanjeVeljavnost];[Opravil]). Everything is working fine when you enter data and it is calculating like it should, but what bothers me is than one row below in this calculated field ther...

Hello again! First of all sorry for not replying for a week. I had so much work at job and at home that I basicly didn't have time. Everything is working now as it should and I get difference between two dates. And now, lets say I get result 2 years 3 monts 15 days and I would like to add to...

Like I said. It is working fine until I pick any other employee from the list box, than first record that is given. Then I get the update error. So something is wrong with the list box, I asume. List box has Embedded Macro: Record First Where Condition ="[MATICNA] = " &...

I know what you mean and I understand you, but like I said, it must be stored and I is doing that until I change employee, so I think something is wrong with list box. I appreciate your help!

Ok, I've was trying a little bit and figured out that with Pats code or anything with Unbound isnt wrong. So, when I open my form I have a list box of people and firts one shown is lets say Mike Mickey. If I dont do anything else but calculate date difference for Mike Mickey everything is ok...

Yes, big thanks to Pat Hartman from me also :) And yes...I need to store those differences for every employee, to see what is his employment age. If you know what I mean. Thank you all for helping :)

Hello again! So, I've used code from Pat and it is working fine but there is a littlle problem. It is working if text box where difference in years, months, days, is written is Unbound so that I dont have Control source. If I want to have control source so that difference would be recorded in...

Thanks for the replies guys. I will have a look at the codes you've pointed me at and let you know if it is working.

Hello to everyone here on forum! I have a little problem. I have a form where I can see all the employees and informations about them. There is also text box wich has information from what date worker is in our company and another text box wich has information how many years worked in any other...

Ohh..I didn't know that order by is after where...ok...good to know something new :) And yes...now it is working perfectly :) Thank you very much again and also I hope this thread will help someone else :) Have a nice day.

Ok, so I've made query, changed it to sql view and this is what I've got SELECT tblOsebje.ID, tblOsebje.SURNAME, tblOsebje.NAME FROM tblOsebje ORDER BY tblOsebje.SURNAME, tblOsebje.NAME; Now I've copied this to VBA code, so it was like: sqlQry = "SELECT tblOsebje.ID, tblOsebje.SURNAME...

Good morning :) So, I've gave it another look and found mistake (misstyping :banghead:) and now it is working great. Thank you thousand times:) Although I dont know how to sort it alphabeticly by surnames. I've tried ordering by like you can see, but when I do that it shows empty list box...

Sorry for not replying fast, but I have afternoon school. I think that my code is exactly the same as you listed in last reply. But something still not right, because whatever I select (reg,temp,student or all) it is showing me all of them. I cant tell at the moment, because I'm at school till...

Ok, I think we are close. But I also think there is a litlle misunderstanging. I have list of employees. I have 3 checkboxes: Regular, Temporar, Student. Each employee has proper tick on checkbox (is he regular,temporar or student) Now I also have combo box in wich I've typed values...

First thanks for the reply :) And yes, I have three fields with yes/no.