Help With Tracker
Dec 11, 2007
Hi Guys,
I am really stuck here. For some reason I am not able to link tables together.
I am not sure if i have separated the tables correctly.
The Employees are related to the ODF number
Here's what I want to happen
2 tables
Employee
- LastName
- FirstName
- Extension
ODFNumber
- Queue
- ScanDate
- Status
- SentDate
Please help.
Also, I am having problems with creating the forms
I want to be able to just enter the ODF number and know what the status is and who is processing it.
Thank you very much.
19879
View Replies
Feb 15, 2007
I have a database which I have written for part of my coursework for school. However I have a small comany interested in it, I have added security to it using the wizard in access and what I would like to be able to do now is to be able to see when each user has logged in and logged out so I can track how much use it has had when I go to carry out maintance on it.
I know this one might be pushing it but I would also like it to say what each user has accessed while they have been logged on.
Do any of you know how to do this? or could you give me some pointers about were to start?
View 1 Replies
View Related
Nov 1, 2005
I would like to keep track of 5 seperate funds (or stocks) by price, daily change, total change...etc.
I was thinking of having a table with date as the primary key containing the daily price of each fund. I will enter the prices into this table manually every day.
A second table will automatically makes appropriate calculations and save these changes on a daily basis based on the date. With no user input.
Is this possible?
Can I have the second table automatically grab the dates from the first table? Would the second table use date as primary key for calculations?
Thanks,
~dnnymak :eek:
View 4 Replies
View Related
Oct 12, 2006
folks,
need to know if there is a simple way to
1) find whether an access database has been updated
2) if so send an email to an address
is there an easy way to accomplish the above
need to monitor an access db for any updates and notify upon any changes.
tx
View 2 Replies
View Related
Jan 29, 2008
I'm currently attempting to setup a small database to track a few things for the company I work for, namely attendance. Currently they use an excel spreadsheet that covers the current year. This worked great for them when they were still a small company, but with the number of employees shooting from 50'ish to a couple hundred the spreadsheet is just not a viable option any more.
What I need is suggestions on the best way(s) to go about implementing this.
First, I need to do a 1 year look back, on a montly level is fine. So from January 2008 back to January 2007 will work fine. What i have currently setup is a form with 12 of the basic Calender controls built into access 2003. Unfortunatley these wont quite work.
Basic layout of my database so far will be an employees info table, a lookup table for Attendance codes and their infraction values and an attendance (or I suppose more technically an absence) table. I would like to have a form that displays a calendar view for the last 12 months, that will allow me to view / update any absences for an employee. I would also like a way to insert company holidays / shutdowns in to the attendance table in a way that marks it on any employees calendar as a scheduled day off. I assumed i could do this with a simple "all" employee along with the dates and have the calendar search for entries with the Employee ID as well as the All flag and mark those on the calendar.
I think if i can just get the calendar setup covered I can figure out the rest of the data aspects, I'm just stuck on finding a decent way to implement the Calendar Aspect.
Thanks in advance!
View 14 Replies
View Related
Feb 10, 2012
I've been asked to come up with a method of tracking outbound calls for my company. This is a new job for me and I'm aiming to impress.. but I'm a touch out of my element so I'm not trying to reinvent the wheel here.
I've found this starting point: [URL] .....
But I'm having difficulty conforming it to function the way I need it to. Basically, I want the applet to
-store the employees name
-store customer names that were called
-a checkbox for whether or not an appointment was set
-a textfield storing an appointment date/time [if applicable]
-four radiobuttons to select which area of the business the call pertains to
The employees would submit new values everyday, and ideally I would like the data to be accessible in a real time line graph.. I totally assumed this would have been done and redone before and that there would be a plethora of templates to choose from online, but for the most part my search has been fruitless and the only solid lead is the one posted above.
View 1 Replies
View Related
Sep 15, 2014
I am currently preparing a time tracker in my office where there are similar task assigned to different users.
I created a form and split it for front end user and back end user. front end database was copied by each user in their local. However problem is that whenever a front end user update their database it is also reflected in other users database. Is their anyway front end user can see their database only....
View 1 Replies
View Related
Nov 7, 2012
My Main Table in my Database is "Quotation", what do i need to do in order to create a new Main Table called "Quotation Tracker" and "Quotation" would now be under "Quotation Tracker"
View 8 Replies
View Related
