I am migrating users from a very large shared multi-user-access spreadsheet to an access database and they have started using the application i have created for beta testing.
One of the issues/requests is to have functionality that occurs with shared spreadsheets where each person accessing it is shown when they are editing a cell. What the users have requested is that if someone has opened a record to edit/update etc that their name be shown on the continuous form that shows all records so they know there is no need to go in and update.
the process is that there is a central email address that all the users see for updates and from the update emails they go to specific record on the continuous form, double click on it to open the form and make the updates. So what the users would like to see is if someone has opened the record that users name is displayed next to the record.
My thoughts on this would be as follows:
From the Continuous Form:
Happy to provide more information, pictures, table diagrams etc if necessary but as a mock up:
The last column is just a text box added to show where the info would be displayed as to who has the record open. When you double click on any field of a line it opens a form displaying the record the user double clicked on
thanks in advance
One of the issues/requests is to have functionality that occurs with shared spreadsheets where each person accessing it is shown when they are editing a cell. What the users have requested is that if someone has opened a record to edit/update etc that their name be shown on the continuous form that shows all records so they know there is no need to go in and update.
the process is that there is a central email address that all the users see for updates and from the update emails they go to specific record on the continuous form, double click on it to open the form and make the updates. So what the users would like to see is if someone has opened the record that users name is displayed next to the record.
My thoughts on this would be as follows:
From the Continuous Form:
- On Double Click event check you are opening a valid record (as in it has an ID and is not a new record)
- If this is a valid record
- find the record in the recordset
- if the "User Editing Record" field is empty
- update field with current user
- open form with record
- if the "User Editing Record" is not empty
- message box popup saying record is being updated by "User"
- if not valid do nothing
- When user closes form find record in the recordset
- Set "User Editing Record" field to blank
Happy to provide more information, pictures, table diagrams etc if necessary but as a mock up:
The last column is just a text box added to show where the info would be displayed as to who has the record open. When you double click on any field of a line it opens a form displaying the record the user double clicked on
thanks in advance