UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Bound Controls Not Updating Field In Table Immediately Waits Till Form Closed, Access 2007    
 
   
Lateral
post Jan 13 2018, 09:33 PM
Post#1



Posts: 184
Joined: 29-November 13



Hi guys,

I've just stumbled on this issue.

I have a FE / BE Access 2007 environment and am adding some additional fields to a number of tables and modified some existing forms to add the controls (text box, Check Box etc) so that I can update these new fields easily.

During my testing I do the following:

1. Change the value of a textbox called [Master/Slave] to "Slave". This control is bound to a field called [MasterSlave]
2. Without closing the form, I view the record in the table and the field, [MasterSlave] has not been set to "Slave"
3. If I close the form, the field is then updated.....

What am I not understanding here?

Cheers and thanks for your help.

Regards
Greg
This post has been edited by Lateral: Jan 13 2018, 09:33 PM
Go to the top of the page
 
moke123
post Jan 13 2018, 09:40 PM
Post#2



Posts: 1,279
Joined: 26-December 12
From: Western Ma.,L.I.,N.Y.,Jupiter,Fl.



That is normal behavior. A record doesnt get committed until you close the form, the form loses focus, or you specifically force a save.
Go to the top of the page
 
Lateral
post Jan 13 2018, 10:56 PM
Post#3



Posts: 184
Joined: 29-November 13



Thanks for clarifying that for me as it was doing my head in!
Go to the top of the page
 
missinglinq
post Jan 13 2018, 11:28 PM
Post#4



Posts: 4,496
Joined: 11-November 02



I think moke123 meant until the Record loses Focus, i.e. you move to another Record.

Linq ;0)>

--------------------
Hope this helps!

The problem with making anything foolproof...is that fools are so darn ingenious!

All posts/responses based on Access 2003/2007
Go to the top of the page
 
projecttoday
post Jan 14 2018, 12:15 AM
Post#5


UtterAccess VIP
Posts: 9,709
Joined: 10-February 04
From: South Charleston, WV


So from that we can conclude that if you open a bound form, navigate to an existing record, change some of the values, and then turn off the computer (without moving off the record), the changes would NOT be saved.

--------------------
Robert Crouser

My company's website
Go to the top of the page
 
moke123
post Jan 14 2018, 05:54 AM
Post#6



Posts: 1,279
Joined: 26-December 12
From: Western Ma.,L.I.,N.Y.,Jupiter,Fl.



QUOTE
I think moke123 meant until the Record loses Focus, i.e. you move to another Record.

yes thats the process that was in my head, just not in my words.
Go to the top of the page
 
projecttoday
post Jan 14 2018, 08:04 AM
Post#7


UtterAccess VIP
Posts: 9,709
Joined: 10-February 04
From: South Charleston, WV


So, moke, will you confirm or deny my previous post? (Too lazy to test it.)

--------------------
Robert Crouser

My company's website
Go to the top of the page
 
GroverParkGeorge
post Jan 14 2018, 08:07 AM
Post#8


UA Admin
Posts: 32,846
Joined: 20-June 02
From: Newcastle, WA


"...and then turn off the computer (without moving off the record) ..." And probably not a good idea to turn off a computer with a record not saved, in any case, right?

--------------------
Go to the top of the page
 
moke123
post Jan 14 2018, 12:47 PM
Post#9



Posts: 1,279
Joined: 26-December 12
From: Western Ma.,L.I.,N.Y.,Jupiter,Fl.



tested.
Apparently when you alter an existing record and power down without leaving the form the record is in fact saved.
If you do a hard reboot under the same circumstances the record changes are not saved.
I would render a guess that when windows is shutting down and closing programs it is closing access, and in doing so the form, and committing the record. Same as if you Close access without leaving the form.
Go to the top of the page
 
projecttoday
post Jan 14 2018, 01:21 PM
Post#10


UtterAccess VIP
Posts: 9,709
Joined: 10-February 04
From: South Charleston, WV


Pardon my ignorance but will you clarify the difference between "power down" and "hard reboot".

I was always thought the change would be saved once typed no matter what on a bound form.

--------------------
Robert Crouser

My company's website
Go to the top of the page
 
moke123
post Jan 14 2018, 01:55 PM
Post#11



Posts: 1,279
Joined: 26-December 12
From: Western Ma.,L.I.,N.Y.,Jupiter,Fl.



power down through the operating system from the start menu.
Hard reboot by holding the power button down.

QUOTE
I was always thought the change would be saved once typed no matter what on a bound form.

re-read the original question and perhaps test it.
Change a value in form and then open table without closing form or navigating to a different record. the change has not yet been committed to the table.
Go to the top of the page
 
projecttoday
post Jan 14 2018, 06:33 PM
Post#12


UtterAccess VIP
Posts: 9,709
Joined: 10-February 04
From: South Charleston, WV


Noted. wink.gif

--------------------
Robert Crouser

My company's website
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    25th June 2018 - 12:27 PM