RodShinall
Registered User.
- Local time
- Yesterday, 21:18
- Joined
- Dec 21, 2006
- Messages
- 32
I want to rename a report by clicking a command button on a form. I have this simple code in the click event:
Dim strReportNameNew As String
Dim strReportNameOld As String
strReportNameNew = txtChangeTo.Text
strReportNameOld = txtChooseReport.Text
DoCmd.Rename strReportNameNew, acReport, strReportNameOld
The code fails with this error message:
Microsoft Visual Basic
Run-time error '29068'
Household Labels cannot complete this operation. You must stop the code and try again.
I am able to rename the report manually.
I have searched but been unable to find out what is causing this error. Any help would be greatly appreciated.
Dim strReportNameNew As String
Dim strReportNameOld As String
strReportNameNew = txtChangeTo.Text
strReportNameOld = txtChooseReport.Text
DoCmd.Rename strReportNameNew, acReport, strReportNameOld
The code fails with this error message:
Microsoft Visual Basic
Run-time error '29068'
Household Labels cannot complete this operation. You must stop the code and try again.
I am able to rename the report manually.
I have searched but been unable to find out what is causing this error. Any help would be greatly appreciated.