Locator application

Posted on 2004-10-27
Last Modified: 2010-05-02
I have been working on this project for more than a year now. I only attended one Hands-on VB6 class, and I designed the application using a MSFlexGrid and making it work like a worksheet. I use text fields. Combo, and DatePicker objects on top of the flex grid to enter and modify data. The user enters the date (Datepicker), the user id defaults to the Login, time from and to, Leave descripton (Combo), the Contact Nbr, and Contact Name. I had my colleagues test the program, and they always find bugs on it. I'm using random access file to store the records.

The program works fine if the user enters data in sequence from left to right, won't click the fixed rows, or any unusual clicking on the flex grid. Of course, that is not acceptable.

I need your opinion on whether I should just change the program so that the MSFlexGrid is used only for display, and let the editing on separate text fields outside of the grid.
Question by:m0mmymia
    LVL 5

    Accepted Solution

    I hate to sound judgemental but why not just use Excel, or another worksheet app, instead of a VB app?

    The nature of what you are trying to do can be handled by Excel pretty easily.  

    Storage of your results and text entry are both a given.  It can do combos directly onto the worksheet and date entries either by allowing the user to type or a form with a date picker/month control launched via a small button.  Creating the rows on the fly can also be achieved via macros so your users always have rows to enter into.


    To answer you actual question :) the FlexGrid is pretty naff and you have to work hard to get any kind of 'pleasant' or controlled interface from it.  

    There are much better grid controls available that can do the kind of things you want - at a price of course.  The only one I have much experience of is Formula One but it is probably overkill for what you want.  TrueGrid does your requirements I think but been some years since I saw it.

    Your last point makes most sense - display via FlexGrid and collect data via an edit form.  Makes data entry much slower though - you lose that ease of movement between bits of data that a spreadsheet gives.

    LVL 16

    Expert Comment

    If you want to go the Excel route but also want to wrap it within its own VB6 app, you can reference the Microsoft Excel Object Library and add the Microsoft Office Spreadsheet Control to your app.  This will give you the Excel functionality within your app...


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Introduction This article makes the case for using two modules in your VBA/VB6 applications to provide both case-sensitive and case-insensitive text comparison operations.  Recently, I solved an EE question using the LIKE function.  In order for th…
    There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

    856 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now