Setting Global Options

[TarrynG]

Hi

How do I go about setting the name autocorrect options on the launch of my
DB? I am using:

Application.SetOption "Track name Autocorrect Info", False
Application.SetOption "Perform name AutoCorrect", False
Application.SetOption "Log name AutoCorrect changes", False

However, I don't quite know where to place them. I have tried in the Open
Event of my splash form but that doesn't seem to be effective.

The reason for wanting to do this is that I have built a basic DB for
someone using Access 2000 and the report formatting is not holding, I suspect
due to the 'name autocorrect bug'. I would just like to turn this off without
having to have them do it manually.

Any thoughts/suggestions welcomed.

Tarryn

 

[Klatuu]

Before you do this, You would be well advised to visit this site:
http://allenbrowne.com/bug-03.html

 

[TarrynG]

Hi - thanks for the link.

Are you suggesting I need to start with a fresh DB, turn off the settings
and then import my existing tables/form/modules etc? If so, how do I make
this all work so that the person using the DB (who is in London while I'm in
Cape Town) can simply open up a corrected application?

Thanks,
Tarryn

 

[Klatuu]

I would not start with that. I would just turn off Autocorrect and test the
application. If that fixes it, either have your people in London change it
or if you don't want them messing with it, send them a corrected copy.

 

[TarrynG]

Thanks for your responses Klatuu.

I do have Autocorrect turned off and I don't experience any problems with
the report formatting. These only started occuring when they saved and opened
the DB. If I have it turned off - could there be a reason why it comes on
again when they save and open . . . or could there be some other problem
happening here?

Tarryn

 

[Klatuu]

When you say the report format is not holding, what do you mean? Can you be
more specific about the problem you are experiencing?

 

[TarrynG]

Unfortunately I have not actually seen the output . . . however, in the On
Page event of my report I have the following code to generate some of the
design elements required:

Me.ScaleMode = 3

'RED VERTICAL
Me.DrawWidth = 450
sngTop = Me.ScaleTop + 6
sngHeight = Me.ScaleHeight + 5
Me.Line (sngTop, 0)-(0, sngHeight), 225, B

'RED HORIZONTAL
Me.DrawWidth = 350
sngWidth = Me.ScaleWidth - 5000
Me.Line (0, 50)-(sngWidth, 0), 225, B

'GREEN VERTICAL
DrawStyle = 6
Me.DrawWidth = 1100
Me.Line (193, 1890)-(1100, sngHeight + 5), 12241053, B

I also have a light blue block in the page header that runs the width of the
report. This is the feedback I got:

'light blue box in bottom left corner covering some text and the box that
goes across the top stretched onto an extra page making the report and extra
couple of almost blank pages'

Sorry if this is now becoming a question for the Access Report forum rather
than a coding issue.

Help is appreciated.

 

[Klatuu]

I have to admit that now you have gone beyond my capability to help. I
haven't really done a lot of sophisticated report formatting. I think
reposting with the info in this post to the reports section would be a good
idea.

Good Luck.