Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Multiuser / Networking / March 2006

Tip: Looking for answers? Try searching our database.

multiuser database freezing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rohan - 08 Mar 2006 01:39 GMT
I have a database with both the front end and the back end on the network.
(yes I know this is a bad
idea).  The current problem is that sometimes when the user is working, the
hourglass appears out
of nowhere, and then, the current field she is in (a memo text field) is
highlighted - so that if she is
not looking out for it, it may get totally overwritten with her next
keystroke.

Has anyone come across this before - is there a fix ?

Rohan.
Jesper F - 08 Mar 2006 14:05 GMT
>I have a database with both the front end and the back end on the network.
> (yes I know this is a bad
[quoted text clipped - 7 lines]
>
> Has anyone come across this before - is there a fix ?

It sounds like a flaky network connection. That could mean trouble by
itself.
To avoid the thing with the selected text - how about sending the cursor to
the end of the memofield when the field get the focus?
That way no text will be selected and subsequently won't be deleted a key is
pressed?
Check the help file for SelLength to place the cursor at then end.

Jesper Fjølner
Rohan - 08 Mar 2006 23:26 GMT
>It sounds like a flaky network connection. That could mean trouble by
>itself.

Darn it - I was hoping it was some sort of autosave problem.

>To avoid the thing with the selected text - how about sending the cursor to
>the end of the memofield when the field get the focus?
>That way no text will be selected and subsequently won't be deleted a key is
>pressed?
>Check the help file for SelLength to place the cursor at then end.

Cheers - but unfortunately it happens when she is typing at the end of the
text - it just stops then selects the whole text by itself.

Rohan
Jesper F - 09 Mar 2006 00:40 GMT
>>It sounds like a flaky network connection. That could mean trouble by
>>itself.
>
> Darn it - I was hoping it was some sort of autosave problem.

Well I really don't know what it is I must say.

>>To avoid the thing with the selected text - how about sending the cursor
>>to
[quoted text clipped - 6 lines]
> Cheers - but unfortunately it happens when she is typing at the end of the
> text - it just stops then selects the whole text by itself.

Sounds strange. I won't be much help here I'm afraid.

Jesper Fjølner
HKComputer - 12 Mar 2006 20:28 GMT
Using the SelLength method may still fix your problem.  You will need to
experiment to find out which event is getting fired that selects the text.  I
might suggest it is the enter event or the got focus event.  By default the
text will be selected when a textbox gets focus but if you reset the cursor
position on the gotfocus event you can change this.  I suspect that something
in your network, desktop, or application removes focus from the current
object but gives it back (or your text box gets focus just from the user
typing in it) so the SelLength method should still apply.
Rohan - 13 Mar 2006 00:35 GMT
>Using the SelLength method may still fix your problem.  You will need to
>experiment to find out which event is getting fired that selects the text.  I
[quoted text clipped - 4 lines]
>object but gives it back (or your text box gets focus just from the user
>typing in it) so the SelLength method should still apply.

Ok - thank you.  Will try.

Rohan.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.