Recent content by ijaz1976

hello to all i do not know much about vb can someone guide me how to create a front end for ms access database mdb with visual basic or any other good suggessions will be highly appriciated. thanks in advance

thanks to all i have got a workaround instead of calculation on form now i am calculating sums in report directly. anyway thank you all very much.

thanks for your reply but how it can be done. :confused:

hello john thanks for your help now form is working fine but query is not working correctly. the query takes field from current record on form and then display all values of that field for example if i check check-box c1 on current record in query it shows all values based on that check and do...

Re: updating unbound text-box value for each record i have solved this problem before submitting this post and changed the title of my post but i dont know why it was no updated in posts. real problem is this: any help will be highly appriciated.

updating unbound text-box value for each record hello ! in my database on fee-voucher i have two fee text-boxes according to dates for every student which are "fee" "late fee" and an unbound control. each text-box have a check-box in front of it and only one check-box can be selected for one...

thanks to you all. what i understand is usage of code is same in vba in any app just objects are changed in each application (access or excel). in other words logic remains same in any app. is this true ?

i m new to access and do not know much about vba. my question is does vba used in Ms Excel is same as the vba in Ms Access or these two differ from each other. in other words if someone knows usage of vba in Ms excel can he use same knowledge of vba in Ms access or he has to learn vba for ms...

this code was working well but when i changed the db folder it do not works saying error in code line: fs.CopyFile source & "*.mdb", str what is the problem

thanks john i figured out :D

thanks for your reply john please define what would be the expression to accomplish this task. in other words where should i place true or false, 0 or -1 value in this expression.

hello everyone! i am new to acces in my database on a form in have a Yes/No field i need to find all records having No when a date range is enterd by user using between parameter like this: between [Enter start date] and [Enter end date] but where i put "No" to query only no fields. thanks in...

thank you very very much Mr vbainet now its working fine. :D what do you meant by that i think this part of formula is enough for my needs do you suggest something else. :confused:

you can see it yourself when it do not match criteria then it shows "Rs 0.00" but when it meets the criteria it only shows "100.00" or "200.00" without "Rs" sign.

thanks for your response i already stated above that it is working without "Rs" sign but i want to include "Rs" sign because of currency field.