Search results

Hello friends In questions topics, I could not find Excel. So I am asking my question here. I know how to create Hyperlink in Excel workbook. But I want to give my data to an other person, hyperlinks will work only if the file/ path should be same. In our company we keep the data of our...

Thanks for reply. I tried... but could not understand / follow the suggestions. I want some query through which I could do my assignment. irsmalk

Hello friends .... Here is a CrossTab Query TRANSFORM Sum(DM1.BG) AS SumOfBG SELECT DM1.Company, DM1.Region, DM1.Territory, Format([TDate],"mmm") AS Period1, Sum(DM1.BG) AS Total FROM DM1 WHERE (((DM1.BG)>0)) GROUP BY DM1.Company, DM1.Region, DM1.Territory, Format([TDate],"mmm") PIVOT...

Re: Multi-Select Listbox as filter for Query field Hello Friends For me, it it a difficult question but hope there will be an easy solution. From query, I am getting details of Farmers meetings data i.e. Company Region Territory DTP TDate Periods Here is the query: SELECT DM.CName...

Re: Multi-Select Listbox as filter for Query field Sir Pbaldy... thanks for your reply... I already mentioned that Checkbox is in my Subform.... Now I pasted below line in AddNew Button. CurrentDb.Execute "UPDATE TableName SET FieldName = False", dbFailOnError it is working.... and it clear...

Re: Multi-Select Listbox as filter for Query field Sir Pbaldy... thanks for your reply... I am not using any query.... In my Subform.... I am selecting required records direct from Table. Now how to un-check it. ?

Hello Friends I have to create a Transmittal to send some drawings to our Subcontractor. Now what I do.... when I press AddNew Button, it work like this.... Main form open with fields..... User.... = by selecting from combo box Today's Date = Automatically toddays Receiving Department = By...

Hello Friends I have to create a Transmittal to send some drawings to our Subcontractor. Now what I do.... when I press AddNew Button, it work like this.... Main form open with fields..... User.... = by selecting from combo box Today's Date = Automatically toddays Receiving Department = By...

Sir Pbaldy......... Thanks a Lot. You Are Great........ You Are Really Great.... Superman.... You wouldn't believe how much tried I have made to remove this error... But always failed..... Sir once again I am thankful to you and hoping for guidance in future. irsmalik

May be I could not describe my problem.... kindly see the attached database and please run the form and select dates which will be displayed on Screen but will not print on paper and gives error.... #Names. thanks irsmalik

Month & Date is not printing on Report Hello Friends I am selecting dates from a FORM to print my required data on report. My required data is displaying on Screen.. with the selected Dates... but when I print the report Report , it gives me error.... #Name? This report has of 2 parts...

Prints Months Name in Brackets with Comma Hello Friends, One more problem to solve and I need your help. I have a crosstab query is below that runs and give me my results. TRANSFORM Sum(qBG.SumOfBG) AS SumOfSumOfBG SELECT qBG.Company, qBG.Region, qBG.Territory, Sum(qBG.SumOfBG) AS [Total Of...

Dear Mr Mark Thanks for the code... but is this complete code.... ? I think last part of the code is missing.... can you plz write the complete code... thanks irsmalik

Dear Mr Mark... I have just tried your idea... its working fine as per my requirement. thanks for your help.... but I will request again regarding your second option of Single date... Thanks irsmalik

Dear Mr Mark Thanks for your reply... yes this is a good idea and a better solution of my problem. I will appreciate if you also explain your second option of One Date.... can you plz explain it. thanks irsmalik

Yes.. Mr arnelgp.... Query Data is not problem. It is fine. Basically I want to print in Report Title / Description "16 July to 15 Aug" and it will go on for further period. At present, I do it manual... but when the user will run this report, he will not be allowed to go into Design...

Here is my query: which run behind my report. SELECT DM.Class, DM.ClassName, DM.Size, DM.SizeName, DM.TDate, Sum(DM.BG) AS SumOfBG, Sum(DM.Demo) AS SumOfDemo, Sum(DM.DTP) AS SumOfDTP, Sum(DM.FAS) AS SumOfFAS, Sum(DM.FM) AS SumOfFM, Sum(DM.HPM) AS SumOfHPM, DM.Division FROM DM GROUP BY...

Dear Minty 6 years ago I was member of this forum... so how could I know that this topic has discussed. I will as the question that I need. If this is a knowledge base forum... .then you must help me by solving my problem... your remarks are not appreciable. irsmalik

How to enter dates from vba / query Hello friends I want to make a report which display data as below Column 1 Jan to till today. Column 2 Last 30 days like 16 Jul to 15 Aug. This report is completed and all data is being displayed... see attachment But I have to mention 16 Jul to...

Hello Rural I am trying to link main form and subform for 5 fields. They are DrawingId;DrawingNo;Title;Discipiline;Type DwgID;DwgNo;Title;Discipiline;Type I am trying to put this at the time of linking Subform. But it is not accepting and message is " "this text your entering is not in the...