Hi there, I wonder if you can help me. I've used ASPRunner to create my pages but for some reason when entering or editing the records I sometimes get:
Error number -2147217913
Error description [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
URL /asptest/Customers_edit.asp
I've tracked this down to some of the fields are blank (intentional) so is there anyway for the ASP code to allow null fields? similar to NZ in Access?
Hope you can help & thanks for saving me hours & hours of work with this excellent piece of software. Once I'm happy the program can do what I want...it's there bar the null fields I'll be signing up for the full version....worth every penny...or cent <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=13&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Many Thanks
Ninja