[Webinar] Streamline your web hosting managementRegister Today


Attendance tracker software using barcode

Posted on 2003-02-18
Medium Priority
Last Modified: 2010-05-18
Is there anyone have a templates for program using visual basic for attendance tracker using barcode?

If no one..can you gave me a simple program code for that project?

Here's the scenario:

On our library we are using barcode and library automation that has a database of all patrons but our project is to verify or trace who's entered the library..

We want to make a simple program that can read and store barcode data into notepad or any text application so that when we import it on Excel, or MS Access or link to our Library Automation we can trace who's entered on our library on dy and time..we want to know if student or faculty are more often to come in library and what they course..

thanks a lot!

Question by:aeolian_angel
LVL 11

Accepted Solution

TreyH earned 140 total points
ID: 8039700
If you are still looking for some help try this to get you started.

Create a new standard exe visual basic project
Add to the form, a text box and command button.

Add the following code to the form:
Option Explicit
Dim m_oFS           As Scripting.FileSystemObject
Dim m_oTS           As Scripting.TextStream

Private Sub Command1_Click()
    Set m_oTS = m_oFS.OpenTextFile("c:\Attendance.txt", ForAppending, True)
    m_oTS.WriteLine """" & Text1.Text & """;" & Now
End Sub

Private Sub Form_Load()
    Set m_oFS = New Scripting.FileSystemObject
End Sub

Private Sub Form_Unload(Cancel As Integer)
    Set m_oFS = Nothing
End Sub

Private Sub Text1_KeyPress(KeyAscii As Integer)
End Sub

Run the project. Clicking on the command button would simulate a barcode being scanned. The barcode reader should issue some kind of keypress event after the card is scanned. So the code under the Command_Click event would need to go under some other event that would fire after the card was scanned. What you end up with is a c:\Attendance.txt semicolon delimited text file that can be imported into access, excel ect... Hope this helps to get you started. Oh yea, you will need to reference the "Microsoft Scripting Runtime" in your vb project.

Expert Comment

ID: 9300053
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept TreyH's comment
Please leave any comments here within the next seven days.


EE Cleanup Volunteer

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

612 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