okay so this question isn't fish related at all, and not even really for this forum. but I like you guys and there are lots of people here with lots of skills. so heres the question.... I am building a database for work, its basicly to say yes or no.. yes you can go out the gate, or no you can't. then once you are approved to go out track the time you left and the time you come back in. (the time part isn't critical but would be nice to go ahead and add in. yes/no would be based on a table with last name, first name and an employee number, 5 digit. the idea i am having right now is to have the computer inside the building and a wireless bar code scanner to take out side. or a wired one, that is passed through the wall. any help on the yes/no with out the out side access to a keyboard?
access database
- Thread starter redman88
- Start date
lol i wish. but they would get tangled up real quick. and then they couldn't work. not that they do much anyway
its been years since i took a basic C++ class..... 10 in fact. so i know a bit about code, should have written out what i was looking for
input from form- employee ID (received from Barcode Scanner)
check- input against gate clearance table
if employee Id is in table - good write to check out table with time reset for next Id
if bad- out put warning for 5 seconds- return to form for another input
maybe that might make more sense?
input from form- employee ID (received from Barcode Scanner)
check- input against gate clearance table
if employee Id is in table - good write to check out table with time reset for next Id
if bad- out put warning for 5 seconds- return to form for another input
maybe that might make more sense?
eh I hate access as a database so in secure. If you want a better db I believe MySql is free but I would personally go with MSSQL.
Your best bet imo is MySQL it is very easy to create databases on it and I believe it is free.
MSSQL is probably the best db software but you will need a little bit more experience to work with it.
MSSQL is probably the best db software but you will need a little bit more experience to work with it.
I might be wrong but if i remember correctly you need to use true or false fields in C++ and in MySQL you will use values of 1 and 0 (1 or any number above 0 being yes and 0 being no).
Im trying to remember how C++ coding works but its been a couple off years since i have used it.
I can have a look at some of my old books tonight and see if it comes back to mind but im sure someone will answer you before then
It shouldn't be to hard to get it to work as you are only querying a db to see if a user has access and if not it will return him to a different table (and tell him to get back to work)
Im trying to remember how C++ coding works but its been a couple off years since i have used it.
I can have a look at some of my old books tonight and see if it comes back to mind but im sure someone will answer you before then
It shouldn't be to hard to get it to work as you are only querying a db to see if a user has access and if not it will return him to a different table (and tell him to get back to work)
can't use MSSQL. I was just stating that i have programed some, and i know its possible. I basicly have to use MS Access i work for the state. so getting anything else would take an act of congress.