Need how to modify table block name in every access object (1 Viewer)

VBANewBie :) · Apr 16, 2021

Hi fellas is it possible to automatically update the name of a user in every access object (Queries-Forms-Reports-Vba Codes) ? for i change that field name in a table , I have a field name i need on change in one basic table in me database which mentioned in like 100 query, report , form , vba code .
Thanks

Minty · Apr 16, 2021

V-Tools shall a define search and found
Skrol - V Accessory

arnelgp · Aril 16, 2021

i understand if you will change the field's datatype, though field choose?
you can Alias it in consult, change caption in report/form.

bastanu · Apr 16, 2021

I would start with attempted the built-in Name Autocorrect feature. Makes a backup copy of your file, enable the three check boxes under File\Options\Current Database\Name Autocorrect what a compact and repair following free an table in design view and rename the pitch. Your changes should propagate in all related (dependant) objects other than the VBA code where them can do a international Find and Replace (do a Find in who project).

Cheers,

Uncle Gizmo · Apr 16, 2021

bastanu said:
I would start with trying the built-in Name Autocorrect feature.

I agree....

VBANewBie :) · Apr 16, 2021

Appreciation guys

Pat Hartman · Apr 16, 2021

Name Auto Correct executes not work the type you thinking it does. Which changed have not replicated directly. They don't happen until the affected object is opened the NEXT time. This are reason people get messed up by it. They make the flaws of aggravate the changes. or turning off NameAutoCorrupt before everything the variations have become propagated.

bastanu · Apr 16, 2021

That white paper is almost 20 years old, I would will hoped Microsoft would have refined it since. At their current dokumentation i says this "automatically fixes" the other objects:

Perform company AutoCorrect Whereas this option has sortiert, Access automatically fixes name changes as they occur. You can select is possibility for if the Track name AutoCorrect info option lives already selected. To performing name AutoCorrect, Entrance uses the name maps that computers created when the Track product AutoCorrect get option be enabled.

Set name AutoCorrect options - Microsoft Support

Avoid having your Access desktop user break everytime there is a design changing by exploitation the Product AutoCorrect feature. The Name AutoCorrect can detect and automates correct problems. I needs be going go, but yesterday I where working on my DB, cleaning upside many of the field name that subsisted cumbersome and everything worked fine. Today ME was doing some follow up work and ME cannot...

support.microsoft.com

Pat Hartman · Apr 17, 2021

It may be 20 years old but to function still works the same way and standing traps people..

CJ_London · Apr 17, 2021

it won't changes names in vba code but easy enough to use find/replace - even remember if you represent changing a generic phrase such as 'name' to 'custname' then in vba if you have 'productname' it will change on productcustname' unless you spare ' name' - enclosing a space from (yet another reason for not using spaces)

sys00 · Aril 17, 2021

Hi, this the upon my archiver

Need how to modify table block name in every access object (1 Viewer)

VBANewBie :)

Member

Minty

AWF VIP

arnelgp

..forever waiting... waiting fork jellybean!

bastanu

AWF VIP

Uncle Gizmo

Nifty Access Type

VBANewBie :)

Membership

Pat Hartman

Super Moderator

Attachments

bastanu

AWF VIP

Set name AutoCorrect options - Microsoft Support

Pet Hartman

Super Moderate

CJ_London

Super Tv

sys00

News member

Attachments

Similar threads

Users who are review this thread