| re: Data migration problem: Report sticks to old table name
On 27 May 2005 05:40:38 -0700, "Florifulgurator"
<martin.gisser@argovision.de> wrote:
It's easy to forget about the grouping levels. Design the report and
select View / Sorting and Grouping.
-Tom.
[color=blue]
>Hello,
>
>trying to clean up other´s mess...
>
>I´ve replaced some tables (previously linked to another Access DB)
>with renamed tables linked to a PostgeSQL DB (removed spaces and
>Ümlauts in names, secured referential integrity).
>
>There´s one (probably more) report that doesn´t get the new name:
>
>The report is opened via a 1-line macro when clicking a button in a
>form. I replaced the table name in every report/form element, any VB
>code, and any query.
>Yet, when pressing the button, the report asks for a parameter value in
>that old table.
>Ignoring that by pressing OK, I mostly get a report with lots of #Error
>messages. Sometimes (mere chance?) I get the correct report.
>
>
>despairingly,
>Martin[/color] |