Recent content by Pastor Del

  1. P

    Change graph title with code

    I figured out the answer to my original question in this thread. JHB gave me good code in this thread but probably assumed I know which event to put it in. Unfortunately I didn't know. I'm posting the following on several forums because I've seen this question asked many times out there and...
  2. P

    Change graph title with code

    You are confusing different questions I'm asking. One question is how to change the title of a graph with code. The other one boils down to making a graph that will do something close to what I did with the graphs I got help with late last year. Question 1: The code suggested above gives an...
  3. P

    Change graph title with code

    I used the name of my graph (Graph13) when I tried it. As I said, it didn't work. I saw something online last night about different libraries. I'm going to look into that. How can I know what libraries to use? I'm on one or more of the following forums seeking answers to this graph issue...
  4. P

    Change graph title with code

    Sorry to cause such a stir. Next time I'll make note that I'm cross posting. The reason I cross posted was that I'm not getting a reply that works. Don't remember the exact error message I got with the code above (I'm away from my computer) but I do remember that nothing beyond...
  5. P

    Change graph title with code

    Can anyone tell me how to change the Title of a graph with code. By title I mean the box on the graph that automatically displays the name of the table used to create the graph in the chart wizard. I've tried numerous bits of code found in different forums but they all failed. Access 2010 OLE...
  6. P

    Count unique dates

    Thanks for the code JHB. It was just what I asked for. But now I'm wondering if there is a way to get the count using DCount.
  7. P

    Count unique dates

    I have 2 linked tables, tblPN & tblReceivedDate. tblPN has field PN and tblReceivedDate has field [Received Date]. The tables are used to record the receipt of different part numbers and the date they received. I want to use a query to count how many times a part number is received. The catch is...
  8. P

    Charts on reports

    This is great. The way I managed to do it required 10 charts because there are 10 teams that will be charted. One down side to my way is that I need to modify the report design if another team is added to the list. Yours is much better. Can you provide me with a step by step instruction of how...
  9. P

    Charts on reports

    Can someone show me what I'm doing wrong with the chart in the attached DB? I need just one chart for each team but I'm getting 5 times as many charts as I want. I'm using Access 2010 on Windows 7 & Vista
Top Bottom