I have recently built a database, part of which was for printing out address labels.
The databse worked fine with a few sample entries. I set up the label printing using the Label Wizard. All was fine - it took the relevant data from the correct table (Table called Main, and it gets the data from the First Name, Surname, Address1, Address2, Town and Postcode fields) and displayed it as should be on labels.
I then spent a few hours inputting the actual address data - 120 names and addresses. When I went to open the Label report, it wouldn't open. I tried creating a new one again with the Label Wizard. When I got to the end of the wizard, it displayed the following box:
I tried using another table (an extremely simple one - a lookup table for titles - Mr/Mrs/Ms/Dr are the 4 entries), and got the same response. Even if I create a new table, I get this error.
I decided to create a blank database. Again, I received this exact same error. I tried messing around with various factors (e.g. label type) and got the message:
I guess this is a problem with my Office install, so I did a rebuild on the Add/Remove Programs menu, but still the problem persists.
The rest of my database still works fine. I can access the tables, add records, even the e-mail recipients form I made still works fine.
How can I solve this problem?
*edit* I should probably add that I am using Office 2003, and if it comes down to it, Windows XP Professional X64. I have been running this seup fine for months, so it is a puzzler!
The databse worked fine with a few sample entries. I set up the label printing using the Label Wizard. All was fine - it took the relevant data from the correct table (Table called Main, and it gets the data from the First Name, Surname, Address1, Address2, Town and Postcode fields) and displayed it as should be on labels.
I then spent a few hours inputting the actual address data - 120 names and addresses. When I went to open the Label report, it wouldn't open. I tried creating a new one again with the Label Wizard. When I got to the end of the wizard, it displayed the following box:
Code:
You entered an expression that has an invalid reference to the property |.
The property may not exist or may not apply to the object you specified.I tried using another table (an extremely simple one - a lookup table for titles - Mr/Mrs/Ms/Dr are the 4 entries), and got the same response. Even if I create a new table, I get this error.
I decided to create a blank database. Again, I received this exact same error. I tried messing around with various factors (e.g. label type) and got the message:
Code:
Application-defined or object-defined errorI guess this is a problem with my Office install, so I did a rebuild on the Add/Remove Programs menu, but still the problem persists.
The rest of my database still works fine. I can access the tables, add records, even the e-mail recipients form I made still works fine.
How can I solve this problem?
*edit* I should probably add that I am using Office 2003, and if it comes down to it, Windows XP Professional X64. I have been running this seup fine for months, so it is a puzzler!
Last edited:
