Results 1 to 2 of 2
  1. #1
    cm-net is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2010
    Posts
    7

    Can't Remove MsgBox without module not working

    Hello, below is the code I'm working with. I don't want the MsgBox to pop up (yellow arrow below) when the code is executed. I just want the code to execute. I tried just deleting the msgbox section but the module just doesn't work then. Is there any way to remove the msgbox and still have the code run, or is there a way to always click "OK" automatically when the box pops up? Thank you in advance for any guidance. c



    Click image for larger version. 

Name:	Untitled-1.jpg 
Views:	8 
Size:	95.1 KB 
ID:	32273

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Add a single quote (apostrophe) ' at the start of the If MsgBox line to disable it.
    Do exactly the same thing at the start of the 'End If line that follows later (not visible in your screenshot)
    Both line will then appear in green & the code will run without the message appearing

    SIMPLES as the advert says in the UK
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. class module vs regular module
    By Madmax in forum Modules
    Replies: 1
    Last Post: 05-01-2012, 03:44 PM
  2. Replies: 3
    Last Post: 02-03-2012, 06:37 PM
  3. Working days module help for noob
    By AndycompanyZ in forum Modules
    Replies: 5
    Last Post: 07-27-2011, 01:43 AM
  4. Replies: 4
    Last Post: 05-16-2011, 04:58 PM
  5. Msgbox And Search Code Not Working Properly
    By vampyr07au in forum Forms
    Replies: 1
    Last Post: 05-02-2011, 05:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums