Forms :: Second User Record Changes When First User Selects Record
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 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
Mar 19, 2013
I am working on a form and I only want the information to be inserted into the database if the user clicks the button at the bottom. In other words, if the user is filling out the form and then closes the form, I do not want that record saved.
View 2 Replies
View Related
Dec 2, 2013
What is the best way to warn a user if a record already exists?I've looked at some examples that use an SQL SELECT statement with a recordset to compare existing records against the one the user is entering but i'm not sure which event this should be triggered by - eg; would it be the control's 'After Update' ,on 'Dirty' or 'Change' event? Would the record have been saved when the 'After Update' is fired- if not then it would not be found in the recordset and the SQL would not work....
how to create a textbox function that automatically searches and completes the textboxt based on exisitng records (like the cell autocomplete feature in Excel)? This could then populate the form with the existing record fields (if found ) and the user could update the record if necessary?
View 1 Replies
View Related
Sep 6, 2014
I am creating a form that has a bunch of yes/no box for daily task. Is there a way for access to record which user selects yes/no.
For example
yes/no box1 - user 1 completed this task
yes/no box2 - user 2 completed this task
and so on
So when i look back i can see which user complete which task. I did a bit of research and saw that i can save a user that update a record. But since this is a daily task, each new record will be a new day.
View 3 Replies
View Related
Jul 3, 2014
I have a form that allows the user to select a record in a combo box. When this selection is made I want a 2nd form to open and give the user a place to enter additional info about that item selected. I have the forms working correctly but now I would really like to add the 2nd form to the first form as a subform but when I try this I get the message"The expressing is typed incorrectly or is too complex to be evaluated..." There are no fields on the first form that link directly to the 2nd form - because the combo box in an unbound combo (the selection in the combo box is what the 2nd form opens base on) I tried to add this as a subform with no parent/child info and I get the message stated.
I was hoping to make the 2nd form not visible until the selection was made in the combo box then make it visible for the info to be entered. Would really like it to be on the same form not as a separate form opening.I believe I just found that the reason for the message. It seems not to be a subform problem but is because the selection in the combo box needs to be made BEFORE the form can open. So now the question is - how can I make this a subform and avoid this error when the main form first opens. I will test the visibility and see if not visible until the selection clears this up.
View 10 Replies
View Related
Feb 23, 2015
I have a field that is pre filled in with a value. The name is "Business".Then there is a combo box with various values. If the user would select a value that does not match with values that can be selected if in "business" a value is selected, it should show a message that the selection is wrong and user needs to select the correct one.
Example:If in the field "Business" the value "Food" is selected, then the possible values to be selected in the combobox would be: Fruit or Meet or Fast Food. If the value in "Business" would be "Wood" only selections could be made: Talble or Chair or Cabinet.So, if a user select "Food' in "Business" and in the combo box "Chair", it should show a message that the wrong selection was made and don't let them use the wrong one.
View 11 Replies
View Related
May 11, 2012
I am trying to find out if there is a way to track the order in which items are selected from a list. I am a dabbler and any keyword searches that I can think of don't bring up what I am looking. So, here is what I am trying to do:
I have a table of symptoms with 3 fields (ID, Category, and Symptom).I have a combo box that will allows the user to pick a category (using select Distinct on category field). I then have a list box populated with all the symptoms that have a category of whatever the user selected. The problem I am having is that I need to somehow track the order in which the user selects symptoms and then save that order for future reference and to be printed on a report. The order is important because the most severe symptom needs to be listed first.
View 7 Replies
View Related
Aug 5, 2014
How do I allow a user the ability to enter in text into a combo-box so that it saves to that record?
View 6 Replies
View Related
Feb 6, 2015
I have a form with a Count textbox. It's control source is a field named "Audit Count" in the table "DB Audits". The idea of the textbox is to display a running count of how many audits a specific auditor has completed that day. To do this I have the textbox set up with a default value of:
Code:
=DCount("[Loan Number]","DB Audits","[Auditor] = fOSUserName() And [Audit Date] = Date()")+1
Assuming I'm using the DCount function correctly, this is supposed to count the number of [Loan Number] records entered in the "DB Audits" table by the auditor (whose name is found using fOSUserName()) on today's date. So, for example, when opening up the form at the beginning of the day the Count textbox would read 1 and when the auditor clicked Save and New it would increase to 2.
The problem I am having is something I encountered while doing some random tests of the form. If an auditor submitted an audit (let's say the 1st of the day), the form correctly displays the next count as 2. However, if the auditor were to delete the record from the underlying "DB Audits" table while the form was still open, if they were to enter a new record, the Audit Count field would display 2 even though it should be 1 (since the 1st record had been deleted).
How can I have the Count textbox refresh whenever someone deletes a record from the table while the form is still open? I tried a Requery command using the AfterDelConfirm event but I couldn't get it to work.
View 6 Replies
View Related
Mar 17, 2015
I am new to Access and I am trying to make a Database. However, I have an attachment with each record and I would like to know if there is a way of making a button/link that will allow the user to navigate from each record to its respective attachment.
View 6 Replies
View Related
Mar 28, 2015
I am building a form to create a user record and at the same time i have some yes/no options which are located in other tables but when i want add a user i cannot select any yes/no options they seem locked?
View 1 Replies
View Related
Aug 14, 2013
I'm very new to access so I'm not sure about the correct way to go about this. I have a table with a 'category' column, a form which hides the category column, and a combobox to filter the category, let's say R, C, and F.
What I want accomplish is to have the value of the comobox applied to the hidden 'category' column when a user enters a new record into the form.
Is there I way I can get an instance to the record as it's being entered and modify the data using VB? Or would I have to write a sort of pop() function and have it run afterInsert and then modify it that way? Can I even alter the table using VB like this?
View 4 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
May 12, 2005
Hi Guys
I am begining to create a IT support database for my company. I have never really needed to use secuirty for the other projects that i have completed but this one is a bit different. i have used the security wizard to create the users and groups but would like to get the basis of the security correct before i go any further.
My question is how do i configure it so that users can only update or change or delete thier own entries apart from me who could alter anything. Do i begin now when i am setting up the tables or is it a bit more complex and would require checks during accessing forms etc.
Any help and advice would be great
Many Thanks
Martin
View 4 Replies
View Related
Oct 14, 2005
Hi I was wondering if anyone could shed any light on this problem. I have a new database going live in two weeks. My problem is that I keep getting a message telling me that someone else is editing the record.. which is an impossibility as it is a stand-alone copy on my hard-drive at home! How is this possible? Will this problem be solved once I have this database on the sql server and the tables has been upsized to sql? Also this database is to be used by up to 100 people is this going to be a problem?
View 2 Replies
View Related
May 15, 2006
Hi All
I want a user to click a button and then it will assign the oldest record in the table to that particular user, by using their NT login.
Anyone got any suggestions?
Thanks
View 5 Replies
View Related
Nov 15, 2004
I have a form based on a query that selects only the people working in a single office, and displays
various personnel data items. All of the data is contained in a single table. Whenever I update
any of the data in the form, I get a message saying that another user edited and saved the data
before I edited the data. Its rother annoying, and I can't figure out why it is happening.
The form is bound to the query, and a list box contains the names of the folks. A subform contains
the personnel data, and the two are connected by the primary key.
View 1 Replies
View Related
Dec 12, 2006
The Database is not split. Have 30 some users.
Here is what I am trying to do.
I have Mary, Sam and Bill logged into the database.
When Mary signs in she has no records to update, but when Sam and Bill logs in they have records to update.
How can I get a message just to Sam and Bill, but not to Mary?
I have a qry what records needs to be updated.
Just how would I go about this? I thought I had it when I use the "environ" but that just shows who is logged in. I am sure the form has something, but I haven't found out where.
Can you point me in the right direction?
View 4 Replies
View Related
Apr 13, 2006
I keep thinking this is so obvious I shouldn't have to ask, but....
I have a database, the back end sits on the network. Forms in the front end are bound to the data in the back end. This is certainly not optimal, but it has worked.
I'm guessing other uses of the network have increased, though, cause now, Access occasionally chokes when trying to open the forms.
So I need to unbind them.
Okay, I know how to do that. Trouble is, how do I deal with multiple users accessing the same record at the same time. With bound forms, Access may not handle it as elegantly as possible, but at least it does try to handle it.
Every example of unbound forms I have ever seen have grabbed data, used it to populate the form. Then if the record is edited, throw the changed data back to the back end. But what if someone jumped in between when the data was grabbed and when the changes were written back? How do I handle that?
To make matters worse, my users absolutely want to be able to continue to search and filter the forms. Plus, the form has detail data in continuous sub-froms.
I am thinking of accomodating that by up front having them select a subset of records, either all for a given customer, or hopefully, just a given invoice. I plan to copy that to a table on the front end, and bind the form to that copy.
When they change the beginning filter value, I would write the data back. But that could be hours later. Lots of time for the data to become stale.
Any suggestions on how to deal with these issues? Pointers to where is has been discussed before? (Hey, I did look, but all I found were vague, "you have to watch out for...." but never a way to handle it when it does happen.)
Thanks,
David
View 4 Replies
View Related
Jan 25, 2007
I have a problem where a user (with what I believe are the proper security settings) cannot save a new record in a form. I have set the securities on the form and the related table and query to allow this user to create new records (Add/Run).
This user is able to access the form and enter the data, but it will not save. I have added a "Save" button to no avail.
When I log on as the administrator, it works fine.
Any Ideas?
Thanks in advance.
View 3 Replies
View Related
Oct 10, 2006
Hello,
I have a database we use to enter new account numbers and several other atribbutes about the account and it is split into a FE/BE with the BE in a shared folder. I have the open database using record-level locking checked but it seems to me that the database is opening up with page-level locking. Multiple users will receive a message that the current record is locked and I am sure that they are all not updating the same record. Does anybody have any idea's of what I can do? If nothing else I am going to have to recreate my form as an unbound form and see how that goes.
View 14 Replies
View Related
Feb 22, 2005
If I have a field in a table called "AddedBy", is there a way for this to default to the CurrentUser that's logged in to the database when a record is added to the table? I know you can use "Application.CurrentUser" both in the VB code and within SQL queries, but it doesn't seem to work if I put it in the "Default Value" box with the table editor. Any thoughts on this would be appreciated. Thanks!
View 2 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
Nov 23, 2011
how to display the user's record or database after he/she login in on the system. Currently I have a database where in the user enters his username and password. But the I dont know how can I make his records display after login.
View 1 Replies
View Related
