G
George
I converted an Access 97 database to 2000 and was able to successfully run all macros. After making some minor form change and adding new table records, the macros appear to no longer function.
Example 1 - Opens report in preview window, but report is not populated with record data.
Action: Open Report
Report Name: Issue Report
View: Print Preview
Filter Name: <Blank>
Where Condition: [EventID]=[Forms]![Issuesform]![EventID]
Example 2 - Receive “Syntax Error†when executing marco.
Marco Name: Set Last Update Date and Time
Condition: True
Action Name: SetValue
Arguments: [Forms]![Maintain TPR (MTNTPR)]![Last_Updated_Date], Now()
The compact and repair database utility did not resolve the problem.
Example 1 - Opens report in preview window, but report is not populated with record data.
Action: Open Report
Report Name: Issue Report
View: Print Preview
Filter Name: <Blank>
Where Condition: [EventID]=[Forms]![Issuesform]![EventID]
Example 2 - Receive “Syntax Error†when executing marco.
Marco Name: Set Last Update Date and Time
Condition: True
Action Name: SetValue
Arguments: [Forms]![Maintain TPR (MTNTPR)]![Last_Updated_Date], Now()
The compact and repair database utility did not resolve the problem.