Search results

Hello friends At last I made my Region Wise Monthly Report. Some one advise me to combine all my activities in one column and then make Cross tab query. That really worked and my report is now final. Plz see the attached pic. One more help plz. I can't make below event in Order / Sort. Plz...

Monthly Report based on Crosstab Query Dear Sir Pbaldy I want to make one Report. Subreport is not a solution. Please look the attachment and advice. thanks irsmalik

Monthly Report based on Crosstab Query I want to make a Monthly Report from my Table. I know this will be done by Crosstab Query. I have tried to make it but could not. My table fields are given below. What I want to make, is attached as a picture. CompanyName text RegionName text...

Sir pbaldy Instead of Selecting Territories one by one, can I put * to select All. How can I do it. irsmalik

Thank you very much sir pbaldy.... it is really working...

Sir....... I changed the code as you corrected DoCmd.OpenReport "Demonst Report1New", acPreview, , "TerritoryName IN(" & strWhere & ")" but still No Report Preview. It goes to Debug Mode and this line is Yellow Highlighted. All three fields are Text. All three fields are Text Company Combo...

Dear Sir Pbaldy I follow your code and Multi Select is selecting but Report Preview is giving error. Sir Please help me and Correct this code as I am using txt of my Territory field. Private Sub Preview_Click() Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make sure a...

Hi friends….. I am making a DB and I want to select Territory from Region Table + Company Table. now I am making Mistake at some point and I need your help. Here is the structure. Table Company CompanyID Number CompanyName Text Table Region RegionID Number RegonName Text CompID Number CompName...

Hi friends….. I am making a DB and I want to select Territory from Region Table + Company Table. now I am making Mistake at some point and I need your help. Here is the structure. Table Company CompanyID Number CompanyName Text Table Region RegionID Number RegonName Text CompID...

Sir As a new programmer I do not know how to do it. That's why I tried to copy your Code. Kindly write me the Code line that I will put in my Territory List Box so it may work fine. Thanks

Dear Friends............. All senior programmers are requested to plz help. I am new in Access programming. I was stuck but your page for Multi Select Listbox gave me idea, I am unable to complete my work. I am wanting your help. If you help me I will be able to solve my problem of List box. I...

hello dear ... I am trying to open this database in Access 2007. But the message is Unrecognized format... Kindly make it easy to open in Access 2007. Thanks Irshad Ahmed