General :: Capturing And Saving User Name Who Created And Updated A Record
Jul 20, 2012
I have taken the Access Tasks template and modified a bit. It now captures and saves the time and date a record is modified. The database is on a network folder and is shared among our team users.What I would like to do next is make it,
1- capture and record on my Tasks table the user name of who created the record by using the fOSUserName() function. I have the table fields "Created by" and the VB code in a module. This would happen only once when the record is created.
I would also like to do this with the machine name for which I have the module too. fOSMachineName()
and,
2- capture and record the user name of who modified a record. For this I also have a field in my task table "Last Modified By" and i hope i can use the same fOSUerNmae() function.
I got to the point where I put an unbounded text box with the =fOSUserName() in it and it does show the user name but how do i get to record to my task table?how the template removes the tasks that are completed from the task list as soon as it is updated to completed? how can I make this happen with a cancelled option after I add it to the drop down list?
View Replies
ADVERTISEMENT
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
Aug 6, 2014
I have a database that was created in Access 2003. I'm using this MDB in Access 2010.I need to change a user created menu. The update involves changing an existing entry and adding a new menu item. The menu looks like:
Project
Time Entry
Time Spread
I need the "Time Spread" to change to "Time Spread Daily" with a changed macro name. After that a new menu entry is "Time Spread Monthly". This menu will run a new macro that will display a form.I think the only way to do that in 2010 is to use VBA.
View 1 Replies
View Related
Jul 22, 2007
I have a form in continuous forms mode...
Each entry is something the user is supposed to check on once and hour and update.
I have a "Last updated" field.
Now() goes into that field every time the record is updated.
I have a querry that will show the users records that are over an hour old.
How can I get Access to pop-up a window or something to alert the user they need to look at something? It would be really nice if Aspect would start blinking in the task bar or something.
Thanks!
View 5 Replies
View Related
Sep 16, 2012
I have a database that creates many forms based on queries which are based on user-defined variables. These are permanent variables added directly in the query, such as "if an employee is late 4 times in a month, we yell at them." I would like to be able to change this to "5 times in a month" if the users want to.
Rather than waiting for that to happen and having to change all my queries, i want to set up a form for them to access and edit the variable, save it, and then my queries to reference that variable.
My question is what is the best way to store and reference them? I could create a table, but i am not too sure how easy it would be to make my queries work with that.
I could also add them onto my main form which is always open, but I'm not sure how to make them save when access is closed. (a quick trial from my variable form won't let me update either a text box or label value on the main form).
View 5 Replies
View Related
Aug 31, 2014
I have an access program and i want it to save a copy into a location... ive got it so it can save however - i want it to save to the current users documents folder (win 7)
What file path would i use?
View 5 Replies
View Related
Dec 18, 2012
I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not even sure how to trigger an event to do it just the one time when the record is created.
View 2 Replies
View Related
Mar 4, 2006
Hi...
I am relatively new to access.
I have spent a few days coding a database search page consisting of various comboboxes and textboxes. the user can select or enter data in these and when he/she clicks the search button an SQL select statement is generated on the fly and updates an existing query and this is used to query the database. I want to be able to give the user the option to save the query he/she generates and reuse it. How can I prompt him for a name and turn the SQL string strSQL that he has generated into a query and save it for later use?
Any help greatly appreciated..thanks
View 4 Replies
View Related
Feb 6, 2007
In this db, the users select their name from a dropdown in an auto-open form, but with no password. I want to capture this value for use as the default value in a field on another form, but with the first form closed. I have seen the ENVIRON(Username) function referred to many times on here, but I need to capture the entered value, not the Windows or network login.
Is this possible without leaving the form open? I suppose I could just set its Visible to False when they enter their name, but I try not to have any more windows open than are necessary.
THANKS for your help!!
View 8 Replies
View Related
May 18, 2006
I have done some searching to find a method for logging & timestamping when users log in and out. I have no problems with capturing the Log IN information my problem lies with the log out portion where I am trying to use a Update query to update when the user logs out of the database:
I can get the update query to do what I want, but for some reason it is creating a duplicate record (exactly the same as the last record updated)
Here is the code I am using:
UPDATE LogInTable SET LogInTable.LogOutTime = Time()
WHERE (((LogInTable.LogOutTime) Is Null) AND ((LogInTable.UserName)=LogUserName()));
Basically I am trying to tell the Query to ONLY update records where the "LogOutTime" is Null AND where the UserName field in the table = the username of the person trying to run the update query.
Please help I can't figure out how to prevent these duplicates. :(
View 9 Replies
View Related
Dec 4, 2013
I'm working on a database that will be used by two different groups. Group A provides a list of items to be investigated by Group B.
I'm wondering if it is possible to:
i) have Group A create an excel file of items to be investigated (let's call the file tblNEW)
ii) open a record in the file through a form (let's call the form frmINPUT) to allow Group B to input investigation findings
iii) save the modified record into a separate table of all the work that has been done (let's call this table tblWORK)
iv) delete the investigated record in tblNEW once it gets saved into tblWORK
View 1 Replies
View Related
Feb 19, 2008
Access 2000:
There is probabily a simple function that can do this, but I'm stuck to find any explanation so I was hoping someone could help. I've tried the forum search but I guess I'm looking for the wrong thing.
I have managed access to the databse using the users/groups facility. So everyone who accesses the database has to effectively log in.
Users will be creating a record in only one table. When they save this record I need Access to automatically populate a designated field with the Users Log On name.
My question is how?
Thanks in advance for your time.
View 11 Replies
View Related
Mar 12, 2014
I trying trying capture the ID no. of a record for future use. I have tried different combinations on different form events. Nothing works, what am I doing wrong? The latest I have tried is the following, on the load event,
Code:
Private Sub Form_Load()
Dim LoadNo As String
DoCmd.GoToControl "ID"
LoadNo = Me.ID
txtLoadNo = LoadNo
End Sub
View 7 Replies
View Related
Jul 24, 2005
Hi,
I was wondering how difficult it would be to do the following:
1. A user opens up a form.
2. The user uses a combo box to select his/her name.
3. There is a date combo box on the form and by default, it is set to today's date. So when the user selects his/her name, the records for today are displayed. Changing the date will show only the records for the date shown.
4. The user will have the ability to add and delete records specific to the criteria chosen in the text boxes. Adding new records will only add records for the date chosen in the combo box. E.g. if he/she adds a record for today, it will only be seen when today's date is selected.
Will a subform have to be used for something like this? Or could it be done with one form using filters?
Any thoughts and/or approaches on this would be greatly appreciated.
TIA.
View 3 Replies
View Related
Jun 22, 2015
is there a way to find out who has a record open and send him message or someting similar?It happens from time to time that some one has a record open (selected in a form) and then is doing other things while the record is locked and a second person can't do nothing to the record.
View 14 Replies
View Related
Aug 18, 2014
What is the best way to allocate a record number to the end user?
I have had problems where users have come back to me saying that both of them created the same record number at the same time and I am not sure why that is happening.
To be certain, I am using INSERT rather than UPDATE which was my initial concern (an update would just over write the previous record)
How can we check the last value, uniquely assign that value to a person at the point of creating the record and ensure that no one else can take it...
Is it possible that a laggy server would cause these issues? (as the code executes roughly the same time as another person also executes code, they overlap?)
View 1 Replies
View Related
Jan 26, 2015
i want to be able to create an On Click Event when pushing a command button that will run an Update query to update a record and after it has been updated that specific record will pop up on a Form and be displayed. i know a different way is to run the Update query and then have it displayed in a Select query but i want it to be displayed on a Form instead. is it possible?
View 4 Replies
View Related
Dec 21, 2012
I have a master table with about 40 fields. In addition, I created eight child tables with read only datasheet views of limited fields from the master table. The child table views are based on certain critera in the master table and are being refreshed by using delete and append queries tied to the On Current property of a form. By double-clicking a specific child record, a form is opened to allow editing of the master record. Also, I am using Referential Integrity and Cascade Update Related Fields to update the child table when a change is made to the master. However, I do not know how to add a record to one or more child tables when a record is added to the master table. The new child record would have to be based on the same critera that the append queries use so it gets added to the correct child table or tables.
View 5 Replies
View Related
Mar 17, 2015
i am currently developing a database what i need to do is to restrict user to view selected record and change them. i have build a login form in which i have two areas as a user name in combobox and a password text box. i have another form in which i have a combo box named area what i need to do is to limit the area combo based on the selection of the user login form previously. for example if a user select LAS VEGAS in user combo and enters its password after clicking the button login the another form appears in which thier respective stores and sales are saved, their is a combo box named area in which i want to limit it by LAS VEGAS i mean it would only show LAS VEGAS in drop down based on the previous selection in login form.
View 4 Replies
View Related
Jul 2, 2007
New member, so forgive me if this has been covered before:
Trying to build a Business database (more for the exercise than any desire to run a business) and have the following problem -
Have a Purchase Ordler Line table and an Item table - the item in the PO line is a lookup from the Item table - I want the PO line price to default in from the the item table.
Created the query and generated the form & subform - on screen, the substitution works, the PO line price does get picked up from the Item table, but the PO Line table does not update with this value.
Is there a soltion to this?
Any assistance gratefully accepted
View 14 Replies
View Related
May 17, 2006
Cant find what I am looking for on the forum so if anyone can help me or tell me what to search for that would be great...
I need one of my forms to display a running total of updated records, but only those records that the user clicks a command button on. i.e if i have a recordset of n records each time I move to the next one (by clicking a command button) I want the control on the form to display the count of those records that have been updated only.
I am assuming I would need to add some code to the after update event of the form or on click event of the command button but cant really figure out what code to write.
Any pointers?
View 3 Replies
View Related
Feb 26, 2013
I am working on a database. I changed some of the data that was already in the database and it saved without any problems - when I reopened the database, the data was still there. But when I try to input completely new data, none of it will save (it is a database of employees and their information). So, just to make it more understandable, when I change one piece of information, it saves without any problems, but when I want to add a new employee together with their information, save it and reopen the database, it is not there.
View 4 Replies
View Related
Jan 10, 2013
I'm working on a database to create service tickets for a small IT Department. I've created a form that would be sent via email using the collect data option. The thing is that I want to send an auto-response email each time a new record is created to the person(IT user) submitting the data. What is the best approach for this?
View 1 Replies
View Related
Oct 30, 2013
I'd like to count the number of objects in my DB to check if I'm running into the 32,768 object limit. I'm experiencing unusual and disconcerting behavior, and all the normal corruption repair techniques aren't working. I've imported all the objects into a new database container, decompiled, compact & repair, and nothing works until the I delete some objects (forms, reports, queries, etc).
New objects created don't appear in the navigation pane until I close and re-open. Also, changing a query type from select to append doesn't result in the icon changing in the navigation pane.Code seems to run fine and everything else appears OK, but I really can't continue development until this issue is resolved. I fear continued development may lead to further corruption.after 20 years, this application has grown, I use a variety of techniques to get the size of the application. Currently:
1. 201,200 lines of code in 910 modules, reports and forms.
2. 544 forms
3. 328 reports
4. 3,617 queries (yes, I know, but it's so much work)
5. 450 tables (about half are linked)
I always thought, without thinking too deeply, that the number of objects in the spec refers to the number of reports, forms, modules, etc. But, now I'm wondering, do they also mean all the controls on the forms, and or the fields in the tables? What do they mean by objects.
I used Point Limited's translation modules recently to extract all the label and caption text for a French language translation project and it pulled out something like 21,000 individual controls, and, combined with this issue, I'm beginning to wonder...
View 5 Replies
View Related
Jul 24, 2012
I've created a switchboard with multiple buttons. I need to have one of the buttons "upon click" to open up a picture or video.
View 5 Replies
View Related
Apr 27, 2006
New here, looks like a great resource.
I have a question about a form which has several fields on it. What I need to do is to capture the ALL the fields of the record I just entered(updated or inserted)
So, for example, if my form has fields for
RepID, RepName, Company
After I edit or insert a new record, when I click to the next line, is there a way I can use AfterUpdate event to capture ALL the fields that were just updated on the form, and do whatever it is I need to do with them? I hope I am amking myself clear. Thanks for taking the time to look.
View 6 Replies
View Related
