I'm trying to have a perl app print an access report based on a set of queries it just ran. The result set of all those queries is in a table. I just need to change the standardized report's recordsource to be the table I just created. I can make it print the report, so I know its opening correctly and creating the ole object correctly. Here's what I've tried so far. My error is:

Can't use an undefined value as a HASH reference at C:\test_report_print.pl line 29.

If I try and remove the curly braces on the RecordSource property I get this error

Can't call method "RecordSource" on an undefined value at C:\test_report_print.pl line 29.

Any ideas at all? below is my code

sub printReport
{
    my ($location) = @_;
    
    my $path = "XXX";

    #get new object
    my $access = Win32::OLE->new('Access.Application') or die "$!";
    
    #open the database
    $access->OpenCurrentDatabase($path);
    
        #change the record source to the new table
        $access->{Reports}->Item(1)->{RecordSource} = $location;
    
    #Print the report
    $access->DoCmd->OpenReport("XXX");

    
}
[download]

Thanks in advance for any help.

---

---

• Are you posting in the right place? Check out Where do I post X? to know for sure.
• Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:

  <code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>

• Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
• Want more info? How to link or How to display code and escape characters are good places to start.