Search results

  1. I

    Create a Stacked Bar Chart in Code

    arnelgp: This is sick! Thank you so much! I have been studying your work for the last few days. Is it possible to do the same thing, but without the external queries? The entire SQL in VBA only. I have been trying to code it, but running into issues.
  2. I

    Create a Stacked Bar Chart in Code

    When you drop a chart in a report and select the query as a row source, it asks you to define the axis, legend, etc. That's all I did to build the current chart. Now I am trying to build it in VBA for more control and flexibility. There is very little documentation available on how to build and...
  3. I

    Create a Stacked Bar Chart in Code

    This is the database with an Orders table, upstrackingnumber table and the query.
  4. I

    Create a Stacked Bar Chart in Code

    This is the result of the query.
  5. I

    Create a Stacked Bar Chart in Code

    Hey guys, sorry for the delay the database had 1,500,000+ records, so had to strip it down.
  6. I

    Create a Stacked Bar Chart in Code

    This is the result of the query.
  7. I

    Create a Stacked Bar Chart in Code

    I would like to create the code in VBA to produce the graph attached. Row source is str = "SELECT Orders.OrderID, Orders.ShipDate, Orders.PackedBy, Orders.Cancelled, UPSTrackingNumbers.TrackingNumber, Orders.Shipped, UPSTrackingNumbers.ShippingMethod FROM Orders INNER JOIN UPSTrackingNumbers ON...
  8. I

    Create a Stacked Bar Chart in Code

    Working in latest version of Access and trying to create a stacked bar chart in VBA. Got it partially working, but having some troubles. See some code below. It is not working correctly, just my last attempt. Can't figure out how to incorporate the COUNT of a value (trackingnumber) which is...
Top Bottom