Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Location
    Orlando Florida
    Posts
    20

    Talking Unanswered: Supress microsoft access message

    All,

    I have searched this forum and I did come across one thread that reference the problem with suppressing microsoft access message, but; has anyone come up with a work around instead of viewing thru a web page. I have a main form and on the form I have a command button to open up a new form, but I get this "Microsoft Access ok" message every single time. Is there any other way I can approach this.

    Thanks,

    B. Davis-

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343
    Have you tried using this command
    docmd.Setwarning False

  3. #3
    Join Date
    Nov 2003
    Location
    Orlando Florida
    Posts
    20
    Originally posted by khan
    Have you tried using this command
    docmd.Setwarning False

    Yes, I have tried that and I still get the message.

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    if you use a line of code that says

    on error goto myerrors (or some name)

    then in many cases vb reads all the code and if there is no error message (err.number = 0) that message will display

    sound like you have some errorhandling and messasges to display them, either behind the command button or behind the on open event of the form you may see

    msgbox err.number

    if so do this

    if err. number <> 0 then
    msgbox err.number
    else
    end if

    I hope this helps

  5. #5
    Join Date
    Nov 2003
    Location
    Orlando Florida
    Posts
    20
    Originally posted by axsprog
    if you use a line of code that says

    on error goto myerrors (or some name)

    then in many cases vb reads all the code and if there is no error message (err.number = 0) that message will display

    sound like you have some errorhandling and messasges to display them, either behind the command button or behind the on open event of the form you may see

    msgbox err.number

    if so do this

    if err. number <> 0 then
    msgbox err.number
    else
    end if

    I hope this helps



    You are so right!!!! Thank you for your help.

    B. Davis-

  6. #6
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    you are welcome

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •