Link to home
Start Free TrialLog in
Avatar of urjudo
urjudoFlag for United States of America

asked on

Can not find the object '|1' error message in Access database

Hello Experts,
I'm trying to export a form to PDF and got an error message "Can bot find the object '|1'.  What does that mean?  The report I tried to export is get data from 10 tables, is because that?
 here is my code:
DoCmd.OutputTo acOutputReport, Me.OrderNumber & "-" & rptOrder", acFormatPDF, OutputFile

Open in new window

Thanks,
ASKER CERTIFIED SOLUTION
Avatar of Frédéric Métraux
Frédéric Métraux
Flag of Switzerland 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
Avatar of urjudo

ASKER

I just tried it, it still showing the same error message.  I used the same code in another form, it works on the other form but don't know why it have this error message on this report.  If I remove the OrderNumber then it works but I need the order number to identify each order
SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
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
Avatar of urjudo

ASKER

@Jim,
I checked everything.  I took it back what I mention before, I just realized it didn't work on the other form either.  Is any other way to export reports to pdf with modified report name?
SOLUTION
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
SOLUTION
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
Avatar of urjudo

ASKER

Thanks all experts helped!