barcode punch clock

[zhuan li]

need help regarding part of a database I am trying to get functioning. User scans a card with a barcode need to log the entry time and reduce a unit value by 1 in a table e.g user has 20 credits when they log in thier time is recorded and 1 credit is deducted from the 20 credits a warning is displayed when the credits are reduced to 1. I am a novice in this , am using ms access, thanks in advance

[dglienna]

Post your code. What part are you having trouble with?

[zhuan li]

thats the problem, I dont have a code , new to programming and have built most of the database without complex coding.
I am so ashamed!
Richard

[Mark Gambo]

thats the problem, I dont have a code , new to programming and have built most of the database without complex coding.
I am so ashamed!
Richard

Well how about posting the structure of your tables in the database?

[zhuan li]

tables are as follows:
payments (date, amount)
products(item#,item name ,description,unit price)
studentorders(item#,item name,quantity, unit price ,sub total)
students(name,address,etc)
employees(Name,address,etc)
timecard(IDNumber,TimeIn)

I know I will have to add some more structure to the tables
e.g a student purchases a card with 20 lessons, when they clock in the time is recorded in the time card table and 1 lesson is deducted from the total,
I seem to have taken on more than I can chew, but really appreciate the help!

[dglienna]

Do you want to use ACCESS for your app, or do you want to redesign all your forms and deploy it in VB? Does it work to scan cards in already?

[zhuan li]

The progaram is for a small business so I think access is fine, the barcode scanner I use will text input to any field the barcode id is generated from the student or employee name

richard

[dglienna]

Well, if you write it in VB, then they won't need to have ACCESS installed at all. You can use the tables in VB.

If you want to use ACCESS, then this should be moved to the OFFICE forum.

[zhuan li]

Ok Ill try the OFFICE forum then, many thanks
richard

[dglienna]

Don't start a new thread. This one will be moved for you.