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 Chris Miller 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. redjoy

    Read an OLE field from MS Access (mdb)

    When stepping through and after executing the following line. @rowSTD=$sthAppendixEPicture->fetchrow_array; I get the following error message: This object is either a Visio file or a Powerpoint file. What I want to do is extract it and put it in a PDF file.
  2. redjoy

    MS Access and DBI

    [code] #open connection to Access database $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver (*.mdb);dbq=C:\Windows\Desktop\AuditTrail.mdb'); [\code] Try changeing this line to [code] #open connection to Access database $dbh = DBI->connect('dbi:ODBC:driver=microsoft access driver...
  3. redjoy

    Read an OLE field from MS Access (mdb)

    I have a very large MS Access database and I am trying to extract an OLE field as part of my report (currently txt file but will eventually RTF or PDF format) use DBI; use User; use PDF::Create; use Win32::OLE; #Open output txt file open ( FILE_NAME_STD, ">C:\\database\\out.txt") ||...
  4. redjoy

    Split multiple line cell into seperate cells

    Skip, Again Thanks for the advice. Here is the code that I am currently running: Sub ParseOnCRLF() Dim wrksht As Worksheet Dim rng As Range Set wrksht = ActiveSheet Set rng = ActiveCell For ct = Selection.Count To 1 Step -1 Set rng = Selection.Item(ct) With...
  5. redjoy

    Split multiple line cell into seperate cells

    Skip Thank you for your solution. I made some minor changes to achieve my desired output (Insert an entire row after the current row before I paste the data). Sub ParseOnCRLF([COLOR=yellow red] [/color yellow red]) [COLOR=red]Dim wrksht As Worksheet Dim rng As Range Set wrksht...
  6. redjoy

    Split multiple line cell into seperate cells

    Problem: I would like to create separate rows for 1 B through G and 3 B through E without affecting the formula. What I currently have is under the before section. What I want to accomplish is under the after section. before after hdr1 hdr2 hdr3 hdr1 hdr2 hdr3 ----...

Part and Inventory Search

Back
Top