Search results

  1. irsmalik

    Hello dear Report smtazulislam... I am from Pakistan.... can you please share your database...

    Hello dear Report smtazulislam... I am from Pakistan.... can you please share your database without Data to me .... I am working as Document Controller and I want to implement its Main Menu & other features... Thanks.. irsmalik@gmail.com
  2. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Sir... Arnelgp I Retrieve a group of fields by using DLookup.... It is ProductName, PackSize, UnitPrice, StockInHand..... etc =DLookUp("[UnitPrice]","Products","[ProductID] =" & NZ([Forms]![DataEntryForm]![cboProduct],0)) How can I Edit UnitPirce....? in some case, plz guide. irsmalik
  3. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Sir... please check above Code, where to Put DoCmd.SetWarnings as this code is not working and both messages are appearing. irsmalik
  4. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Yes... now I checked.... working with Macro ....it is working good... Thank You Sir.... I am trying to use Event Procedure ..... please check below line.... where I am making Mistake. *** Private Sub Report_Open(Cancel As Integer) Cancel = (DCount("1", "Sales by CategoryGLTa") = 0)...
  5. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Sir... Arnelgp this Message is OK Can we prevent from this Message.... how to Switch Off this Message.... Plz guide thanks irsmalik
  6. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    OK Sir... Thanks I got it..... But each time we have to modify the Query Name.... Can we make a Standard for all Reports ? irsmalik
  7. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Here is the message when try to run the database... I am using Access 2007
  8. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    sir @arnelgp If Report has No Data, there is a NoData Message.... If Chart Report has No Data..... this NoData Message Does Not Work.... Is there any way to Display NoData Message in Chart Report..... Thanks irsmalik
  9. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    sir @arnelgp If Report has No Data, there is a NoData Message.... If Chart Report has No Data..... this NoData Message Does Not Work.... Is there any way to Display NoData Message in Chart Report..... Thanks irsmalik
  10. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    sir arnelgp Please accept my thanks..... apparently these small tricks but I am un-aware of it.... Thank so much sir.... irsmalik
  11. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Sir arnelgp Mostly I have complete as per your instruction.... But this portion is not clear to me I select Company Name and then Select its Region Name..... Chart and its Data is correct and OK... Even its Grand Total at Report Footer is OK.... In Report Header I want to Show the Region...
  12. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Dear Sir @arnelgp Sir... please your attention require for above mentioned problem. irsmalik
  13. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Further, there is SubReport containing Grand Total of That Company, or Region, or Territory, or Dealers Total Business. This is Master Link and Child Link with RecordSource.... If we Delete RecordSource, there is No Link and SubReport does not work. irsmalik
  14. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Dear Sir arnelgp There is some problem in Chart view.... When select Company Combo from Dealers Report.. & run Chart Button.. A Dialog box appear for " Enter Parameter Value", "Company Name" if I cancel it.... then Chart shows its Data.... Only One Page.... Any Solution Plz. Thanks...
  15. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Sir... Arnelgp... Do we need to change in Report properties.... ? to get only one print ...? irsmalik
  16. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Sir.... Thank So Much.......... You Are Great........& very kind to me.... irsmalik
  17. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Dear Sir arnelgp Sorry to disturb again. My Chart's data consist on Only One Page but is is printing more than One page.... On all the pages, Data / Bars and their figures are Same... How can I restrict printing Only One Page... ? Thanks in advance Sir.... I hope you won't mind... I am a...
  18. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Wahooo.... Problem Solved Extremely Thanks Sir @arnelgp.............. irsmalik
  19. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    This Last Date will be printed on various Reports in Header ....
  20. irsmalik

    Print Report from Form's ComboBox with Macro Where Condition

    Dear arnelgp I want to print Latest OrderDate on Report. I made a query qLastDate.... and got 23-May-22... was last date of entry. Now I made a Text Field and use =[qLastDate]![LastDate] at ControlSource of Report. but it is giving Error..... Plz guide how to print this Last Date on my...
Top Bottom