Results 1 to 7 of 7

Thread: How to create report in WORD with VB6.0

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2008
    Posts
    3

    How to create report in WORD with VB6.0

    Hello Brainyz,
    Im using vb6.0 and oracle 9i as backend. I want to create some reports in WORD(doc format). for ex,

    In word the report should be like this,

    Patient Name:<<nameofpatient>>(this should come from textbox from VB)
    Patient age <<age>> (age of the patient from VB textbox)

    <<then reporting section>> text typed in VB


    end of the report

    The text editor should contain all the basic word options to edit.

    This report should be saved in DATABASE.


    How to do this?
    any ideas, pls help me to solve this. Thank u.

    Balamurugan.M

  2. #2
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: How to create report in WORD with VB6.0

    Welcome to the Forums.

    You are wanting to create a similar word editor in your app or ???
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  3. #3

    Thread Starter
    New Member
    Join Date
    Jul 2008
    Posts
    3

    Re: How to create report in WORD with VB6.0

    sir, thanks for ur instant reply.

    Yes i want similar editor as WORD, with bullets, Tables,etc

    I know to make bold,underline in richtextbox control.

    but how to use word for using reports? (using word as a report editor) from VB.

    i want to open an existing word document in VB and editing some texts automatically.

    for ex

    (Beginning of the report

    patient name:<<patient name>> (empty in template)
    patient age :<<age>> (empty in template)

    some texts

    end of the report)


    This is the template i want to save.

    and when the user clicks a patientid and selects this template,
    The <<patient name>> and <<age>> should be replaced with vb text values
    and then the file should be saved in database.

    How to do this?
    Last edited by Beamsparker; Jul 1st, 2008 at 11:07 AM.

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: How to create report in WORD with VB6.0

    First you will need to use the RichTextBox control instead of a regular textbox control. Not sure if you can do tables in a rtb control but are you going to be using any part of Word itsself?
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  5. #5
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: How to create report in WORD with VB6.0

    Here is a rtb control tips and tricks codebank thread - http://www.vbforums.com/showthread.php?t=355994

    It should provide helpful for most tasks you are wanting except the tables.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  6. #6

    Thread Starter
    New Member
    Join Date
    Jul 2008
    Posts
    3

    Re: How to create report in WORD with VB6.0

    sir, thanks for ur instant reply.

    I need tables to present in the report.

    I know to make bold,underline in richtextbox control.

    but how to use word for using reports? (using word as a report editor) from VB.

    i want to open an existing word document in VB and editing some texts automatically.

    for ex

    (Beginning of the report

    patient name:<<patient name>> (empty in template)
    patient age :<<age>> (empty in template)

    some texts

    end of the report)


    This is the template i want to save.

    and when the user clicks a patientid and selects this template,
    The <<patient name>> and <<age>> should be replaced with vb text values
    and then the file should be saved in database.

    How to do this?

  7. #7
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: How to create report in WORD with VB6.0

    You could nest the actual Word program itself but then you may have issues as Word is not designed to be nested inside another program. Also your end users will need their own licensed copy of Word installed on their systems.
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width