User Tracker
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 Replies
ADVERTISEMENT
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 8 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
May 22, 2013
I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.
View 3 Replies
View Related
Aug 4, 2007
Hi guys,
I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...
We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...
Best ideas anyone?
dazza61
View 6 Replies
View Related
Apr 24, 2013
I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .
All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.
View 1 Replies
View Related
Oct 28, 2004
I have two tables. The first contains details of a budget holders money allocation for a given period, and the other tracks their spend on products over that period. How can I generate a query to calculate the total running spend for each user from the "budget spend table" that will be written into the users record in the "budget allocation table".
My aim is to show details of budget allocation, total spend to date and remaining budget for each user in an Order form / report.
Can anyone please advise me on how to do this or suggest another way of doing it. Any help would be greatly appreciated.
Thanks in advance.
Regards Peter
View 5 Replies
View Related
Jul 31, 2014
I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.
But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.
View 1 Replies
View Related
Sep 2, 2014
Will like to check, i have a access database which can be open up by a few users.
How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?
View 4 Replies
View Related
Jul 26, 2005
I need some help building what I believe is called a user end. I'm done building the tables and forms and all that jazz, now I need an interface that my boss, who knows nothing about access, can easly access and manipulate data. Of course it would be nice if I'd look nice. Is there anybody who can help or can give me link to a decent tutorial.
I already searched these forums and googled for help.
View 13 Replies
View Related
Nov 29, 2005
i plan to use the Group security feature for my DB.... using the user ID and password... i also want to make use of the user ID in the autopopulating of some of the field in my forms.... if for an instance the person logged in is akshal... then the a particular field named "filled in by" is to be autopopulated by the user ID (i.e. akshal)
View 2 Replies
View Related
Apr 7, 2006
Can someone direct me to help with setting up User rights? I've always been the only user, but now I have multiple people working from my database and want to limit there authorizations. Also, is it possible to have someone actively using the database while I continue to make changes for forms and reports?
Thanks in advance for the help.
View 2 Replies
View Related
May 9, 2006
hi. i just wanted to know how to get a litle yellow box to appear saying enter text here when the user puts the cursor over a field where hey enter text on a form. thanks
View 2 Replies
View Related
Aug 31, 2006
Hi I am new to Access and just need some advise.
I currently have 5 different excel spreadsheets that record sales for 4 different state's then another to hold stock items.
I want to make an access database to hold all this info.
Should I make one table to record all information from the 5 spreadsheets or have a seperate table for each.
Any advise would be most appreciated.
Tks
View 4 Replies
View Related
Mar 17, 2007
Hi all
Well ive been using this forum for about a month now, and as an inexperianced user of Access D/B I find this forum is a wealth of information from the cream of Access programers. I have bought DVD courses of ebay in the past but has no comparison to the knowledge on this forum.
Thank you all.
Chris
View 2 Replies
View Related
Jun 9, 2005
Hi guys,
im a new user of Access and don't really know what im doing.
i need to make a database that will keep track of technical drawings. I need the database to be able to search for a drawing number, we might have a few of these types of equipment, so if i am adding a drawing of a different piece of the same equipment i need it to automatically generate the next number in the sequence.
This is hard to explain...
Ok, i have a load of Drawings, say they are numbered
0010-020-A-001
0020-020-A-001
0030-020-A-001
Right the first part is the type of equipment, the second is the sub-group, the thirs is the drawing type....this will all be entered by the person whois entering it into the register, the 001 at the end means it is the 001 revision of the drawing. If i have made a new revision of the drawing, say 002, i want to be able to use a form to enter the first bit of the serial number, then it will automatically tell me the next number in the sequence, and will let me fill in the other details, then i can click a button "add" or register or something and it will automatically update all the details...
....i would be so grateful if anyone knows a solution to this, or if this is even possible
thanks in advance
Cokes
View 10 Replies
View Related
Oct 24, 2005
I would like to welcome the users at login on my db,
I have a table that list user details which has the following fields
tblUserDetails
UserID
UserName
Password (encrypted)
UserLevelID
FirstName
LastName
EmailAddress
What I am trying to achieve is after logging in, I would have a welcome $User$ on the splash form/switchboard
So to re-cap, I would like some kinda vba coded example that will ref [FirstName]
Thanks in advance
View 2 Replies
View Related
Dec 28, 2006
Hi,
I want to write the code to detect that whether or not the administrator assign current user to access the database in SQL Server.
How can i detect it?
Suppose I have a database db1 in SQL Server, we assign the username to specific database. And then I linked tables from SQL Server to MS Access
When the user open the MS Access, I want the program to detect whether or not the current user has his/her name in the database from SQL Server.
How can i do that?
I just know to use is_member function, but this one is detecting user role, I want to detect whether or not administrator assign the username to the specific database from SQL Server.
Please let me know about it.
Thanks.
View 3 Replies
View Related
Aug 12, 2005
Is there a way in which to assign user permissions to vba code?
I have some command buttons which run vba code but i only want to allow certain users to use these.
View 7 Replies
View Related
Sep 20, 2005
Hello all. This is my first post on here after reading many of the other threads as I try - often in vain - to pick up access.
I am in the process of building a couple of databases, the main one being one that is an amalgamation of 4 other/older mdb's. All tables/queries etc were simply imported from these older defunct mdb's and then are archived off every month so they have 3months data and no more in them. The only thing is when it comes to problem solving and/or new queries, it is impossible to tell which tables/queries relate to which sections of the Db.
So my question to you is can I rename tables and queries in any way so that any queries that are using these tables are updated at the sametime, and if so how is it done? I have asked my colleague who is working with me to develope my understanding of access and he is at a loss. We are in the process of trying the old fashioned way ..... getting a book from the libarary ... but thought I'd try this new fangled internet thingy first :D .
The thought of having to trawl through around 100 tables and queries to rename or even re write the entire query/formulae is so daunting, I simply dont have that amount of time. Im using Access 97 and would greatly appreciate any help on this.
Thanx
View 2 Replies
View Related
Sep 27, 2005
I have finished the database application, and now want to make a user login for specific users to run the application (but not to change the internal desgin or data).
How can it be done ?
Do I need to split the database first before doing that ? :confused:
View 1 Replies
View Related
