thought you should know. Open ABCD, click "entity list", click "add", click "Select Picture" and you get Run-time error '94': Invalid use of Null.
Debug (error is 2nd line) If IsLoaded("EntityF") Then EntityID = Forms!EntityF!EntityID
Skipping the picture... Added name, Prefix, Organization. The title doesn't have what I want, so I double-clicked it, added "Dudeman" and attempted to Set and Close.
Run-time error '2118': You must save the current field before you run the Requery Action.
Can't escape out, can't "set & close", must kill the database.
Does this happen in the stock database directly as downloaded from my website or is this a database you modified at all? Because no one else has complained about this error and I know at least 30 or 40 people have downloaded it.
Andrew ShawOP
@Reply 2 years ago
Hello sir. It was a direct download, no modifications at all. As a matter of fact, I made sure it was so that I did not have any interference. Having just repeated the post, only the first error persists.
Yeah, that's going to happen if you try to add a picture to the record before the ID is assigned, hence the invalid use of null. That could be fixed with a simple check for IsNull in the code. I'll add it to the list.
Andrew ShawOP
@Reply 2 years ago
thank you sir. I'll know more once I get through your classes. Working on them!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
ABCD.
