Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Thanked 0 Times in 0 Posts

    yes/no prompt (off 97)

    hello all,

    i am running a db that works off a switchboard. one of the buttons allows for the importation of a file. however, this file needs to be formatted first. I would like a msgbox to appear that would ask the use rif they have formatted the file already. if not they could stop the macro form continuing. if they have they would select the other button and continue. thanks.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Sint Niklaas, Belgium
    Thanked 0 Times in 0 Posts

    Re: yes/no prompt (off 97)

    Use the following code in a module. Save the module with any name you want but not IsFormated.
    <pre>Sub IsFormated()
    Dim Answer As Integer
    Answer = MsgBox("Is the file formated ?", vbYesNo, "Format")
    If Answer = vbYes Then
    'put the code here to import the file
    End If
    End Sub</pre>

    In the switchbox use the Runcode command and enter IsFormated as Function name.

Posting Permissions

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