Bizzarre behaviour

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

Windows XP
Access 2002

I have a report that prints out the same address in an unbound text box to a
C5 envelope.

If I select the report in the Reports window and then Print, it works fine.
If I use code to do the same thing Access exits without a prompt. The same
thing happens if I try to open the form in design view.
I have full permissions on this database, and I have already tried
recreating the database from new and importing all the elements but still
the problem persists. None of the references are missing.

Any suggestions?

Thanks in advance,

Max


Code:
Dim DocName As String

DocName = "C5WerndaleNat"
DoCmd.OpenReport DocName, acNormal
 
Sounds like a corrupt form.

try making a new form and printing the report from that.

if that works: go back to a previous build of your app, and open a
copy of that 1st form that doesn't crash in design view, then copy all
the controls and code and paste it onto the new form,

hth blm
 
Max said:
Windows XP
Access 2002

I have a report that prints out the same address in an unbound text box to a
C5 envelope.

If I select the report in the Reports window and then Print, it works fine.
If I use code to do the same thing Access exits without a prompt. The same
thing happens if I try to open the form in design view.
I have full permissions on this database, and I have already tried
recreating the database from new and importing all the elements but still
the problem persists. None of the references are missing.

Any suggestions?

Thanks in advance,

Max


Code:
Dim DocName As String

DocName = "C5WerndaleNat"
DoCmd.OpenReport DocName, acNormal
Click to expand...
 
Back
Top