If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need to keep employee initials locked in front end application
I have a front to back split db from the switch board you select your
initials and login, which opens the data entry page with employee initials at the top of the page. The initials field is bound to the switch board that does not close. This is a 4 person multiuser db and when one person logs off their initials move to another users interface. How can I stop this. I have tried locking the initials field on the interface page but still it appears to happen. One issue I have considered is that two of us that are not having problems are using access 2003 and the two others are using 2000. Are there any other locks that should be applied or change the way we login? I am stummped |
#2
|
|||
|
|||
I need to keep employee initials locked in front end application
The way it sounds to me, it's as if they are all using the same Switchboard,
if they are then you need to need to change that, each should have a front-end loaded on their own machine and that would avoid that problem. HTH, Gina Whipp "DLMJR757" wrote in message ... I have a front to back split db from the switch board you select your initials and login, which opens the data entry page with employee initials at the top of the page. The initials field is bound to the switch board that does not close. This is a 4 person multiuser db and when one person logs off their initials move to another users interface. How can I stop this. I have tried locking the initials field on the interface page but still it appears to happen. One issue I have considered is that two of us that are not having problems are using access 2003 and the two others are using 2000. Are there any other locks that should be applied or change the way we login? I am stummped |
#3
|
|||
|
|||
I need to keep employee initials locked in front end applicati
Gina,
Each user has their own front end loaded on their own machine, which is what is bafling me "Gina Whipp" wrote: The way it sounds to me, it's as if they are all using the same Switchboard, if they are then you need to need to change that, each should have a front-end loaded on their own machine and that would avoid that problem. HTH, Gina Whipp "DLMJR757" wrote in message ... I have a front to back split db from the switch board you select your initials and login, which opens the data entry page with employee initials at the top of the page. The initials field is bound to the switch board that does not close. This is a 4 person multiuser db and when one person logs off their initials move to another users interface. How can I stop this. I have tried locking the initials field on the interface page but still it appears to happen. One issue I have considered is that two of us that are not having problems are using access 2003 and the two others are using 2000. Are there any other locks that should be applied or change the way we login? I am stummped |
#4
|
|||
|
|||
I need to keep employee initials locked in front end applicati
When they log-on, it is stored in any common table or in an unbound text box
on the the Switchboard? And what is the interface page? They way I do it is the frmLogOn which goes invisible after the user logs on and there ID is transferred to the Switchboard after they Log-On, how does yours work exactly? Gina Whipp "DLMJR757" wrote in message news Gina, Each user has their own front end loaded on their own machine, which is what is bafling me "Gina Whipp" wrote: The way it sounds to me, it's as if they are all using the same Switchboard, if they are then you need to need to change that, each should have a front-end loaded on their own machine and that would avoid that problem. HTH, Gina Whipp "DLMJR757" wrote in message ... I have a front to back split db from the switch board you select your initials and login, which opens the data entry page with employee initials at the top of the page. The initials field is bound to the switch board that does not close. This is a 4 person multiuser db and when one person logs off their initials move to another users interface. How can I stop this. I have tried locking the initials field on the interface page but still it appears to happen. One issue I have considered is that two of us that are not having problems are using access 2003 and the two others are using 2000. Are there any other locks that should be applied or change the way we login? I am stummped |
#5
|
|||
|
|||
I need to keep employee initials locked in front end applicati
The Switch board drop down is bound to the employee table, the initials on
the main form are bound to the main table "Gina Whipp" wrote: When they log-on, it is stored in any common table or in an unbound text box on the the Switchboard? And what is the interface page? They way I do it is the frmLogOn which goes invisible after the user logs on and there ID is transferred to the Switchboard after they Log-On, how does yours work exactly? Gina Whipp "DLMJR757" wrote in message news Gina, Each user has their own front end loaded on their own machine, which is what is bafling me "Gina Whipp" wrote: The way it sounds to me, it's as if they are all using the same Switchboard, if they are then you need to need to change that, each should have a front-end loaded on their own machine and that would avoid that problem. HTH, Gina Whipp "DLMJR757" wrote in message ... I have a front to back split db from the switch board you select your initials and login, which opens the data entry page with employee initials at the top of the page. The initials field is bound to the switch board that does not close. This is a 4 person multiuser db and when one person logs off their initials move to another users interface. How can I stop this. I have tried locking the initials field on the interface page but still it appears to happen. One issue I have considered is that two of us that are not having problems are using access 2003 and the two others are using 2000. Are there any other locks that should be applied or change the way we login? I am stummped |
#6
|
|||
|
|||
I need to keep employee initials locked in front end applicati
Okay, so the initials in both places are bound to a table. I don't remember
why and maybe someone can help with this (hopefully one of those gurus out there) but my LogOn ID is stored in and unbound field on and invisible log-on form and only closes when the user exits. I THINK it has something to do with the tables are all drawing from the back end and being stored in that field when a new user logs on the field in that table changes causes the field on another users station to change. Binding it an unbound text bos that holds the users log-on and does not look at the table to see if any other user has changed those initials by logging on. Hope that makes sense. Gina Whipp "DLMJR757" wrote in message ... The Switch board drop down is bound to the employee table, the initials on the main form are bound to the main table "Gina Whipp" wrote: When they log-on, it is stored in any common table or in an unbound text box on the the Switchboard? And what is the interface page? They way I do it is the frmLogOn which goes invisible after the user logs on and there ID is transferred to the Switchboard after they Log-On, how does yours work exactly? Gina Whipp "DLMJR757" wrote in message news Gina, Each user has their own front end loaded on their own machine, which is what is bafling me "Gina Whipp" wrote: The way it sounds to me, it's as if they are all using the same Switchboard, if they are then you need to need to change that, each should have a front-end loaded on their own machine and that would avoid that problem. HTH, Gina Whipp "DLMJR757" wrote in message ... I have a front to back split db from the switch board you select your initials and login, which opens the data entry page with employee initials at the top of the page. The initials field is bound to the switch board that does not close. This is a 4 person multiuser db and when one person logs off their initials move to another users interface. How can I stop this. I have tried locking the initials field on the interface page but still it appears to happen. One issue I have considered is that two of us that are not having problems are using access 2003 and the two others are using 2000. Are there any other locks that should be applied or change the way we login? I am stummped |
#7
|
|||
|
|||
I need to keep employee initials locked in front end applicati
Thanks Gina !
"Gina Whipp" wrote: Okay, so the initials in both places are bound to a table. I don't remember why and maybe someone can help with this (hopefully one of those gurus out there) but my LogOn ID is stored in and unbound field on and invisible log-on form and only closes when the user exits. I THINK it has something to do with the tables are all drawing from the back end and being stored in that field when a new user logs on the field in that table changes causes the field on another users station to change. Binding it an unbound text bos that holds the users log-on and does not look at the table to see if any other user has changed those initials by logging on. Hope that makes sense. Gina Whipp "DLMJR757" wrote in message ... The Switch board drop down is bound to the employee table, the initials on the main form are bound to the main table "Gina Whipp" wrote: When they log-on, it is stored in any common table or in an unbound text box on the the Switchboard? And what is the interface page? They way I do it is the frmLogOn which goes invisible after the user logs on and there ID is transferred to the Switchboard after they Log-On, how does yours work exactly? Gina Whipp "DLMJR757" wrote in message news Gina, Each user has their own front end loaded on their own machine, which is what is bafling me "Gina Whipp" wrote: The way it sounds to me, it's as if they are all using the same Switchboard, if they are then you need to need to change that, each should have a front-end loaded on their own machine and that would avoid that problem. HTH, Gina Whipp "DLMJR757" wrote in message ... I have a front to back split db from the switch board you select your initials and login, which opens the data entry page with employee initials at the top of the page. The initials field is bound to the switch board that does not close. This is a 4 person multiuser db and when one person logs off their initials move to another users interface. How can I stop this. I have tried locking the initials field on the interface page but still it appears to happen. One issue I have considered is that two of us that are not having problems are using access 2003 and the two others are using 2000. Are there any other locks that should be applied or change the way we login? I am stummped |
#8
|
|||
|
|||
I need to keep employee initials locked in front end applicati
Just in case you are still reading this thread... (I learn soooooo much
here) apparently, Access 2000 has this bookmark bug that seems to jump when certain events are fired. That might be why only the Access 2000 's are affected. Your most welcome... Gina Whipp "DLMJR757" wrote in message ... Thanks Gina ! "Gina Whipp" wrote: Okay, so the initials in both places are bound to a table. I don't remember why and maybe someone can help with this (hopefully one of those gurus out there) but my LogOn ID is stored in and unbound field on and invisible log-on form and only closes when the user exits. I THINK it has something to do with the tables are all drawing from the back end and being stored in that field when a new user logs on the field in that table changes causes the field on another users station to change. Binding it an unbound text bos that holds the users log-on and does not look at the table to see if any other user has changed those initials by logging on. Hope that makes sense. Gina Whipp "DLMJR757" wrote in message ... The Switch board drop down is bound to the employee table, the initials on the main form are bound to the main table "Gina Whipp" wrote: When they log-on, it is stored in any common table or in an unbound text box on the the Switchboard? And what is the interface page? They way I do it is the frmLogOn which goes invisible after the user logs on and there ID is transferred to the Switchboard after they Log-On, how does yours work exactly? Gina Whipp "DLMJR757" wrote in message news Gina, Each user has their own front end loaded on their own machine, which is what is bafling me "Gina Whipp" wrote: The way it sounds to me, it's as if they are all using the same Switchboard, if they are then you need to need to change that, each should have a front-end loaded on their own machine and that would avoid that problem. HTH, Gina Whipp "DLMJR757" wrote in message ... I have a front to back split db from the switch board you select your initials and login, which opens the data entry page with employee initials at the top of the page. The initials field is bound to the switch board that does not close. This is a 4 person multiuser db and when one person logs off their initials move to another users interface. How can I stop this. I have tried locking the initials field on the interface page but still it appears to happen. One issue I have considered is that two of us that are not having problems are using access 2003 and the two others are using 2000. Are there any other locks that should be applied or change the way we login? I am stummped |
Thread Tools | |
Display Modes | |
|
|