Search results

  1. S

    Msgbos Question

    Thanks for the repley I should of known it would be that easy. Slides
  2. S

    Msgbos Question

    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...
  3. S

    Number Generating Question

    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
  4. S

    Number Generating Question

    Number Generating How would I go about doing that. Thanks Slides_Library
  5. S

    Number Generating Question

    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...
Back
Top Bottom