Qazi (1 Viewer)

[Qazi]

i am new in ms office and want to work in access

 

[Qazi]

i m new here and you all are my teacher and i wana be your student please

 

[Qazi]

will you help me

 

[pr2-eugin]

Hello Qazi, Welcome to AWF.. People here are always willing to help.. So if you have any questions post them in an appropriate thread and we will try to help you out..

 

[Qazi]

i want report with combobox i dont now about the vb please tell me how can i creat a combobox in or at report. so that i want to get report of my selected head or item.

 

[pr2-eugin]

There will not be much vb coding involved here.. What you need is a form that will have a combo box and a button.. the combo box will hold the list of all the selection items and the button will be used to run the appropriate query.. you need to run your query based on the forms data.. Something like..

SELECT * FROM someTable WHERE criteriaField = Forms!formName!comboVoxName

I am using my phone to reply.. Sorry I could not be of much assistance at this moment.. Please also accept any typo's as well.. If no one has answered your query I will when I get home..

 

[Qazi]

Thanks eugin u r great.
now i am facing a problem I made a software from daily book all the heads are maintain by entry of daily book but if i enter a bill that calculation is not shown in head detail how can i manage the two calculation in one head. please i want to thank you again.
regards

 

[Qazi]

hello dear,
i have two queries named dailybook query and bill query how can i get result in one query of the both queries by head name for report

 

[pr2-eugin]

Hi Qazi, I do not understand what you are trying to say here.. "Two calculation in one head"?? I am not really great with reports.. but I could try to help.. could you give another shot in explaining it?

 

[Qazi]

ok dear,
1st table clintename, childtable dailybook,
and
1st table clintename, childtable bill
now i want to gather the amounts of dailybook and bill how can i do this
please help me
thanks

 

[Qazi]

ok dear,
1st table Clintename, childtable Dailybook,
and
1st table Clintename, Childtable bill
now i want to see joint data in one query, the amounts of Dailybook and Bill how can i do this
please help me
thanks