page margin

Sorry, Bob. SaveAsText is an undocumented VBA command.
It creates a text file containing your object (in this case your report.)
You can then import it into another database with LoadFromText.

To use it:
1. Open the Immediate Window (Ctrl+G).

2. Type in the command, and press Enter.


--
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.

"Bob Brannon" wrote in message
...
I must be dense, how do I get to this "SaveAsText acReport"?

When I try Save as from the file menu a window comes up with the "as"
grayed
out but set on report. Would this be because the report asks for some
data
before it runs?


"Allen Browne" wrote in message
...
Regarding references, you cannot remove VBA or Access libraries.
You probably want to keep the DAO one.
The other 2 are usually not needed.
More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If the problem with the huge bottom margin applies to only the one report
(not to a new report, for example), here's another alternative.
1. Open the Immediate Window (Ctrl+G).

2. Enter something like this, replacing Report1 with the name of your
report:
SaveAsText acReport, "Report1", "C:\Report1.txt"

3. Delete the report.

4. Compact the database.

5. Open the Immediate window, and enter:
LoadFromText acReport, "Report1", "C:\Report1.txt"

SaveAsText and LoadFromText are undocumented, but can sometimes recover a
bad object.

--
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.

"Bob Brannon" wrote in message
...
OK, I was able to get to the Code window before then but I do not know
what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process
will
cease at step 5 and see the name of the object that did not import. What
is
the process that will cease? I was able to import the report whose
margin
I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens in
the
code window).

Once you are there, you will find References on the Tools menu.

--
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.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to
was
your step 5 in the web page you reference for recovering from corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database
for
you. I end up using that about once a month with different people's
databases.

--
"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the
margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to
1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText
and
LoadFromText, or follow the steps for the first symptom in this article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

Hello Allen,

The problem was I didn't know what you meant by the "Immediate Window". I
see now it is part of the VB window, which I have rarely used, but had
gotten to it a few days ago already. Sorry for the confusion.

Anyway, I tried what you said and the bottom margin still cannot be
adjusted. Any idea what that problem might be? By now I could have spent
less time just copying my other report and modifying the copy. However,
that would not provide a solution to the problem, just a work around. Now I
am really interested in figuring out the problem.

Any other suggestions?

Regards,
Bob Brannon


"Allen Browne" wrote in message
...
Sorry, Bob. SaveAsText is an undocumented VBA command.
It creates a text file containing your object (in this case your report.)
You can then import it into another database with LoadFromText.

To use it:
1. Open the Immediate Window (Ctrl+G).

2. Type in the command, and press Enter.


--
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.

"Bob Brannon" wrote in message
...
I must be dense, how do I get to this "SaveAsText acReport"?

When I try Save as from the file menu a window comes up with the "as"
grayed
out but set on report. Would this be because the report asks for some
data
before it runs?


"Allen Browne" wrote in message
...
Regarding references, you cannot remove VBA or Access libraries.
You probably want to keep the DAO one.
The other 2 are usually not needed.
More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If the problem with the huge bottom margin applies to only the one report
(not to a new report, for example), here's another alternative.
1. Open the Immediate Window (Ctrl+G).

2. Enter something like this, replacing Report1 with the name of your
report:
SaveAsText acReport, "Report1", "C:\Report1.txt"

3. Delete the report.

4. Compact the database.

5. Open the Immediate window, and enter:
LoadFromText acReport, "Report1", "C:\Report1.txt"

SaveAsText and LoadFromText are undocumented, but can sometimes recover a
bad object.

--
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.

"Bob Brannon" wrote in message
...
OK, I was able to get to the Code window before then but I do not know
what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process
will
cease at step 5 and see the name of the object that did not import. What
is
the process that will cease? I was able to import the report whose
margin
I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens in
the
code window).

Once you are there, you will find References on the Tools menu.

--
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.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to
was
your step 5 in the web page you reference for recovering from corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the database
for
you. I end up using that about once a month with different people's
databases.

--
"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the
margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should work
fine.

If you are able to create another report and set the bottom margin to
1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText
and
LoadFromText, or follow the steps for the first symptom in this article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

Now you have found the Immediate Window, try the SaveAsText and
LoadFromText.

--
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.

"Bob Brannon" wrote in message
...
Hello Allen,

The problem was I didn't know what you meant by the "Immediate Window". I
see now it is part of the VB window, which I have rarely used, but had
gotten to it a few days ago already. Sorry for the confusion.

Anyway, I tried what you said and the bottom margin still cannot be
adjusted. Any idea what that problem might be? By now I could have spent
less time just copying my other report and modifying the copy. However,
that would not provide a solution to the problem, just a work around. Now
I
am really interested in figuring out the problem.

Any other suggestions?

Regards,
Bob Brannon


"Allen Browne" wrote in message
...
Sorry, Bob. SaveAsText is an undocumented VBA command.
It creates a text file containing your object (in this case your report.)
You can then import it into another database with LoadFromText.

To use it:
1. Open the Immediate Window (Ctrl+G).

2. Type in the command, and press Enter.

"Bob Brannon" wrote in message
...
I must be dense, how do I get to this "SaveAsText acReport"?

When I try Save as from the file menu a window comes up with the "as"
grayed
out but set on report. Would this be because the report asks for some
data
before it runs?


"Allen Browne" wrote in message
...
Regarding references, you cannot remove VBA or Access libraries.
You probably want to keep the DAO one.
The other 2 are usually not needed.
More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If the problem with the huge bottom margin applies to only the one report
(not to a new report, for example), here's another alternative.
1. Open the Immediate Window (Ctrl+G).

2. Enter something like this, replacing Report1 with the name of your
report:
SaveAsText acReport, "Report1", "C:\Report1.txt"

3. Delete the report.

4. Compact the database.

5. Open the Immediate window, and enter:
LoadFromText acReport, "Report1", "C:\Report1.txt"

SaveAsText and LoadFromText are undocumented, but can sometimes recover a
bad object.

--
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.

"Bob Brannon" wrote in message
...
OK, I was able to get to the Code window before then but I do not know
what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process
will
cease at step 5 and see the name of the object that did not import.
What
is
the process that will cease? I was able to import the report whose
margin
I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens in
the
code window).

Once you are there, you will find References on the Tools menu.

--
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.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to
was
your step 5 in the web page you reference for recovering from
corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the
database
for
you. I end up using that about once a month with different people's
databases.

--
"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the
margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should
work
fine.

If you are able to create another report and set the bottom margin to
1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText
and
LoadFromText, or follow the steps for the first symptom in this
article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts
back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

Guess we are not communicating here somehow. I did do the SaveAs and
LoadFrom and still cannot adjust the margin in the new report. So where do
we go from here. Please see my last message.


"Allen Browne" wrote in message
...
Now you have found the Immediate Window, try the SaveAsText and
LoadFromText.

--
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.

"Bob Brannon" wrote in message
...
Hello Allen,

The problem was I didn't know what you meant by the "Immediate Window". I
see now it is part of the VB window, which I have rarely used, but had
gotten to it a few days ago already. Sorry for the confusion.

Anyway, I tried what you said and the bottom margin still cannot be
adjusted. Any idea what that problem might be? By now I could have spent
less time just copying my other report and modifying the copy. However,
that would not provide a solution to the problem, just a work around. Now
I
am really interested in figuring out the problem.

Any other suggestions?

Regards,
Bob Brannon


"Allen Browne" wrote in message
...
Sorry, Bob. SaveAsText is an undocumented VBA command.
It creates a text file containing your object (in this case your report.)
You can then import it into another database with LoadFromText.

To use it:
1. Open the Immediate Window (Ctrl+G).

2. Type in the command, and press Enter.

"Bob Brannon" wrote in message
...
I must be dense, how do I get to this "SaveAsText acReport"?

When I try Save as from the file menu a window comes up with the "as"
grayed
out but set on report. Would this be because the report asks for some
data
before it runs?


"Allen Browne" wrote in message
...
Regarding references, you cannot remove VBA or Access libraries.
You probably want to keep the DAO one.
The other 2 are usually not needed.
More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If the problem with the huge bottom margin applies to only the one report
(not to a new report, for example), here's another alternative.
1. Open the Immediate Window (Ctrl+G).

2. Enter something like this, replacing Report1 with the name of your
report:
SaveAsText acReport, "Report1", "C:\Report1.txt"

3. Delete the report.

4. Compact the database.

5. Open the Immediate window, and enter:
LoadFromText acReport, "Report1", "C:\Report1.txt"

SaveAsText and LoadFromText are undocumented, but can sometimes recover a
bad object.

--
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.

"Bob Brannon" wrote in message
...
OK, I was able to get to the Code window before then but I do not know
what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process
will
cease at step 5 and see the name of the object that did not import.
What
is
the process that will cease? I was able to import the report whose
margin
I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens in
the
code window).

Once you are there, you will find References on the Tools menu.

--
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.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to
was
your step 5 in the web page you reference for recovering from
corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste (ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the
database
for
you. I end up using that about once a month with different people's
databases.

--
"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the
margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should
work
fine.

If you are able to create another report and set the bottom margin to
1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText
and
LoadFromText, or follow the steps for the first symptom in this
article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts
back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

Ah, thanks for the clarification, Bob.

Re-reading the thread, you are sure that this problem does not occur with
other reports. For example, you are able to save a new report with a 1"
bottom margin. That proves that this is not something being enforced by the
printer driver itself. (It is still possible that the printer driver is
faulty, but I've never seen these symptoms from that cause.)

We have also tried to eliminate a corruption in the database as a cause, but
ensuring Name AutoCorrect is off, decompiling, exporting the report,
deleting it, and reimporting. That process should have shown up a problem if
the mdb was corrupt.

It's interesting that it sets the value to 2.5 when you type a 1, and that
this is the conversion factor between cm and inches. I wonder if there is
any chance that the Regional Settings for the computer are incorrect or
corrupted? It's a long shot, but you might like to open the Windows Control
Panel, and change the Regional Settings to something else. Then change it
back, and try opening Access again.

I'm not sure what else to suggest.

--
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.

"Bob Brannon" wrote in message
...
Guess we are not communicating here somehow. I did do the SaveAs and
LoadFrom and still cannot adjust the margin in the new report. So where
do
we go from here. Please see my last message.


"Allen Browne" wrote in message
...
Now you have found the Immediate Window, try the SaveAsText and
LoadFromText.

"Bob Brannon" wrote in message
...
Hello Allen,

The problem was I didn't know what you meant by the "Immediate Window".
I
see now it is part of the VB window, which I have rarely used, but had
gotten to it a few days ago already. Sorry for the confusion.

Anyway, I tried what you said and the bottom margin still cannot be
adjusted. Any idea what that problem might be? By now I could have
spent
less time just copying my other report and modifying the copy. However,
that would not provide a solution to the problem, just a work around.
Now
I
am really interested in figuring out the problem.

Any other suggestions?

Regards,
Bob Brannon


"Allen Browne" wrote in message
...
Sorry, Bob. SaveAsText is an undocumented VBA command.
It creates a text file containing your object (in this case your report.)
You can then import it into another database with LoadFromText.

To use it:
1. Open the Immediate Window (Ctrl+G).

2. Type in the command, and press Enter.

"Bob Brannon" wrote in message
...
I must be dense, how do I get to this "SaveAsText acReport"?

When I try Save as from the file menu a window comes up with the "as"
grayed
out but set on report. Would this be because the report asks for some
data
before it runs?


"Allen Browne" wrote in message
...
Regarding references, you cannot remove VBA or Access libraries.
You probably want to keep the DAO one.
The other 2 are usually not needed.
More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If the problem with the huge bottom margin applies to only the one
report
(not to a new report, for example), here's another alternative.
1. Open the Immediate Window (Ctrl+G).

2. Enter something like this, replacing Report1 with the name of your
report:
SaveAsText acReport, "Report1", "C:\Report1.txt"

3. Delete the report.

4. Compact the database.

5. Open the Immediate window, and enter:
LoadFromText acReport, "Report1", "C:\Report1.txt"

SaveAsText and LoadFromText are undocumented, but can sometimes recover
a
bad object.

--
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.

"Bob Brannon" wrote in message
...
OK, I was able to get to the Code window before then but I do not know
what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process
will
cease at step 5 and see the name of the object that did not import.
What
is
the process that will cease? I was able to import the report whose
margin
I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens
in
the
code window).

Once you are there, you will find References on the Tools menu.

--
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.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to
was
your step 5 in the web page you reference for recovering from
corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report
will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste
(ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the
database
for
you. I end up using that about once a month with different people's
databases.

--
"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the
margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make
the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should
work
fine.

If you are able to create another report and set the bottom margin to
1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText
and
LoadFromText, or follow the steps for the first symptom in this
article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the
bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts
back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

That didn't work either, unfortunately. Any other ideas or suggestions
where to go to figure it out? Seems most of the problems I find with any
software, there is no resolution for them.

"Allen Browne" wrote in message
...
Ah, thanks for the clarification, Bob.

Re-reading the thread, you are sure that this problem does not occur with
other reports. For example, you are able to save a new report with a 1"
bottom margin. That proves that this is not something being enforced by the
printer driver itself. (It is still possible that the printer driver is
faulty, but I've never seen these symptoms from that cause.)

We have also tried to eliminate a corruption in the database as a cause, but
ensuring Name AutoCorrect is off, decompiling, exporting the report,
deleting it, and reimporting. That process should have shown up a problem if
the mdb was corrupt.

It's interesting that it sets the value to 2.5 when you type a 1, and that
this is the conversion factor between cm and inches. I wonder if there is
any chance that the Regional Settings for the computer are incorrect or
corrupted? It's a long shot, but you might like to open the Windows Control
Panel, and change the Regional Settings to something else. Then change it
back, and try opening Access again.

I'm not sure what else to suggest.

--
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.

"Bob Brannon" wrote in message
...
Guess we are not communicating here somehow. I did do the SaveAs and
LoadFrom and still cannot adjust the margin in the new report. So where
do
we go from here. Please see my last message.


"Allen Browne" wrote in message
...
Now you have found the Immediate Window, try the SaveAsText and
LoadFromText.

"Bob Brannon" wrote in message
...
Hello Allen,

The problem was I didn't know what you meant by the "Immediate Window".
I
see now it is part of the VB window, which I have rarely used, but had
gotten to it a few days ago already. Sorry for the confusion.

Anyway, I tried what you said and the bottom margin still cannot be
adjusted. Any idea what that problem might be? By now I could have
spent
less time just copying my other report and modifying the copy. However,
that would not provide a solution to the problem, just a work around.
Now
I
am really interested in figuring out the problem.

Any other suggestions?

Regards,
Bob Brannon


"Allen Browne" wrote in message
...
Sorry, Bob. SaveAsText is an undocumented VBA command.
It creates a text file containing your object (in this case your report.)
You can then import it into another database with LoadFromText.

To use it:
1. Open the Immediate Window (Ctrl+G).

2. Type in the command, and press Enter.

"Bob Brannon" wrote in message
...
I must be dense, how do I get to this "SaveAsText acReport"?

When I try Save as from the file menu a window comes up with the "as"
grayed
out but set on report. Would this be because the report asks for some
data
before it runs?


"Allen Browne" wrote in message
...
Regarding references, you cannot remove VBA or Access libraries.
You probably want to keep the DAO one.
The other 2 are usually not needed.
More info about references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

If the problem with the huge bottom margin applies to only the one
report
(not to a new report, for example), here's another alternative.
1. Open the Immediate Window (Ctrl+G).

2. Enter something like this, replacing Report1 with the name of your
report:
SaveAsText acReport, "Report1", "C:\Report1.txt"

3. Delete the report.

4. Compact the database.

5. Open the Immediate window, and enter:
LoadFromText acReport, "Report1", "C:\Report1.txt"

SaveAsText and LoadFromText are undocumented, but can sometimes recover
a
bad object.

--
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.

"Bob Brannon" wrote in message
...
OK, I was able to get to the Code window before then but I do not know
what
you mean by setting minimal references. The only ones checked a

VB for apps
Access 9 obj lib
DAO 3.6 obj lib
OLE auto.
VB for apps extensibility 5.3

Should I uncheck all these?

And, on you web page for recovering from corruption you say the process
will
cease at step 5 and see the name of the object that did not import.
What
is
the process that will cease? I was able to import the report whose
margin
I
cannot reset but I can't reset it in the new database either.


"Allen Browne" wrote in message
...
Press Alt+F11 to open the code window.
Alternatively, press Ctrl+G to open the Immediate window (which opens
in
the
code window).

Once you are there, you will find References on the Tools menu.

--
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.
"Bob Brannon" wrote in message
...
Sorry for the confusion if I caused any, the step 5 I was referring to
was
your step 5 in the web page you reference for recovering from
corruption
with a form or report that won't open.

I'm not sure how to get to the code window, but if I have I don't know
what
you mean by "setting minimal references" or how the corrupt report
will
show
up.


"Bob Brannon" wrote in message
...
How do you do step 5 that you referred to in your earlier response. I
don't
know how to get to that code window you referenced.

"Allen Browne" wrote in message
...
If you have another report you could use, just:
1. Delete the report.
2. Compact.
3. In the Database window, copy the report (ctrl+C) and paste
(ctrl+V).
4. Open the copy in design view, and change the RecordSource.

It's worth persuing the process that gets Access to rebuild the
database
for
you. I end up using that about once a month with different people's
databases.

--
"Bob Brannon" wrote in message
...
All the name autocorrect options are already turned off. However, I
compacted, copied, pasted, renamed adn still could not change the
margin
of
the copy.

I have another report that is exactly the same but uses a different
cirteria
for the data reported, so I could probably just copy that and make
the
changes.

I am not sure how to follow your recover from corruption process.


"Allen Browne" wrote in message
...
All printers have an unprintable area at the bottom, but 1" should
work
fine.

If you are able to create another report and set the bottom margin to
1",
then the report is corrupt, and the likely cause is Name AutoCorrect.
Details:
Failures caused by Name Auto-Correct
at:
http://members.iinet.net.au/~allenbrowne/bug-03.html

After turning off the Name AutoCorrect options, compact the database.
Then
select the report in the Database window, copy (Ctrl+C), and paste
(Ctrl+V),
supplying a new name for the copy of the report. Can you change the
margin
of the copy?

If you're still stuck at this point, try the undocumented SaveAsText
and
LoadFromText, or follow the steps for the first symptom in this
article
to
get Access to reconstruct if for you:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html


"Bob Brannon" wrote in message
...
Hello,

I am using Access 2000 on XP Home SP2.

For the life of me I cannot figure out why I cannot change the
bottom
margin
of a report in page setup from 2.5" to 1". When I try it reverts
back
to
2.5.

The report is designed exactly the same as another report that uses
different a different criteria in the query. That report has not
trouble
with the bottom margin being 1". Any suggestions?

Regards,
Bob Brannon

Don't know what else to suggest, Bob.

--
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.

"Bob Brannon" wrote in message
...
That didn't work either, unfortunately. Any other ideas or suggestions

Any interest in looking at the Database and report to see if you can figure
it out?


"Allen Browne" wrote in message
...
Don't know what else to suggest, Bob.

--
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.

"Bob Brannon" wrote in message
...
That didn't work either, unfortunately. Any other ideas or suggestions

Hi Bob

Hope you can understand that we cannot open everyone's databases for free,
or we would never get any paid work done.

Email me directly if you want to follow up further.

--
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.

"Bob Brannon" wrote in message
...
Any interest in looking at the Database and report to see if you can
figure
it out?


"Allen Browne" wrote in message
...
Don't know what else to suggest, Bob.


"Bob Brannon" wrote in message
...
That didn't work either, unfortunately. Any other ideas or suggestions