Recent content by Muaz

  1. M

    vlookup with sum

    That's great. Thank you very much. Resolved. Regards Muaz
  2. M

    vlookup with sum

    hi trying to get vlookup and sum but unsucessful yet. help will be appreciated. Example attached Thank you in advance. Regards Muaz :banghead:
  3. M

    vlookup with sum

    hi trying to get vlookup and sum but unsucessful yet. help will be appreciated. for example id text vlookupresult id2 value 1 aa 15 1 3 2 bb 7...
  4. M

    how to open another database using VBA

    You are right, Pbaldy. I changed the path on their system as per their logon user. Every code that I tried on other system, I used path as per their system logon.
  5. M

    how to open another database using VBA

    Yes, Pbaldy.. It is link of the db.
  6. M

    how to open another database using VBA

    Thanks for your prompt reply. Yes, I use this but not working. The reason to run link is because the database is secured with .mdw If I run the mdb then the system give message "you don't have necessary permission to use ........." because the database is secured. Also used below mention code...
  7. M

    how to open another database using VBA

    Hi; I have tried all the above mentioned solution to open another secured data base through VBA. The one that is working in my Laptop only is Application.FollowHyperlink "C:\Users\Qazi\Desktop\hrmst.lnk" After processing this code the system ask for logon screen of the secured database which...
  8. M

    How to get Null and IS NULL combine (Third Condition/All Data)

    Hi All; I am using a frame on form to get report. Below is the code used to filter report. Select Case Me.fraReportType.Value Case 1 strReportType = "Like '*'" Case 2 strReportType = " Is Null" Case 3 strReportType = " Is Not Null" End Select The second...
  9. M

    Third party reporting tool for access

    Row labels repeat on every page with next employee numbers as shown in attachment. The way you suggest to email a spreadsheet, I have did the same thing last time with employee numbers as a row, and then it is transposed using excel. But Business need the way that the employee must be in column...
  10. M

    Third party reporting tool for access

    Minty : I keep the employee as a column because the rows are around 45 and that can not be fixed in A4 or A3 size. Spikepl : Because I am unable to call/run crystal report .rpt report through VBA after plenty googling. This is the only reason that I am looking for other tool.
  11. M

    Third party reporting tool for access

    To make a cross tab report. First I try to create a cross tab query (report will be based on this query) that display me the message that "Too many crosstab column headers" The report that I have designed (attached previously) in Crystal Reports is based on the same data and I create a...
  12. M

    Third party reporting tool for access

    Hi; I was preparing a crosstab report (sample attached), there is a limitation of 255 columns. The columns that I used here is employee number that can be exceeds. Here is sample (attached) I prepared the desired report in Crystal Reports but now I do not know how to call/run it from MS Access...
  13. M

    Third party reporting tool for access

    Hi; Which third party reporting tool is good to work best with Microsoft Access ? Regards Muaz
  14. M

    Enter parameter after using .FilterOn

    Thank you very much for your time.... It works perfectly now.
  15. M

    Enter parameter after using .FilterOn

    I am using Access 2007
Top Bottom