Recent content by BrOkEn_iCe

thx man i done it with vba cod that i make if comman if it 0 will do nothing and if it any thing else will run where function

hi all i want to know how to turning column in table to row as example i need to turn this date f1 f2 jan 100 200 feb 300 400 to name jan feb f1 100 300 f2 200 400 is there any easy way to do that the only thing i know that i creat new table and...

first thank u very much for reply when i use 0 it work good but i want that select all the city but when i chose all the report show error so what i need to do

i need some help here plz i make combo box that show all the government and make other combo box relate to that one that show city i want to add all to the combo box i use union but it didn't work i don't know, why could u see the db and tell me why, the form is rp01

hi all i want to know other way to linked sql server to access than use odbc connection and plz if it's the only way how i can improve it's performance caz it's too slow i here i can use oledb but i don't know how i can do that so plz help me i need it

thx i know what i am doing wrong i writ a (,) and it must be (;) have a good day have a good luck and thx one more time

i am trying this code many times and it keep tilling me " invalid syntex you enter in vailed character or comma why that i don't know"

is there any one can help i need this so much

u can see the attach and know what i need

i will attach the simple database and can u make it :(

i try it several tim and it keep tilling me invalid syntex you enter in vailed character or comma why that i don't know

in query it return this error invalid syntex i use this code exp2:DateDiff ("yyyy", #15/10/1998#, #22/11/2003#)

but datediff work only with me in vba not in query

Can any one help me , plz

subtract 2 date coulmn into query ,how? hi all i try many wayes to subtract a 2 dates coulmn in a query and i failed i want to subtract start_dates coulmn and end_dates coulmn to get the number of dayes between them how i can do this