Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: What should I buy?

  1. #1
    Board Regular TinaP's Avatar
    Join Date
    Jan 2005
    Location
    Ohio
    Posts
    513
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default What should I buy?

    I've been tasked with a project that requires something more robust and secure than Excel macros. In the distant past, I wrote projects like this using Visual Basic. Since Visual Basic has gone the way of the Pony Express, it's not an option. I was thinking about using Visual Studio, but there are so many different options I don't know what to purchase.

    The request:
    Create a comment/complaint tracking log where employees can enter comments/complaints, but cannot see or delete previous entries. I would be the only person writing and maintaining the software but everyone in our organization should be able to use it.

    I know we can purchase software to do this tracking but we are a small organization and the Powers That Be don't want to invest tons of money into a tracking system that would be bloated with features we would never use. On top of that, it would be a good exercise for the programming lobe of my brain.

    Can anyone make any suggestions about what software to purchase to create the tracking log? I don't even understand enough of the pricing model to attempt a guess as to what I should buy.
    I not only use all the brains that I have, but all that I can borrow. --Woodrow Wilson

  2. #2
    Board Regular Kyle123's Avatar
    Join Date
    Jan 2012
    Location
    Leeds, UK
    Posts
    2,225
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    Default Re: What should I buy?

    How big is your organisation? You may qualify for the community edition, it may be used commercially under the following terms:
    Organization licenses. If you are an organization, your users may use the software as follows:
    Any number of your users may use the software to develop and test your applications released under Open Source Initiative (OSI) approved open source software licenses.
    Any number of your users may use the software to develop and test extensions to Visual Studio.
    Any number of your users may use the software to develop and test your applications as part of online or in person classroom training and education, or for performing academic research.
    If none of the above apply, and you are also not an enterprise (defined below), then up to 5 of your individual users can use the software concurrently to develop and test your applications.
    If you are an enterprise, your employees and contractors may not use the software to develop or test your applications, except for open source and education purposes as permitted above. An “enterprise” is any organization and its affiliates who collectively have either (a) more than 250 PCs or users or (b) more than one million US dollars (or the equivalent in other currencies) in annual revenues, and “affiliates” means those entities that control (via majority ownership), are controlled by, or are under common control with an organization..
    Failing that, assuming Visual Studio, you'd want Visual Studio professional - you can PAYG at $45 per month, or buy the "Standalone" @$499
    Last edited by Kyle123; Sep 26th, 2017 at 12:40 PM.

  3. #3
    Board Regular
    Join Date
    May 2015
    Posts
    822
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Tab indent for sanity.

  4. #4
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    40,925
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: What should I buy?

    Since Visual Basic has gone the way of the Pony Express, it's not an option.
    Not sure where you are getting your information from.
    Despite many "rumors" to the contrary, there are no plans to get rid of Visual Basic in the near future.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  5. #5
    Moderator mole999's Avatar
    Join Date
    Oct 2004
    Location
    UK
    Posts
    8,250
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: What should I buy?

    access back end, and updated records flagged not to be viewable, then you have the full log
    • Yes I know there are better ways to do it. I just wish I knew them. - 2003, 2007, 2010, 2013 & 2016
    • I wear my ignorance openly, excel is not my chosen career, its a means to an ends
    • Posting Guidelines Want to post well laid out questions and answers Translate Excel Versions
      Code:
      [CODE ]Put Your Code[/ CODE]
    • Settings > General Settings (on the left) scroll to the bottom, > Miscellaneous Options > Use ENHANCED
    • X-Posting Guidelines Rule 13 > CHART STUFF

  6. #6
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    30,031
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    4 Thread(s)

    Default Re: What should I buy?

    Quote Originally Posted by Joe4 View Post
    Not sure where you are getting your information from.
    Despite many "rumors" to the contrary, there are no plans to get rid of Visual Basic in the near future.
    I think he was referring to the "real" VB (the compiled version whose core is at the heart of VBA), the one that Microsoft abandoned in favor of what they originally called VB.NET and later misleadingly changed to simply VB. In case you didn't detect it in my "voice", this is still a sore subject with me.
    Last edited by Rick Rothstein; Sep 26th, 2017 at 02:43 PM.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  7. #7
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,457
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: What should I buy?

    You might want to take a look at PowerApps. If you're already a Microsoft shop, it should be pretty reasonable, and from what I understand, it's robust and relatively easy to use.
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com