Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    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
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    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.
    Francois

Posting Permissions

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