Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RobinHood786

  1. RobinHood786

    Export Graph Data to Excel

    I'm re-posting this from the form Forum as mistakenly posted it there I’d like to export data from a graph to excel where the query is built in the ‘Row Source’ of the graph rather then being defined as a named query (hope this makes sense) Ordinarily I have been using something like...
  2. RobinHood786

    Exporting graph data to excel

    Sorry, Point taken. I'll re-post Apologies to all
  3. RobinHood786

    Exporting graph data to excel

    Thanks Skip, That's what I was hoping to avoid as I have some many graphs built this way and want to give the user an option to export data for every one. I think I was hoping to be able name the query in vba and refer to it that way,Something like myData = Me.Graph5.Rowsource but I failed...
  4. RobinHood786

    Exporting graph data to excel

    Hi Skip, Many thanks for the quick response. Certainly the row source is a query that was built using the three ... rather then being built in the query section of access and and pointing to it from row source drop-down. It therefore doesn't have a name. That's what I'm having trouble with...
  5. RobinHood786

    Exporting graph data to excel

    I’d like to export data from a graph to excel where the query is built in the ‘Row Source’ of the graph rather then being defined as a named query (hope this makes sense) Ordinarily I have been using something like DoCmd.OutputTo acQuery, "QueryName", "MicrosoftExcel(*.xls)", "", True, ""...
  6. RobinHood786

    Need help with Workings Days Count

    Thanks PHV I went back and at looked at MichealRed's module, and your spot-on about changing the format to yyyy,mm,dd An even better call then I first thought. Many thanks
  7. RobinHood786

    Need help with Workings Days Count

    Thanks PHV I gave your idea a run but but got the same results, nice call though, and I take your point about the formats.
  8. RobinHood786

    Need help with Workings Days Count

    Hi Michael Red, Thanks for your reply. Nice to speak to very man who wrote the whole sherbang in first place. According to the dates in my holiday table 07/06/2007 20/06/2007 21/06/2007 10/07/2007 11/07/2007 are all holidays So 7 June 2007 shouldn’t be counted as a...
  9. RobinHood786

    Need help with Workings Days Count

    Hi all, I’ve been using Michael Red's faq181-261 'Calculate working days between two dates working days' function for a while and it’s proved to be a very useful tool, so can I firstly say thank you to Michael Red for posting his solution. Using this model I’ve created a sort of makeshift...
  10. RobinHood786

    Need ideas on best way to distribute demo app

    Hi all, I’m going to be distributing a demo version of an app, which I want to allow users to run unrestricted for 6 months, after which time I want to either allow usage with restricted functionality or simply display a messagebox then exit. (Not quite decided on which way to go) I was...
  11. RobinHood786

    How to incorporate SQL in OutputToQuery

    Thanks for the pointer PHV. Having looked through the help files and doing a ggogle search I'm still a little lost. Well quite a bit lost to be honest. Could you possibly elaborate for me.
  12. RobinHood786

    How to incorporate SQL in OutputToQuery

    Hi, I want to reduce the number of queries I have in my database as the whole thing is looking a little bloated. (In excess of 70 queries.) Previously I’ve been using queries to as the source for exporting data to excel which works well e.g. DoCmd.OutputTo acQuery, "Qry_CaseloadCount"...
See more

Part and Inventory Search

Back
Top