Visual Basic - visitor system

Posted on 2010-01-04
Last Modified: 2013-11-25
Hi, i have made a visitor signing in/out system with help of experts on here!

A small problem i now have is when someone with the same forename is selected to signout it just does the first person in the list with that forename.

Could anyone sugest the best way to resolve this!?

Many Thanks
Question by:Didsi
    LVL 24

    Expert Comment

    One way is to use a concatenated value of the surname and the forename, which would more than likely be unique.

    For example, set the ID you're looking for to the concatenated value as shown below.

    ID = surname & forename


    Author Comment

    sorry but i am very much a begginer at VB, could you please explain how!
    LVL 85

    Accepted Solution

    Try this version. I altered the signout listbox so it actually stores the row numbers when it gets loaded with the names. The sign out code then uses those row numbers rather than having to search for anything.


    Author Closing Comment

    Brilliant, worked perfectly! Thankyou

    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

    Join & Write a Comment

    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…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now