Search results

Dear Mr arnelgp Sir.... Thanks so much.... this is what I want..... Really thankful to you for helping..... irsmalik

I am using Option Group on a Form for a series of Reports Preview…. One of the Option is a: ComboBox on Form with 3 CompanyNames (Greenlet, Suncrop, Sungro)... I want to run a Macro for Preview of Reports…. If comboBox select Greenlet Only Greenlet Report Print preview If comboBox select Suncrop...

Here is the mdb containing chart exceeding from one page... irsmalik

Dear Mr @arnelgp =DSum("TotalDealers","Query3") This is a new thing for me... Sum of Text Field .... Fortunately,,,,, I want to make my software "Perfect"..... but unfortunately..... I don't have much knowledge of Access / VBA. I always look some one who could help me..... One more thing...

Dear mR @arnelgp I made a Chart based on a query..... Chart and its data is OK..... But I want to show Total at Page Header..... Sum([TotalDealers]) is giving Error. Request to please help...... thanks irsmalik

Dear @arnelgp Thank you so much.... now its working.... many reports depends on this 3 dependent combos .... Thanks for spending your time. ... irsmalik

Sir I am using Access 2007

Dear arnelgp.... thanks for help.... When I run this form.... it is giving error message..... Please see attached picture. irsmalik

Dear arnelgp Thank you so much... I am not very good in vba...... Territory Combo vba was copied from Net.... so I could not understand where is the problem. Once again thank you so much... One more request..... you already have Chart mdb..... I will be grateful if you plz make a form 3...

Hello Friends I am facing problem with getting Correct Data in CHARG.... I am selecting Combo 1 Company Name Combo 2 Region Name listBox Territory Name when I click Preview button.... Report & its Data is OK.... But when I press CHART button... it is giving me data of...

Dear Friend Here is mdb with one form.... My requirements are very simple..... I need to Run my form Options to Run these reports. One Table and one report is available.... they can be used to filter data as per requirement. Thanks irsmalik

Hello Dear Friends.... I need to create a Filter Form for a series of Sales Reports... containing Combo Box, Option Group and Check Box all in One Form including Hide / Unhide Combo Box Or Option Group Or Check Box.... requirement of Reports are: Company Wise Division Wise Region Wise...

Hello Dear Friends I have a table with ProductSale field and its Type is Number and Format is #,###.... When I use a Query with this field along other fields, its show the values like this 123,165 But when I want to get SUM of ProductSale... it show values without COMMA... I tried this line...

Dear arnelgp Thank you so much ... yes this is I am looking for.... I never worked on Random function... but now I will work on it. I am really thankful to Arnelgp. Regards Irshad Ahmed

Dear arnelgp Thank you so much ... yes this is I am looking for.... Now Plots are 50 and applicants are 500..... I want to print preview as Report by clicking Button how can I limit to print only 50 records. thanks Irshad Ahmed

Hello friends, I need some help from seniors. I have two tables 1. PlotsDetails with 2 fields PlotID Size 2. Customers with 3 fields CustID CustName CustCellNumber I have to create a Database for Plots Balloting/Draws.... company will arrange a ceremony for Lucky Draw and computer will select...

64KB Dear sir pbaldy Sorry I could not explain.... Basically this is the balloting of housing scheme.... there are 500 plot in a residential scheme. The location is one the most attractive place of the city... so the customers are more than 4000.... now we have to make a system that computer...

64KB irsmalik Hello dear friends I want an idea for How to create Balloting of a Housing Project Plots.... There are two files.... one for Plot Numbers and other for Customers details... What to do for balloting ... looking for an idea or any demo... thanks irsmalik

Dear Mr Doc_Man... thanks for your reply. Plz note that my boss will be the only user of these hyperlinks. No other people will use it. So this idea is not workable. Regards irsmalik

First, I don't know how to start new thread. So I just kept my question here. Second, my boss use laptop and he want to keep a copy of all the record in his own custody. We don't use server for this kind of data. Hope any solution will be found. thanks irsmalik