Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error on my report

Status
Not open for further replies.

smdemo

Programmer
Sep 15, 2002
63
US
I am getting the following error when I try to save a report and I have no idea what is causing it.

"You tried to assign the Null value to a variable that isn't a Variant data type."

The query that it is linked to works just fine and I continue to get this error even if I create a new report and do no more than link the report to that query and have nothing in it.

Any help on this one would be greatly appreciated.

 
When you save it? (repeating, dumbfounded)

The error sounds like it is happening at run time... Do you have any code on the report at all?

Have you tried compacting and repairing the database?

My next GUESS would be something to do with the printer... Try deleting the printer specified on the report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top