Table Design For A Clock Card System
i'm try to create a database to record staff sign in and out times and to get reports but i cannot for the life of me get it working after many many efforts. can any one help me?
View Complete Forum Thread with Replies
Related Forum Messages:
Employee Time Card System
I need to develope a system that will allow for employees to login and imput their "time card". I found one post on here about something similar, but it didn't give much info. I am very very new to Access so please give info in simple terms or very well explained. I am hoping that I can have a login and password so employees can't access eachothers time card. All it will need to track is Date Type of work Hours Rate Comments I am hoping that this is going to be an easy task, but I need some help. Anyone have any ideas or directions... or even better know where I could just download a template. Thanks, Chrissy
View Replies !
Time Clock / Punch Clock App
Has anyone created a time clock Access application? I'm referring to a app that will allow the user to sign-in at the beginning of the day then sign-out for lunch, sign back in then sign out at close of business. Then be able to total the number of hours at work. I've searched the forum and see others have asked the question in the distant past, but have found no answers. What I'm 'hoping' for is that someone has a sample app they are willing to share so others can see how to set this up. Thanks in advance for any help or suggestions. rickyT
View Replies !
System Design Question
Hi, We have a relational DB that holds information on West Nile Virus. Currently, we have 5 tablet PCs that take a full copy of the DB and updates/edits are done in the field. Once a month, the tablets come back and someone manually takes the 5 databases and uploads the changes to the central database. I want to find an easier way to do this. Some sort of 'synchronization' type of process. Can anybody recommend anything? I am not too experienced with Access and this sort of functionality. I think ideally I would create an application to check data in and out of the central DB, but I'm not really sure where to start. Any help is appreciated. Thanks!
View Replies !
Creating A Register System/table
Ok, firstly im sorry if this is in the wrong forum. I say this because my problem first begins with the tables but then i need to sort a problem out with the form aswell, but i will put it in here. Here is the problem. Im sorry if im not too clear with this. I need to create a register system E.G. A child comes into a club, he is registered. At the end of the session the child leaves the club. His depature is registered and his departure time is also recorded down. Like a paper based school register but electronically. How would I go about implementing this into a system? Would I need a child table (with fields such as Child ID, Forename, Surname etc.) and a register table (not sure on the fields)? k, this bit below probably goes in the forms section... How would I get this to work on a form so there were boxes to check for arrival and departure, and when a button is clicked the depature time is filled in for each day of the term?
View Replies !
Problem Scanning Over All Non System Table
Hi guys i wrote a vba code that supposed to go find all non system tables in access 2000 db and generate corresponded create table statements for them. Unfortunately when i run the program it misses one of the tables called committee members and also uses one of table names 2 time.Furthermore, instead of using table names it uses first columns of each table in generating table name for createing table statement.I be happy if some expert help me fix this bug in my vba program.Thanks http://i5.photobucket.com/albums/y180/method007/tablereletionstenissvba1.jpg ( teniss club db reletions ) http://i5.photobucket.com/albums/y180/method007/createtablestatementvba2.jpg (genrated create table statements) Code:Private Sub CreateTableButton_Click() Dim T As TableDef Dim db As Database, cont As String Set db = CurrentDb() For Each T In db.TableDefs If Left(T.Name, 4) <> "MSys" Then ' 'If T.Name = Me.ComboBox Then pk = Left(GetPK(T, db), InStr(1, GetPK(T, db), "<-") - 1) cont = cont & ShowFields(T.Name) & vbCrLf & " primary key " & pk & vbCrLf & vbCrLf ''MsgBox ShowFields(T.Name) & vbCrLf & " primary key " & pk & vbCrLf & vbCrLf ''End If End If Next T MsgBox cont Call createTextFile("C:createTableStatements.txt", cont) End Sub
View Replies !
Realtime Clock
I've got 5 time zones showing on the main screen of my db, just by doing date() and subtracting number of hours for each time zone. Only problem is need a refresh button on it for people to click. Can you get a realtime clock ticking away on an access form?
View Replies !
Table Layout For Airport Minicab Quote System
ok basically im creating a quote system that will show users prices from one destination to the other destination based on the size of the vehicle.. you can see a similar quote system used on the following website.. http://www.londonairporttaxi.co.uk there will be three main tables.. Airport Table airportID - primary key, autonumber airportNAME - text the airport table will consist of 5 records..Heathrow,Gatwick,Stansted,London City, Luton Town Table TownID - primary key, autonumber TownNAME - text the town table will contain a list of postcodes, maybe 50 or so (n1,n2,n3,n4,e1,e2...) Car Table CarID - primary key, autonumber CarNAME - text the car table will consist of 4 records..Saloon,Estate,MPV,Executive now what i need to do is create a similar quote system like there is on the url above.. my original idea would be to do something like this.. Have three tables that contain the quotes for each type of car..the first two listed here will work i think.. Airport2TownQuotes Table quoteID - primary key, autonumber carID - foreign key from car table airportID - the airport Pickup, foreign key townID - the town Destination, foreign key price - currency Town2AirportQuotes Table quoteID - primary key, autonumber carID - foreign key from car table townID - the town Pickup, foreign key airportID - the airport Destination, foreign key price - currency however.. for airport to airport quotes.. the resembling table would look something like this.. Airport2AirportQuotes Table quoteID - primary key, autonumber carID - foreign key from car table airportID - the airport Pickup, foreign key airportID - the airport Destination, foreign key price - currency but you cannot place the airport id twice in the same table..(this maybe a case of simply renaming the airport fields in this table such as airport1, and airport2.. but can you still link them and enforce integrity if the fields have different names?) also one example may be Heathrow to n1 is £30... this does not mean however that n1 to heathrow will be £30.. this is why i need to separate the quotes in this way.. for the 3 possible journeys (airport to airport, town to airport, airport to town).. also the quotes will be different for each car type.. anyway.. i shall be using asp to create a similar quote system on my website.. but i just need to get the final layout of the database sorted. thanks in advance for any help.
View Replies !
Sync With Computer Clock
Hi, My question is...is there any way to get Access to work out the actual day of the week from a date entered into the computer? The reason for this is...I am designing and implimenting a bookings data base for a village hall, and I wish access to automatically store what day of the week it will be on the specified date, in a field called 'Day'. I need this field to produce a report for the week ahead, showing exactly what is in on which day of the week. Is there any way this can be done? Or do the days just have to be typed in manually, i.e. check a calendar and type them in? I would appreciate it if anyone could give me info...on ANY way this can be implimented...be it store the dates in a table or use a giant Iif statement or whatever! And the tags necessary would be helpful, Thank-you for your help in advance, and i apologise for such a lengthy post! Please get in touch directly through c.majury@ntlworld.com or alternatively post the answer here. Chris
View Replies !
Employee Punch Clock
The company I work for has a central office and out employees work at different locations around the city. I have setup a database so that reports and requests made by employees are put into the database and sent to our office and clients office, instead of the tri copy forms we have been using. One thing that we were interested in doing was setting up a punch clock in the database so when employees come and go they punch in and out and there is a report that can be printed weekly or biweekly. Unfortunately I have no idea how to start making that feature, I would appreciate any help or advice on what direction to go...
View Replies !
Adding A Simple Text Clock To A Form
Trying to make a simple clock inside my form. So far I got my clock but it isn't running. It only get's the time when I open the form but I want it to keep track of time. Searched the forums but couldn't find anything that relates to this problem.
View Replies !
Using A * (Wild Card) In Pop Up Box?
Is it possible to use a * (Wild Card) in a pop up box for a query? I read the previous post about pop up boxes for quires and it worked worked great! I created one for my month field My criteria in my search fieled is a follows: 05-May 06-June 07-July 08-August etc... As you can see someone would have to type a 08-August to get the results for August, can a wild card be used? Example 08* would return all of 08-August data. I tried it but it wouldn't return any data. Any help would be appreciated. Thanks, Scott
View Replies !
Fried Graphics Card. What Do I Do?
Hi, I'm in a a lot of trouble. My graphics card has stopped functioning, leaving me with a perfectly good computer that I cannot use. In order to retrieve the information from the harddisk, I got a cable between this computer and another one. This is my plan: When the "blind" computer is started, I will enter the cmd. From there I would like to be able to "share" one of my folders on the small network (ie the two computers). Is there a DOS command for this? second question: If I have VNC server installed, will I be able to see the desktop from another computer allthough I can't see it on the blind computer? Does that information go through the graphics card before it is sent over the internet, or after it has arrived in the VNC viewer computer? Fuga.
View Replies !
Magnetic Card Reader
Looking at creating a database that looks up records based on a number from a magnetic card. Has anyone ever come across any code that will pull the info from the serial port? I have been looking for 2 days and not able to find anything. I have the card reader but do not have any software to get the info from the serial port and my limted coding does not even come close to what I need. Any help or a push in the right direction would be greatly appreciated. Thanks, Matthew
View Replies !
Business Card Scanner
I want to use a business card scanner, and use the data for my Access 2000 order database. Most card scanners, can send data to Outlook, can you go from Outlook to Access? Any advise would be appreciate it . . . THANKS!:o
View Replies !
Wild Card In IIF Statement
I am using a criteria entry form as the source of parameters for a select query, and I am using IIF statements in the query so that if the user does not want to specify for that particular field, the search still works based on the other parameters specified. Therefore the statement I am using is; IIf([Forms]![Criteria Form]![Customer Account] Is Not Null,[Forms]![Criteria Form]![Customer Account],[Data]![Customer Account]). This works. However for some of the criteria I want to also use wild cards, so that the user can enter just part of the data, and the relevant records will be returned. I understand that wild cards cannot be embedded into the IIF statement above. I have tried many methods, and trawled the web for ideas, but I cannot get this to work. I either want the user to enter the wild card themselves ie "100*" returning records starting with "100", or for the query to append the wild card itself. Can someone help please?
View Replies !
Wild Card Name Searching Help
How would I make a query find a person like this: Inputted Data: Smit Outputted Data: Smith, Smithy etc.. The formula I have entered in the criteria of my query is: Like [Enter the person's last name] With this formula, if I type Smith, then the data that comes out is Smith. But if I type in smit or smi, Smith doesnt come out. Thanks.
View Replies !
Wild Card Searches
Ive read loads of posts about Wildcard searches but am unable to find the answer to my problem. In one of my boxes on my search form the user places in the search criteria value, this can be from A1 - A16 all the way to G16. At the moment i'm using this as my seasrch query: [Forms]![Search]![BoxNo] So if I put in C1 then I get all the C1's, great. If I want to wildcard then I put in Like "*" & [Forms]![Search]![BoxNo] &"*", and again it works, this time it call enything with C1 in it i.e C13. How can I adjust my query to do both, sometimes I only want the exact match othertimes I want to wildcard :confused:
View Replies !
Access Wild Card Search Help
Hi I have a query that depends on the input (several parameters) from a form. The form has a list object that shows the results of the query. For example, when I type in "s" in last name and "b" in city, it shows everybody whose last name starts with s and city name that starts with b. The problem is that it excludes all the records with blank cells in either last name or first name or city. In another words, the list is already pre-filtered with records that contain all three fields (city and first name and last name). For example, the record (Last name: Mosby, First name: Ted, City = blank) will be excluded from getting displayed because it contains no characters. Can someone help me out with this issue? I would like to include those people on the search even though their city is not entered in the table. With the query parameter empty, I would like to show a very raw list (a list that is not filtered at all). The Query is built as follow: The criteria for the field "Last Name" is Like [forms]![simform].[lastnamesearch] & "*" The criteria for the field "First name" is Like [forms]![simform].[firstnamesearch] & "*" The criteria for the field "City" is Like [forms]![simform].[city] & "*"
View Replies !
Wild Card On Search Form Issue
Hi all, I need a little help with a wild card issue, Ive looked and looked and cant spot whats wrong. I have two forms "Requisitioner" & "Engineers", each form has a subform. These are basic search forms (unbound) that find related records in the subforms. The work is done in the query of the subform and then the form is refreshed. I have used this approach many many times without issue until now. If the engineers form is opened "G*" is entered into the text box then all the entries beginning with "G" are found in the subform. If the "*" is then removed from the text box leaving "G" no results are found in the subform, (Working Correctly) Now if the "*" is added again "G*" then the subform shows all the entries beginning with "G" Everything is good with the Engineers Form, If the same steps are made on the Requisitioners form after adding the "*" again no records are displayed. I could change the way this works by doing a recordset find but i really want to know why this is working on one form but not on another. I would appreciate any help with this. Garry
View Replies !
Seeking Much Help With Generating A Card Number From Another Field
Hi guys, I need some help here and any would be muchly apprieciated. I am building a database for a theme park fast pass system where a customer can book themselves a place on a ride at three session times a day. Now my problem is, that I need to generate a card number. 5555 1946 as the first 8 digits (this always stays the same) and then the last 8 digits is the customer ID number, which is in the same table. So there are 16 digits in total. Let me give you an example: A new customer registers and are assigned a customer ID of 1000 0001. Therefore the Card Number for that customer must be 5555 1946 1000 0001. I have used auto number for customer ID so when a new customer signs up, there ID is 1 more that highest already in te database. Simple question really...but how is this done? A million marks for someone who breaks it! Hehe Thanks
View Replies !
|
TRACKER
