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 strongm 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. billlagr

    Store OLE object in a table using VBA

    Thatnks guys, I'll give it a go today and let you know what happens!
  2. billlagr

    Store OLE object in a table using VBA

    I'm still not having much luck.. What I'm trying to accomplish is - each month I run a number of reports, approx. 100 or so, divided into 5 areas - EAST,WEST,NORTH,SOUTH,CENTRAL. Each of the managers for those areas provides me with a short (<1 page) letter in Word, that goes on the first page...
  3. billlagr

    Store OLE object in a table using VBA

    I will give it a try, Thanks! I was aware that it may bloat, but there will be no more than 5 1-page Word docs at any time in the DB, I figured I could live with that
  4. billlagr

    Store OLE object in a table using VBA

    Sorry, forgot to add..with the above, MS Word is already open, and I can open/close it through VB so that isn't an issue. If I manually select, copy, paste from a Word doc into the Access table OLE Object field, the type shows up as 'Word Document' rather than 'Long Binary Data'. I'm essentially...
  5. billlagr

    Store OLE object in a table using VBA

    I've nearly got something working.. I have a simple database with one table - TestTable, 2 fields ID - Auto Increment primary key Doc - OLEObject The code sort of works, but instead of inserting as a Word doc, the doc is inserted as 'Long binary Data' which of course won't display in a bound...
  6. billlagr

    Store OLE object in a table using VBA

    Oh, sorry, forgot to mention that. 2003.
  7. billlagr

    Store OLE object in a table using VBA

    Hi All I need to store an OLE object (short MS-Word doc.) in a table. The table is fairly simple - Table name - AreaLetters ID_Number - primary key, auto increment Area - Character, 40 characters - contains an area name, eg East, West Letter - OLE Object I need to open a dialog box to allow...
  8. billlagr

    Inserting MS Word document into a report at runtime

    I have changed things a bit, and now open the report in design view, add an unbound object frame, set the .Sourcedoc as appropriate..but it still fails at the .Action part. How can I force the frame to update and display the contents of the word doc? This is what I have so far -...
  9. billlagr

    Inserting MS Word document into a report at runtime

    Hi All I have a report that is run monthly, however I would like a short Word doc inserted into the report. The doc changes from month to month, so my original plan was to place an unbound object frame in the report, then at run time open a file chooser dialog so the user could select the doc...

Part and Inventory Search

Back
Top