Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Locator application

Posted on 2004-10-27
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

RogueSolutions earned 1500 total points
ID: 12428954
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

ID: 12432002
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...


Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…
Suggested Courses

618 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