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
|
|||
|
|||
Data Entry Issues With Form and Bound Fields (tabs)...
Hey everyone,
I am about to go crazy. I am setting up a CRM system and thought it was a pretty cut and dry project. Here is the db layout. I have set up relationships between a master client table and several detail tables (invoices, contacts, communications, etc.). I have a form that has about 8 tabs with the details broken out on each. 5 of the tabs have one subform on each, while the remaining 3 have two subforms all of which are bound directly to tables. Subform A is a datasheet while Subform B is simple form which lists further details from A. When users click on a row in A it displays details in B. It does so by using a hidden text box with A's rowsource ID field. Then B looks at it for it's master. Hopefully that makes a little sense.... Anyway - the issue now is that it works great until you try to update fields in B and then it goes haywire. If you don't type fast enough the field highlights and you wind up typing over what you've entered. Additionally, if you just leave the cursor somewhere over the subform it's blinking back and forth between the hour glass and the cursor. I mean I haven't created any VB procedures other than some defaults that Access created. Seriously - your ideas would be so appreciated. - Aaron P.S. If I delete the tab and recreate it the problem does not replicate on the new tab until an additional tab is created. Then the new one works and the one that was just created works no longer. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#2
|
|||
|
|||
Data Entry Issues With Form and Bound Fields (tabs)...
I am aware that you wrote that you don't have code but have you set the
Form_Timer Event (running a Macro) anywhere in your database? -- HTH Van T. Dinh MVP (Access) "ABAX via AccessMonster.com" u23056@uwe wrote in message news:690b5679532b3@uwe... Hey everyone, I am about to go crazy. I am setting up a CRM system and thought it was a pretty cut and dry project. Here is the db layout. I have set up relationships between a master client table and several detail tables (invoices, contacts, communications, etc.). I have a form that has about 8 tabs with the details broken out on each. 5 of the tabs have one subform on each, while the remaining 3 have two subforms all of which are bound directly to tables. Subform A is a datasheet while Subform B is simple form which lists further details from A. When users click on a row in A it displays details in B. It does so by using a hidden text box with A's rowsource ID field. Then B looks at it for it's master. Hopefully that makes a little sense.... Anyway - the issue now is that it works great until you try to update fields in B and then it goes haywire. If you don't type fast enough the field highlights and you wind up typing over what you've entered. Additionally, if you just leave the cursor somewhere over the subform it's blinking back and forth between the hour glass and the cursor. I mean I haven't created any VB procedures other than some defaults that Access created. Seriously - your ideas would be so appreciated. - Aaron P.S. If I delete the tab and recreate it the problem does not replicate on the new tab until an additional tab is created. Then the new one works and the one that was just created works no longer. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#3
|
|||
|
|||
Data Entry Issues With Form and Bound Fields (tabs)...
Van T. Dinh wrote:
I am aware that you wrote that you don't have code but have you set the Form_Timer Event (running a Macro) anywhere in your database? Hey everyone, [quoted text clipped - 33 lines] and the one that was just created works no longer. Van - thanks for responding. I have gone over the entire db and there is nothing that is on timer. I would be willing to shoot you the db so you could see it. Honestly - I have never seen anything like this. It's in A2K3 but would convert to lower versions. Thanks again for you help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#4
|
|||
|
|||
Data Entry Issues With Form and Bound Fields (tabs)...
Repair & Compact the DB then zip it then send to:
vanthiendinhATaccessmvp.com Can't promise I will have time to look at the database quickly though ... -- HTH Van T. Dinh MVP (Access) "ABAX via AccessMonster.com" u23056@uwe wrote in message news:6915e32ce8e4d@uwe... Van T. Dinh wrote: I am aware that you wrote that you don't have code but have you set the Form_Timer Event (running a Macro) anywhere in your database? Hey everyone, [quoted text clipped - 33 lines] and the one that was just created works no longer. Van - thanks for responding. I have gone over the entire db and there is nothing that is on timer. I would be willing to shoot you the db so you could see it. Honestly - I have never seen anything like this. It's in A2K3 but would convert to lower versions. Thanks again for you help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#5
|
|||
|
|||
Data Entry Issues With Form and Bound Fields (tabs)...
You may want to check Allen Browne's article:
http://www.allenbrowne.com/ser-46.html also. -- HTH Van T. Dinh MVP (Access) "ABAX via AccessMonster.com" u23056@uwe wrote in message news:6915e32ce8e4d@uwe... Van - thanks for responding. I have gone over the entire db and there is nothing that is on timer. I would be willing to shoot you the db so you could see it. Honestly - I have never seen anything like this. It's in A2K3 but would convert to lower versions. Thanks again for you help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
Thread Tools | |
Display Modes | |
|
|