Results 1 to 9 of 9
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comple my vb programs.. then what do I do (VB 6,)

    Right now I have a series of forms (12) that are called EDGAR as a group. The forms were created in MS Outlook 98, save the data to MS Access 97, and print forms in MS Word 97. I also export some data to MS Excel 97.

    I have been asked to convert the whole thing into a "program" using VB - 6. and use SQL for storage. My question is.. If I convert all the form in vb.. how do I print, and save the data. Will I need to make sure that everyone still has MS Word and MS Access to use this.

    Where can I find information so that I can complie my work and set it up in somekind on Installation wizard. The last part is so that the Network group and call call up the installation and install the program in anybody computer. What would I need in the way of MS Office to do this... Would it matter if we/user has NT4 or OS2k or Office 97 or Office 2000.

    I have never done this before and I am lost trying to figure this out. Any pointers or directions on where to find reading material will be very helpful.

  2. #2
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comple my vb programs.. then what do I do (VB 6,)

    Dear Trailblazer Dan,

    The question of requiring Word and Access on the clients depends on whether you want to contiue using automation from VB to utilize the objects in these apps or you want to re-invent the whole schebang in VB native or 3rd part control objects. It seems pretty unreasonable to expect you to shelve the automation objects unless management is going to remove MS apps (moving to Linux are we??).

    When you get the install package finished, post back. I'd like to know the best (low cost) tool for that too!
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comple my vb programs.. then what do I do (VB 6,)

    Will not reinvent the wheel... I will use MS Word to allow them to print out the form. As for Access... We will at the some time convert our Access 97 db into a SQL database. That is another project I need to work on. What steps needed to create new tables, queries, reports. etc. etc. Also, what hardware, software and sop we need to develop.

  4. #4
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comple my vb programs.. then what do I do (VB 6,)

    Moving the database to SQL is always a good idea. Do you get to become the database administrator, too?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comple my vb programs.. then what do I do (VB 6,)

    R U using VB or VBA?

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Houston, Texas, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comple my vb programs.. then what do I do (VB 6,)

    I have the full VB Studio Enterprise ver6.0. Not using .NET

  7. #7
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comple my vb programs.. then what do I do (VB 6,)

    Kevin,
    <hr>Moving the database to SQL is always a good idea<hr>
    Interesting comment.

    Would you care to comment on <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=acc&Number=66373&page=& view=&sb=&o=&vc=1#Post66373>this post</A> in the Access forum?
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  8. #8
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comple my vb programs.. then what do I do (VB 6,)

    Sure. I just posted there.
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  9. #9
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comple my vb programs.. then what do I do (VB 6,)

    Thanks Kevin.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

Posting Permissions

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