Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Visual Basic - visitor system

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
Visitor-System-V9.xls
0
Didsi
Asked:
Didsi
  • 2
1 Solution
 
TracyVBA DeveloperCommented:
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

0
 
DidsiAuthor Commented:
sorry but i am very much a begginer at VB, could you please explain how!
0
 
Rory ArchibaldCommented:
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.
Regards,
Rory

Visitor-System-V9.xls
0
 
DidsiAuthor Commented:
Brilliant, worked perfectly! Thankyou
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now