Tables :: Recording Log In And Out Times By User
Mar 24, 2015how I record user log in/out times in a table with Access 2013.
View Replies
ADVERTISEMENT
Recording User Useage
May 19, 2005Any help most appreciated!
I have a Access 2003 database I am developing which has a table called "tbl_users" in which I have the fields:
user name(text), network id(text), status(yes/no), long on time (date/time), log on date(date/time), log off time(date/time), log off date(date/time).
When a user logs on my autoexec macro calls a prodcedure which sets that users status to "yes" or ticked and stamps the log on time and date. Is it possible to call this procedure even if they bypass the autoexec by holding down the shift key?
In reverse to this when they click the "Exit System" on the Main Menu form there is a call to a procedure which unticks there status field and stamps the log off time and date. Again, can I trigger this procedure even if they exit the database without using my "Exit System" button (ie click the "x" to close the database)?
Regards,
Dalien51
Recording User Login
Nov 20, 2006Hello,
I am developing a cylinder tracking system, when i user logs in its necessary to record this action, as when they try to fill a cylinder i need to be able to record that this particular employee has updated the table and by recorindg the user login in i will able to do this.
IS the anyway of being able to record whos logged in?
Forms :: Bank User Form - Recording Deposits And Withdrawals
Apr 8, 2014I want to create a form where i can be recording the deposits and withdrawals of my bank account!
Let's say I don't have any deposit. If I want to add then i would click on the "+Deposit money" button to open a form to add let's say 10$.
so my total would be 10$.
Next record would to add 30$
so my new total would be 40$ (10$ + 30$)
NOW if i make a withdrawal from my account i would like to click on the "- withdraw money" and so my total would change!
so if i withdraw 5$ the new total would be
35$ (total 40$ - 5$)
how can i do that?!!!
Tables :: Recording Multiple Dates?
Apr 24, 2013I'm creating a database and wanted to set up my table.
It is for a service with clients where we need to carry out a review every 6 months, so I need to create a way of entering a date every time a review is completed, then ideally a field that automatically totals the number of reviews that have taken place, and another field that automatically generates the date of the next review due - based on 6 months after the last review date.
Is that possible? It seems silly to keep adding fields for potential reviews as most will only have between 1-3 but in theory it could be as many as 20, which would be a lot of wasted space and fields for most people!
Tables :: Recording Training Attended By Staff
Jan 25, 2014I have a database of staff members. There is a table with the details of staff; name, dob, address etc.
I need to set something up that will record the training that staff attend and then be able to print a report of who attended the training session and also a report of training sessions individual staff members attended.
I need to set up fields in a table for date, topic and presenter and then I need to somehow mark off staff members who attended.
Tables :: Using Default Value For Calculation And Recording To Table
Nov 19, 2013I shouldn't normally record calculated figures into my table. I'm willing to buck proper procedure here for ease of use for referencing in reports; also, it's just one data point that will be calculated only once and not changed.Anyhow, I have an IIF statement that calculates a total price based on a table of costs. I set this as the default value and it calculated properly - but once I set my text box to have a control source, it no longer calculates my cost.
I was hoping to set it so it calculated the cost and then write that total cost to my table.should mention that my calculated control is in a subform.
Tables :: Database For Recording Visits - File Number For Each Day
Dec 17, 2014l have a database for recording patients visits in a hospital,in addition for "serial" field I want to make "fileNumber" field which represents a continous serial number changes everyday but of course all visits in the same day have the same filenumber as in follows..
Ser-----Date----------FileNum
===========================
1-------17.12.2014------1
2-------17.12.2014------1
3-------17.12.2014------1
1-------18.12.2014------2
2-------18.12.2014------2
3-------18.12.2014------2
I cannot depend on date (I think) in the desired code because I want to skip weekend and holidays so FileNum continues after weekend (Friday) from the last number as follows..
DayOfWork----FileNum
===================
Sat---------------1
Sun--------------2
Mon--------------3
Tue--------------4
Wed--------------5
Thr---------------6
Fri---------------off
Sat---------------7
Sun---------------8
Forms :: Warn User When Data Being Entered 3 Times
Oct 24, 2013I am making a simple database for the computer laboratory in school (my place of work). Actually it is a Automated Logbook System. Here's the Problem. I want to make a form that will prompt me whenever I enter the data(ID number) of the user(student) 3 times already for the current week.
The message box will more likely prompt.
The Data already entered 3 times this week!!!
Forms :: Create A Counter To Log How Many Times A User Login To Database
May 22, 2013I have made a very simple log on form that requires the user to type in a user name and password. The user name and passwords are stored in a table. New users are added to this table to allow access to the database.
Is there a way I can add a counter to see how many times a particular user has logged onto the database?
Is there a way to make the password expire every 365 days requiring the user to reactivate their account and log in details.
How To Specify Relationships When Two Tables Are Linked Multiple Times
Nov 16, 2006Hey all, i would appreciate some help with Access here.
I am an attorney, and i am trying to set up an access database for all of my cases.
I have one table in which i keep the names, contact information, etc of all the witnesses who i have used or will be using (especially expert or law enforcement witnesses who i will be using in multiple cases).
I also have a main table in which i have a record for each case. Because I have multiple witnesses for most of my cases, I have had to create multiple relationships between my main cases table and my witnesses table.
My question is this: How do I specify when setting up a report (or a form/query/etc) that when i ask for the witness's address i am looking for the address i made with a particular witness, specify that relationship between the two tables, as opposed to the other relationships between the same two tables.
I hope that makes sense, and i would very much appreciate if someone could give me instructions.
Thank you.
Jay B
Queries :: Return All Records Shared Between Two Tables LESS THAN 3 TIMES
Nov 1, 2014I am trying to write an access SQL query that returns all records shared between table1 and table2 LESS THAN 3 TIMES.
application has 4 tables: Patients, AnnualPhysical, Doctors, and PatientPhysicalDoctors.
each patient has an annual physical (once a year), and chooses one doctor per annual physical.
each doctor can only perform three or less annual physicals per year.
It is a small application with less than 1000 records per table.
the query will allow the patient to choose an annual physical doctor once a year from available doctors.
Patients is one-to-many to AnnualPhysical;
AnnualPhysical is one-to-many to PatientPhysicalDoctors;
Doctors is one-to-many to PatientPhysicalDoctors.
query for all records NOT shared between Doctors and PatientPhysicalDoctors is:
SELECT *
FROM Doctors
WHERE NOT EXISTS( SELECT * FROM PatientPhysicalDoctors
WHERE Doctors.DoctorID = PatientPhysicalDoctors.DoctorIDFK );
Recording Which Reports Been Ran
Oct 27, 2005I have created a data base inwhich a user can run 6 reports. I then have a manager who has a administration form which i want the manager to see what reports have been ran and what day.
to run the reports the user hits a button in another form, which then exports a qry to excel.
All the buttons have been named and each report has its own marco name.
Is there a way i can do this simply??
Recording Database Changes
Aug 17, 2006Hi all
I have seen some functionality in another database and would like to add it to mine but I have no idea where to start. I was hoping someone would be able to point me in the right direction to a tutorial or sample database that could help me.
What I would like to do is record when changes are made to specific tables. For example, in a vehicle table, if the vehicle is changed from active to inactive for example, the date, the value that was changed and who did the change would be recorded somewhere. I'm guessing another table.
Can anyone point me in the right direction.
Thanks
Craig
Recording Payments
May 17, 2007I have a database with 10 properties which I want to record details of weekly or monthy payments. I have a table for properties, one for tenants details and one called payments. I then have them on a form. I want to open the tenants form and insert a command button to open the payments form and record payments as the occur but i can only enter one - it is giving me an error message as I am duplicating a record. The tables are linked with a property reference which I have set as the primary key. I have obviously done it wrong. Can anyone advise me of a way to do this please.
Thanks Tracey
First Recording Not Importing
Apr 1, 2008I am using access 2003. I've setup an import specification for a text file to import into a table. It's importing but leaving off the first record. When I setup the import specification, I did so as fixed width because the fields were not defining correct when I used delimited. Could it be that it's thinking that the first record include the field names? If so, how do I rectify this?
thanks
Recording Changes To Queries
Aug 4, 2007Hi All,
Some annoying sod at work has been changing queries and i've been getting into a hell of a lot of trouble due to it!
Is there any way to record changes made to queries?
I have an audit trail to record changes to the data displayed in the forms but I really need to catch this SOB before they cost me my job?
Any ideas?
Ta
Dante
Recording Weight Loss
Mar 3, 2007My wife is slimming, I would like to record weekly results.
How do I make a new entry compare with her ideal weight and flag up her progress.
e.g. ideal weight =10 entry 1 13 entry 2 12.9 etc
Can I get the cell holding the new entry to refer to the ideal weight and flag up the difference each time I update the weight for the new week?
Recording Visits To A Form
May 31, 2005Is there a popular way to show when records are updated, with something like a text box with Now(), please, Gurus?
It needs to be automatically enacted. (A box that they complete themselves gets quickly forgotten.)
Then if the Client refers to records changed on such and such a date, I can find them instantly.
Recording Time Values
Aug 3, 2006I Have a problem in which when I create a record I wish the record to automatically record the time it was created. I have achieved this by having a timerecorded field within the table and setting its default value to time().
later on I wish another time to be recorded. This time when the user selected an option box to -1 I wish the time to be stamped into another field. I have used this event procedure to write the time to another field.
Private Sub AOGCleared_AfterUpdate()
'Update Time
If Me.AOGCleared = -1 Then
Me.TimeAOGCleared = Time()
Else
Me.TimeAOGCleared = ""
End If
End Sub
however It records the original time of creation when the obtion box is selected. Can anyone please point me in the direction of how I get access to record this later time please ?
Front End Not Recording Information In Back End
Jan 16, 2008I have a database that I built as one large database, then used a method I found on here to creat 2 brand new databases and copy the tables from the original to one and use it for a back end and then copy everything else to another file to use as the front end. I did this and it worked great, except that now the information being input into the forms on the front end is not being recorded into the back end. I tried relinking the tables and it still was not working. Is there a secret step I missed or something I need to fix in order to make this work properly? The way I made the front end dependent on the back end was by linking the table from the back end to the front end. I checked the object dependencies and it shows those as being correct. Any suggestions or comments would be greatly appreciated!!! I am truly only a novice when it comes to Access and just in the past 6 months or so have been using it regularly.
Thanks in advance.
Recording A Formula In Control Source
Jul 20, 2005I am pretty new to access, and I am wondering how you record the output of a formula in control source. Here is what I have.
I am trying to find how many days are between two dates. The formula that I put in the control source in the form is =IIf([txtQSFNonQSF]<>"qsf",CalcWorkdays([earlydater],[earlydatec]),"")
but it does not record to the field datecompleted.
How do I get this to do it.
Thanks
Greg
Help With Customer Referral Information, Recording And Showing
Feb 5, 2007Hi,
I want to record and show some referral info.
I would like help on where to record and how to show the info.
I want the infor to be shown per contact, in the contact details screen.
See below for details.
http://img506.imageshack.us/img506/5707/accesscontactdetails2ej4.jpg
I am really struggling doing this.
Problems With Recording Data In Table Through Forms
Jul 5, 2006Hi All,
This is my first post on this forum...:)
I'm having the following problems:
I have a table with "n" fields.
Each field will constitute a form.
Each form will have a button which will open the next form.
Basically I want to record new data into the table (database) through FORMS.
What I am unable to do is to record data on the same line in the table !!!
What I have so far is that I am able to move to the next record when creating a new NCR but the rest of the data (fields) are going to overwright the first record in the table (first line).
I would attach my database here but the file size is bigger that permitted.
If someone interested I could foward it on e-mail.
My second issue is that after recording data into the table I want to be able to modify that data through a form. When a certain NCR number is choosed this will pop-up the NCR form with all fields from the table.
Any suggestions are more than welcomed.
Thanks for your help...
Mumus.
Problems With Recording Data In Table Through Forms
Jul 5, 2006Hi All,
This is my first post on this forum...:)
I'm having the following problems:
I have a table with "n" fields.
Each field will constitute a form.
Each form will have a button which will open the next form.
Basically I want to record new data into the table (database) through FORMS.
What I am unable to do is to record data on the same line in the table !!!
What I have so far is that I am able to move to the next record when creating a new NCR but the rest of the data (fields) are going to overwright the first record in the table (first line).
I would attach my database here but the file size is bigger that permitted.
If someone interested I could foward it on e-mail.
My second issue is that after recording data into the table I want to be able to modify that data through a form. When a certain NCR number is choosed this will pop-up the NCR form with all fields from the table.
Any suggestions are more than welcomed.
Thanks for your help...
Mumus.
Recording Date That A Record Has Been Appended And Deleted
Jul 20, 2007Hi,
I hope someone can help.
I have a macro that appends and deletes records to a new table once the the record has been closed. I need to record the date this was done in my original table and the new table and have had brain freeze as to how to achieve this.
Any suggestions??