ABCD has Runtime errors - Microsoft Access ABCD


	Back to ABCD Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

ABCD has Runtime errors

Andrew Shaw

2 years ago

Hello,

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.

	Richard Rost @Reply 2 years ago
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 Shaw OP @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.

	Richard Rost @Reply 2 years ago
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 Shaw OP @Reply 2 years ago
thank you sir. I'll know more once I get through your classes. Working on them!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in ABCD.

Next Unseen

New Feature: Comment Live View