Re: "No objects need to be updated"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <ESheehan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F6825605-0CD2-4B08-93AA-BEC95B7E5868@xxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: OT - Cant we all agree????
    ... The reason is that so many decent, honorable, ... I've observed your thoughtful and measured responses to Powell over ... Jeff is who he is. ... Is he the most important design engineer in the ...
    (rec.music.classical.recordings)
  • Re: Automatically getting a form populated from other data that ha
    ... Jeff Boyce wrote: ... The main form is designed to populate a lot of fields and one of them ... Course Provider. ... the design are already in place and therefore ...
    (microsoft.public.access.gettingstarted)
  • Re: Can you decrypt this?
    ... How will you keep the ministerial mixed packages before Jeff does? ... It can a little design as opposed to violent calm highways. ... Many arbitrary dry projects will most mix the stages. ...
    (sci.crypt)
  • Re: Book on Pre-MATH for cryptography and cryptanalysis.
    ... Will you design by way of the ... wake, if Jeff even quotes the evening? ...
    (sci.crypt)
  • Re: auto-updates
    ... any train of logic that could lead to the overall design of ... alert, I right-click, tell the system to install updates, and go about ... because of your status with Fedora Project... ... the proper thing is to file an RFE in bugzilla. ...
    (Fedora)