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 » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"No objects need to be updated"



 
 
Thread Tools Display Modes
  #1  
Old March 15th, 2008, 08:06 PM posted to microsoft.public.access.tablesdbdesign
ESheehan
external usenet poster
 
Posts: 15
Default "No objects need to be updated"

I just updated a fields property by increasing the size of a column. I then
received the update icon and selected the affirmative (update objects) but I
received a message saying no objects needed to be udpated. I know this field
is included in a form. Why is the update function not recognizing the form
that contains this variable?
  #2  
Old March 16th, 2008, 02:33 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default "No objects need to be updated"

If you change the size of a field (e.g. from 50 to 255 characters), no
changes are actually needed in the forms/reports/queries. They just work,
based on the change in the table.

I've not always found this feature (first introduced in A2003) to be useful;
I don't know if that's because I always run with Name AutoCorrect turned
off, and so the data dependency stuff is not available.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ESheehan" wrote in message
...
I just updated a fields property by increasing the size of a column. I then
received the update icon and selected the affirmative (update objects) but
I
received a message saying no objects needed to be udpated. I know this
field
is included in a form. Why is the update function not recognizing the
form
that contains this variable?


  #3  
Old March 17th, 2008, 09:06 PM posted to microsoft.public.access.tablesdbdesign
ESheehan
external usenet poster
 
Posts: 15
Default "No objects need to be updated"

Thanks, Allen, for your response. As a relatively new user, I suppose I'm
just overly concerned that changes I make to the tables are reflected in my
forms. Is there ever a time when a change to a table won't be updated
elsewhere? For example, if I change the name of a field in a table will that
be reflected in its control on the form? To date, when I've changed a field
name, I've gone to the form and deleted the original control and re-inserted
the updated field/control. Mostly for my own peace of mind, but I do seem to
remember some of the controls not reflecting the new field name.

"Allen Browne" wrote:

If you change the size of a field (e.g. from 50 to 255 characters), no
changes are actually needed in the forms/reports/queries. They just work,
based on the change in the table.

I've not always found this feature (first introduced in A2003) to be useful;
I don't know if that's because I always run with Name AutoCorrect turned
off, and so the data dependency stuff is not available.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ESheehan" wrote in message
...
I just updated a fields property by increasing the size of a column. I then
received the update icon and selected the affirmative (update objects) but
I
received a message saying no objects needed to be udpated. I know this
field
is included in a form. Why is the update function not recognizing the
form
that contains this variable?



  #4  
Old March 17th, 2008, 10:33 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default "No objects need to be updated"

Pardon my intrusion...

It may be because I've worked more with older versions of Access, but I
understood that (at least in the older versions), a change in a table
definition did NOT affect existing forms, only new ones created after the
table change. Perhaps that's now a "feature", but I'd think that it would
require using TrackNameAutoCorrect, which has had some issues of its own.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ESheehan" wrote in message
...
Thanks, Allen, for your response. As a relatively new user, I suppose I'm
just overly concerned that changes I make to the tables are reflected in
my
forms. Is there ever a time when a change to a table won't be updated
elsewhere? For example, if I change the name of a field in a table will
that
be reflected in its control on the form? To date, when I've changed a
field
name, I've gone to the form and deleted the original control and
re-inserted
the updated field/control. Mostly for my own peace of mind, but I do seem
to
remember some of the controls not reflecting the new field name.

"Allen Browne" wrote:

If you change the size of a field (e.g. from 50 to 255 characters), no
changes are actually needed in the forms/reports/queries. They just work,
based on the change in the table.

I've not always found this feature (first introduced in A2003) to be
useful;
I don't know if that's because I always run with Name AutoCorrect turned
off, and so the data dependency stuff is not available.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ESheehan" wrote in message
...
I just updated a fields property by increasing the size of a column. I
then
received the update icon and selected the affirmative (update objects)
but
I
received a message saying no objects needed to be udpated. I know this
field
is included in a form. Why is the update function not recognizing the
form
that contains this variable?





  #5  
Old March 17th, 2008, 10:56 PM posted to microsoft.public.access.tablesdbdesign
ESheehan
external usenet poster
 
Posts: 15
Default "No objects need to be updated"

No intrusion at all. Thanks, Jeff, for your input. Again, I'm a novice to
compared to you guys and it's hard to keep track of some of the things
encountered while using Access. Or, rather, I should do a better job of
tracking concerns and questions such as this.

As I mentioned in my previous post, I didn't think some changes were being
reflected in the form. Hence, my deleting controls and re-inserting them
after I had made changes in the table.

Is there any kind of an "override" in Access 2007 that reflects "OK, I've
just made some changes to this table and they affect my form/report/query. Go
ahead, Access, update everything." Or, is that just wishful thinking?

"Jeff Boyce" wrote:

Pardon my intrusion...

It may be because I've worked more with older versions of Access, but I
understood that (at least in the older versions), a change in a table
definition did NOT affect existing forms, only new ones created after the
table change. Perhaps that's now a "feature", but I'd think that it would
require using TrackNameAutoCorrect, which has had some issues of its own.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ESheehan" wrote in message
...
Thanks, Allen, for your response. As a relatively new user, I suppose I'm
just overly concerned that changes I make to the tables are reflected in
my
forms. Is there ever a time when a change to a table won't be updated
elsewhere? For example, if I change the name of a field in a table will
that
be reflected in its control on the form? To date, when I've changed a
field
name, I've gone to the form and deleted the original control and
re-inserted
the updated field/control. Mostly for my own peace of mind, but I do seem
to
remember some of the controls not reflecting the new field name.

"Allen Browne" wrote:

If you change the size of a field (e.g. from 50 to 255 characters), no
changes are actually needed in the forms/reports/queries. They just work,
based on the change in the table.

I've not always found this feature (first introduced in A2003) to be
useful;
I don't know if that's because I always run with Name AutoCorrect turned
off, and so the data dependency stuff is not available.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ESheehan" wrote in message
...
I just updated a fields property by increasing the size of a column. I
then
received the update icon and selected the affirmative (update objects)
but
I
received a message saying no objects needed to be udpated. I know this
field
is included in a form. Why is the update function not recognizing the
form
that contains this variable?





  #6  
Old March 18th, 2008, 12:56 AM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default "No objects need to be updated"

As I mentioned, the TrackNameAutoCorrect may allow for this, but has had
some issues that could cause problems in other areas.

Since I'm beind the curve on the auto-renaming, you may find that those
(previous) issues have also been resolved.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ESheehan" wrote in message
...
No intrusion at all. Thanks, Jeff, for your input. Again, I'm a novice to
compared to you guys and it's hard to keep track of some of the things
encountered while using Access. Or, rather, I should do a better job of
tracking concerns and questions such as this.

As I mentioned in my previous post, I didn't think some changes were being
reflected in the form. Hence, my deleting controls and re-inserting them
after I had made changes in the table.

Is there any kind of an "override" in Access 2007 that reflects "OK, I've
just made some changes to this table and they affect my form/report/query.
Go
ahead, Access, update everything." Or, is that just wishful thinking?

"Jeff Boyce" wrote:

Pardon my intrusion...

It may be because I've worked more with older versions of Access, but I
understood that (at least in the older versions), a change in a table
definition did NOT affect existing forms, only new ones created after the
table change. Perhaps that's now a "feature", but I'd think that it
would
require using TrackNameAutoCorrect, which has had some issues of its own.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ESheehan" wrote in message
...
Thanks, Allen, for your response. As a relatively new user, I suppose
I'm
just overly concerned that changes I make to the tables are reflected
in
my
forms. Is there ever a time when a change to a table won't be updated
elsewhere? For example, if I change the name of a field in a table
will
that
be reflected in its control on the form? To date, when I've changed a
field
name, I've gone to the form and deleted the original control and
re-inserted
the updated field/control. Mostly for my own peace of mind, but I do
seem
to
remember some of the controls not reflecting the new field name.

"Allen Browne" wrote:

If you change the size of a field (e.g. from 50 to 255 characters),
no
changes are actually needed in the forms/reports/queries. They just
work,
based on the change in the table.

I've not always found this feature (first introduced in A2003) to be
useful;
I don't know if that's because I always run with Name AutoCorrect
turned
off, and so the data dependency stuff is not available.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ESheehan" wrote in message
...
I just updated a fields property by increasing the size of a column.
I
then
received the update icon and selected the affirmative (update
objects)
but
I
received a message saying no objects needed to be udpated. I know
this
field
is included in a form. Why is the update function not recognizing
the
form
that contains this variable?







  #7  
Old March 18th, 2008, 01:13 AM posted to microsoft.public.access.tablesdbdesign
Allen Browne
external usenet poster
 
Posts: 11,706
Default "No objects need to be updated"

As Jeff pointed out, Name AutoCorrect is designed to do this, but it doesn't
work. Has more holes than a swiss cheeze, and causes dozens or other
problems (including crashes):
http://allenbrowne.com/bug-03.html

Some of the other "updates" from design view can be useful. For example,
whatever you enter as the Description of the field in table design, Access
uses for the StatusBarText property in a text box. If you change the
Description later, Access 2003/2007 offers to find the text boxes bound to
this field, and update the StatusBarText for you. That can be useful. (It's
also a little strange: if you change accept the offer, and then cancel the
updates to the table, you end up with your StatusBarText changed, but not
the Description in the table, so they still don't match.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ESheehan" wrote in message
...
No intrusion at all. Thanks, Jeff, for your input. Again, I'm a novice to
compared to you guys and it's hard to keep track of some of the things
encountered while using Access. Or, rather, I should do a better job of
tracking concerns and questions such as this.

As I mentioned in my previous post, I didn't think some changes were being
reflected in the form. Hence, my deleting controls and re-inserting them
after I had made changes in the table.

Is there any kind of an "override" in Access 2007 that reflects "OK, I've
just made some changes to this table and they affect my form/report/query.
Go
ahead, Access, update everything." Or, is that just wishful thinking?

"Jeff Boyce" wrote:

Pardon my intrusion...

It may be because I've worked more with older versions of Access, but I
understood that (at least in the older versions), a change in a table
definition did NOT affect existing forms, only new ones created after the
table change. Perhaps that's now a "feature", but I'd think that it
would
require using TrackNameAutoCorrect, which has had some issues of its own.

Regards

Jeff Boyce
Microsoft Office/Access MVP


 




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 09:26 PM.


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