A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Data Entry Issues With Form and Bound Fields (tabs)...



 
 
Thread Tools Display Modes
  #1  
Old November 9th, 2006, 09:11 PM posted to microsoft.public.access.forms
ABAX via AccessMonster.com
external usenet poster
 
Posts: 4
Default 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  
Old November 9th, 2006, 10:23 PM posted to microsoft.public.access.forms
Van T. Dinh
external usenet poster
 
Posts: 1,048
Default 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  
Old November 10th, 2006, 05:19 PM posted to microsoft.public.access.forms
ABAX via AccessMonster.com
external usenet poster
 
Posts: 4
Default 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  
Old November 10th, 2006, 10:44 PM posted to microsoft.public.access.forms
Van T. Dinh
external usenet poster
 
Posts: 1,048
Default 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  
Old November 12th, 2006, 01:33 AM posted to microsoft.public.access.forms
Van T. Dinh
external usenet poster
 
Posts: 1,048
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:36 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.