Search results

well i can not take the part out. Since that part calculates the corect wages for each project employee is engaged in. The employee gets raise and that max function finds his latest salary .IF i remove that part the wages will be not be calculated corectly!!

Thank u for your reply. Well at this moment i do not want to normalize it. I posted the query that is calculating the hours and salary for each week only . could u help me using that to calculate the cumulitve values.Thanks

Thanks for u reply. does this code over rides the access errors? i want some how over ride that error . Furtheremore, if i want to use this on form error is there a way to add if statement to this script so for each error it show diffrent massage.Thanks

Hi guys. i want to trap error number and error discription when error happens in access 2000 forms(on form error event). I want grab those values and show the user a customed message box and over ride the access error. I be happy if some one show me how to do this.Thanks

Hi guys . I saw and example in code repository Export All Database Objects Into Text Files by ghudson http://www.access-programmers.co.uk/forums/showthread.php?t=66320 and it was writing all the access object to text file. I want to do similer but instead of adding just feild parts...

Thanks again. could u tell me where to place this code ? should i add replace it with yoru first coder or add it ? Thanks

Hi everybody. I got a access 2000 query that lists : 1)weekno 2)year 3)project (project number ) 4)QweekylyReportHeader (project description ) 5)customer (customer that requested this project) 6)department (department number and name that implements this...

Thanks for u reply. When i try to run it in module windows . I get the following error : compile error sub or function not defind and it points to the following window ' Print report. FieldOutput "TableDef", fldTableDef further more if i want run it for my current db what should i...

THank u guys for u reply. I want to use vba to identify and print the pk and fk of tables in my db . I be happy if some one show me how.Thanks

Hi guys. could any one help refrence primary key and forgine key in access db using vba code and show it in message box.thanks

Hi guys. i got couple triggers in my sql server 2000. I connect my access 2000 forms to tables inside sql sever. I want to know how i can trapp error caused when triggers are fired and make customed error massage to user. I be happy if some expert show me how i can trap those errors on my form...

Hi every body. I want create a query that has the following fields on it: Project : project number Year: year that project is carried out Weekno: week no that project is carried out Task: Task number that is done for this project Employee: employee number that did this task Amount: amount of...

Hi every body. I am new to creating query and report. I got database and sample report document that i want to generate the report in access each week. My big diffuclty is how to design and create the query for this complex report so any help would be appreciated.I posted picture of my database...