 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / June 2005Dlookup in report Outputname string
I am trying to export a report with a dlookup in the outputname string. strOutputName = "\\L:\Daily Reports\Brokerage Comb Report " & DLookup("[End Date]", "Daily Criteria") & ".rtf" The following error message appears when the report is exported: Microsoft Office Access can't save the output data to the file you've selected. The export works if the dlookup is removed. Any ideas what might be wrong with the code? Thanks, Melanie The date field has / chr in it, and that is a problem for a file name, try this instead strOutputName = "\\L:\Daily Reports\Brokerage Comb Report " & format(DLookup("[End Date]", "Daily Criteria"),"ddmmyyyy") & ".rtf" > I am trying to export a report with a dlookup in the outputname string. > [quoted text clipped - 11 lines] > Thanks, > Melanie Thanks. Worked great! Melanie > The date field has / chr in it, and that is a problem for a file name, try > this instead [quoted text clipped - 17 lines] > > Thanks, > > Melanie |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.