Q: I am using a database that was developed in Access 2003 and when I try to
print a set of labels, it asks me for the parameter "TRIM" as if I wanted to
input a variable value. I went back to Access 2003 and the database still
works properly and prints out the labels.
print a set of labels, it asks me for the parameter "TRIM" as if I wanted to
input a variable value. I went back to Access 2003 and the database still
works properly and prints out the labels.
I then made up a sample label in Access 2007 using the TRIM function with
the same result. When I tried to run the label; it asked for the
"paramenter" TRIM's value.
Have they changed something or am I missing something? I can use the
function when writing the report but it doesn't recognize the function when I
run the report.
A: Suggestions:
1. Open any code window (e.g. press Ctrl+G), and choose References on the
Tools menu. Make sure none of the checked libraries have the word "MISSING"
next to them.
1. Open any code window (e.g. press Ctrl+G), and choose References on the
Tools menu. Make sure none of the checked libraries have the word "MISSING"
next to them.
2. Add the folder where you keep your database as a trusted location under:
Office Button | Access Options | Trust Center | Trust Center Settings
Office Button | Access Options | Trust Center | Trust Center Settings
