Recording User Useage

May 19, 2005

Any 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

View Replies


ADVERTISEMENT

Recording User Login

Nov 20, 2006

Hello,

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?

View 1 Replies View Related

Tables :: Recording Log In And Out Times By User

Mar 24, 2015

how I record user log in/out times in a table with Access 2013.

View 2 Replies View Related

Forms :: Bank User Form - Recording Deposits And Withdrawals

Apr 8, 2014

I 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?!!!

View 2 Replies View Related

Multiple Instances Of Access To Allow For VPN Useage

Feb 22, 2007

I have a very elaborate Access 2000 application that uses three different SQL databases as the back end. Mostly the data is modified or selected via ADO connections.

The problem I am having is that recently users on Terminal Server are not able to open the application because for some reason the application is not allowing more than one copy of it to be opened at once. I checked everywhere and couldn't find anything that would not allow multiple instances but couldn't find anything.

Any ideas on what could be causing this? Any help is greatly appreciated

View 11 Replies View Related

Recording Which Reports Been Ran

Oct 27, 2005

I 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??

View 6 Replies View Related

Recording Database Changes

Aug 17, 2006

Hi 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

View 2 Replies View Related

Recording Payments

May 17, 2007

I 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

View 1 Replies View Related

First Recording Not Importing

Apr 1, 2008

I 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

View 3 Replies View Related

Recording Changes To Queries

Aug 4, 2007

Hi 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

View 5 Replies View Related

Recording Weight Loss

Mar 3, 2007

My 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?

View 3 Replies View Related

Recording Visits To A Form

May 31, 2005

Is 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.

View 10 Replies View Related

Recording Time Values

Aug 3, 2006

I 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 ?

View 5 Replies View Related

Front End Not Recording Information In Back End

Jan 16, 2008

I 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.

View 4 Replies View Related

Recording A Formula In Control Source

Jul 20, 2005

I 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

View 4 Replies View Related

Tables :: Recording Multiple Dates?

Apr 24, 2013

I'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!

View 1 Replies View Related

Help With Customer Referral Information, Recording And Showing

Feb 5, 2007

Hi,

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.

View 7 Replies View Related

Problems With Recording Data In Table Through Forms

Jul 5, 2006

Hi 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.

View 2 Replies View Related

Problems With Recording Data In Table Through Forms

Jul 5, 2006

Hi 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.

View 1 Replies View Related

Recording Date That A Record Has Been Appended And Deleted

Jul 20, 2007

Hi,

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??

View 2 Replies View Related

Tables :: Recording Training Attended By Staff

Jan 25, 2014

I 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.

View 5 Replies View Related

Tables :: Using Default Value For Calculation And Recording To Table

Nov 19, 2013

I 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.

View 2 Replies View Related

Forms :: Recording Data (Totals) Onto Form

Apr 30, 2013

I have created a form to input invoice details with a sub form to input the products with the prices etc.

This all works fine but now I want to create totals such as Total Goods, Total VAT and Invoice Total.

After many searches of the internet, I found out how to do this and put in the calculations which works fine and displays on the main form without a problem.

Now I have a problem as these need to be saved to one of my tables.

As these are unbound text boxes with only the calculation on, the data is not being recorded onto the form which is what I want.

Do I have to create a macro of some sort to do this or?

I have included a few images of what I have done but if you would like the database file I can upload that (I will take away all the information that is sensitive to me if that is okay?)

View 4 Replies View Related

Tables :: Database For Recording Visits - File Number For Each Day

Dec 17, 2014

l 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

View 14 Replies View Related

Forms :: Recording Date And Time A Form Was Last Updated

Jul 29, 2014

Displaying the 'Last Modified' dates and time on a form. How to go about doing what I want to do.

I would like to display on a form in one single field the date & time that any of the fields on that form were changed and. I would like to display it in such a way that it cannot be altered by anyone. If it is possible to capture and display on the form in a separate field which user account accessed and changed the record then all the better. Obviously if nothing is updated then the date and time stays the same.

I will have to create two new fields in the table that relates to the form and this I have done - one of format Date/Time and one of format Text.

View 7 Replies View Related

General :: Recording Information In Form - Filling In New Fields Based On ID

Jul 26, 2012

I have a form to record student information. On my student table i have a school I.D that links to the primary key of my school table.

My problem is that in my form, i want to be able to fill in the rest of the fields about the school info based on the I.D chosen.

i.e.

student table:
Student id
name
address
school I.D (FK)

School info table:
School I.D (PK)
school name
contact name
email
address

My form that's linked to the student table needs all the information from the school info table in separate fields
but i can only select School I.D in the Control Source Property.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved