Link to home
Start Free TrialLog in
Avatar of J.R. Sitman
J.R. SitmanFlag for United States of America

asked on

Microsoft Access changes made to the accdb are not in the accde

I made a change in the accdb to turn off all autocorrect settings.  When I distribute the accde, the autocorrect is turned back on.  I do not want to have to make changes to every copy.
Avatar of Eric Flamm
Eric Flamm
Flag of United States of America image

Did you close and reopen the ACCDB before saving as ACCDE? If you don't close it first, the track options setting reverts to checked when you save as ACCDE.
Avatar of J.R. Sitman

ASKER

I just did as you suggest.  When I open the accde the options are all off.  When I copy the accde to another computer they are back on.
OK. How about this: add (or modify) your AutoExec macro (in the ACCDB) to include:
Application.SetOption "Track name AutoCorrect info", False

Open in new window

Then close and reopen the accdb (might not be necessary for a VBA change) and save as accde. Of course, if you don't have an autoexec, you'll have to create one in order to invoke the code (or add it to the load handler of your startup form).
I have a programmer (Miriam Bizup) that will have to do this for me.
Miriam said the code you provided is for the Developer changing table names, queries, etc.  What I wanted was to turn off Autocorrect for the "users"
You can disable auto-expand for individual controls (like combo boxes) by setting Auto Expand (on the Data tab) to No. This could be done manually for every control, or your programmer could probably write a short program to loop through every control on a page, see if it has Auto Expand, and turn it off.

Of course, Auto Expand is on by default because it's useful (most of the time). Assuming you want to just shut it off on a few controls, you can do that manually in design view.
What is AutoExpand?     I am referring to AutoCorrect
ASKER CERTIFIED SOLUTION
Avatar of Eric Flamm
Eric Flamm
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you.  The last post was very helpful