Recent content by shahshah

okay, thank you

If you take out Const and =5 you will have a global variable sorry, maybe i don't get what you mean by this..

so like this: Public price As Integer ?? i did that, and then i typed the value under the declaration : price = 5 i tried to change the value fom a textbox, then i get an error "outside procedure" .. i don't understand this really..why we can declare a Const Global so easy, but the variable not...

okay but how to declare a variable as Global or public?i know how to make the constant public, but not a variable

thanks for your replay, well, making it as a variable needs a lot of job because i used it for many calculations in my forms....

Hello, i have a constant defined as public like this: Public Const price As Integer = 5 is there a away to build a textbox in such Form and change this value, without going inside the module? thx

WOW it's working wonderful , thank you so much my Friend!:)

any idea plog..thx

every person has 900 training minutes when he work 300 minutes in AA1 then remains 600 the next Date he worked 400 minutes , now he has 200 minutes remains then he worked 200 minutes, now he has 0 minutes remains this is what i want the query to do

this is the supposed Query PersonalID, Workplace, worktime, Training 10, AA1, 300, 600 10, AA1, 400, 200 10, AA1, 200, 0 i hope you got it now..thanks really

sorry i didn't mentioned that i use the (date) order..so fields are ordered using dates

thanks for your replay, i have a table personalID,workplace,worktime(minutes) 10 , AA1 , 300 30 , AB12 , 400 10 , AA1 , 200 Query PersonalID, Workplace, worktime, Training 10 , AA1 , 300 , (900 - 300)----> (900 Minus...

Hi , i have a table contains the following fields personalID,Workplace,worktime(minutes) every person could work in multi Workplaces. i want to make a Query of this table, and to add a new field (Training) in minutes which hold an Expression, (Training = 900 - worktime) then the next...