Recent content by irsmalik

  1. I

    Combine records in a query

    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
  2. I

    Combine records in a query

    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
  3. I

    Combine records in a query

    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...
  4. I

    Combine records in a query

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

    Combine records in a query

    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...
  6. I

    Combine records in a query

    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...
  7. I

    Combine records in a query

    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...
  8. I

    Combine records in a query

    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. ?
  9. I

    Combine records in a query

    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...
  10. I

    Hello Friends I have to create a Transmittal to send some drawings to our Subcontractor. Now...

    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...
  11. I

    Multi-Select Listbox as filter for Query field

    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
  12. I

    Multi-Select Listbox as filter for Query field

    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
  13. I

    Multi-Select Listbox as filter for Query field

    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...
  14. I

    Multi-Select Listbox as filter for Query field

    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...
  15. I

    Update query - calcualte a percentage input by user?

    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
Top Bottom