Search results for query: *

Thx all for your help I solved it The reason is that the dutch system use the comma"," for decimal number, not dot "." So if i have a number 2 and a haft(2.5) it will be (2,5) that why i got the error. thx all for help

Hello, i have built an access database and form, stuffs... everything done and run fine , absolutely without any error on my laptop. But when i copy it to a network. And run the file from a computer belong to that network. I got error on sql execute. The problem is that that pc has microsoft...

thx u , i will give it a try

Hi, i have a difficult problem I have to check in a list of excel file, that if the excel file has a namerange, then i will import data from that excel's namerange to access data by vba code..... Quite hard for me. For ex, I have a list of excel file name FILE 1 ... to FILE 10. and in each...

Thanks YOu PHV, u save my life with that magic query And also thank fneily for your comment, I knew about normalization, but sometime things not so easy....

Hello guys, I need your help with this kind of query I have 3 table HOURS1, HOURS2, HOURS3, and they have the same colume for every table. they have column Week,CustomerNr,EmployeeNr,Time. So what i want is a query that calculate the Total of Time by every EmployeeNr group by Week And CustomerNr...

Thank you, I will try and see how it work

OK, I will make it more clear for you First off, here is the example file describe my case http://www.mediafire.com/?6wvbecijqyk well, in the pictures below, 1st pictures is the original form which show all hours by worker picture 1 ...

SOrry, I'm not so good with access I'm not understand your meaning can you tell me more about your idea?

Hello, Can anyone help me with this case? I have to display the working hours of workers in a form ,so I use continuous form to display those values. the worker have 2 types of working hours, first is 100% hours, 2nd is 150% hours. If that guy work only 100%hours, then only show that hours. if...