I want to have a msgbox tell the user if an [accnum] field is blank. But I also want it to say what should be there.
Code:
If IsNull (Me.Accnum_2)=False Then Msgbox "Accession Number [Value of accnum field here] has not been entered in Accession Number Form"
I was thinking I could have it fill...
Thanks Wayne,
Can I put this as a default value or is there more to it.
ImageID = Nz(DMax("[ImageID]", "ImageTable", "[BookID] = " & Me.BookID), 0) + 1
Thanks
Slides_Library
I am building a data base for a Library and would like to generate a number in this form 1234567.123. The number is the Accession number for an image.
The first seven digits come from a book ID. So I want a table were I can enter the number and information about the book.
Then I want the...