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!

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

Search results for query: *

  1. Lamprey79

    powerpoint automation - copy slide from 1 pres to another

    Hello all, I'm writing an application that creates powerpoint presentations using slides from various other presentations. I have the necessary presentations open, however I've run into a wall as far as copying them. I know the slide# I want to copy, but how do I copy it from one presentation...
  2. Lamprey79

    API data link Bloomberg->Excel - please help

    Thanks Mike, however I don't think it's about pulling content from a web page. It's a matter of downloading portfolio characteristics/performance data for customized accounts, something that would be pulled through a Bloomberg box rather than from their website I think.
  3. Lamprey79

    API data link Bloomberg->Excel - please help

    Hey folks, I've been asked to create a link that would pull data from Bloomberg and dump it into Excel. I assume this is done via a web spider of some sort? My question is, are there any easy ways to do this, say via a free downloadable application? I'm new to this and not really sure where to...
  4. Lamprey79

    DAO vs. ADO?

    I always use DAO (3.5 or 3.6) when manipulating data in VBA in my projects. I was wondering, is ADO that much better? Anyone got a quick rundown of advantages/disadvantages of each off the top of their head?
  5. Lamprey79

    Problem Declaring Recordset - "Variable Not Defined" message

    Personally, I like declaring my recordsets as Object. For some reason I get fewer headaches that way (I habitually use ADO, is DAO that much better?)
  6. Lamprey79

    Global Variables get deleted after Execution error - remedy?

    Have you tried setting a breakpoint at the beginning of the subroutine in question? That way you cvan run the sub, and when execution stops on the breakpoint (soon as you enter the sub) you can use F8 to execute the code line by line. This'll let you get to the line causing problems while...
  7. Lamprey79

    Access Report Print to File

    I believe the command you're looking for is DoCmd.OutputTo; you can specify a rich text file, for example, with the acFormatRtf flag.
  8. Lamprey79

    Inserting a .jpg picture into a .rft file using vba?

    I'm outputting an access report to .rtf (for attachment to an automatic email), but the problem is that an .jpg embedded in the report doesn't make it into the word file. Is there a way to modify my code to make it export with the rest of the report? Perhaps it's possible to insert the .jpg...
  9. Lamprey79

    combo 1 selects records for combo2

    If I understand you correctly, you've got your combo2 populated correctly, except that clicking it doesn't find the record it's linked to on a form? If that's the case, try this in AfterUpdate of combo2: ======================================= Dim rs As Object Dim dbs As Database Set dbs =...

Part and Inventory Search

Back
Top