Database Help!

profileSkrubbz
  1. Start Access, and then open the BuySell database..
  2. Extract the file, and save it to your desktop.
  3. Follow the steps below to design the macros and the switchboard form.
    • Click on the Create tab, and then create 3 different macros. The actions are listed below:
      1. Create a macro and save it as "Basic." Program the macro to do the following:
        • Open a message box that reads, "Open Form 'Item' "
        • Open the form "Item"
        • Open a message box that reads, "This is a beep"
        • Sound a beep
        • Open a message box that reads, "Directing to record 18"
        • Go to record 18 in the form "Item"
        • Open a message box that reads, "Closing form 'Item' "
        • Close the form
      2. Create a new macro, and save it as "Print Form Item." Program the macro to do the following:
        • Open the form "Item"
        • Select the form "Item"
        • Run the PrintSelection command
        • Reselect the form "Item"
      3. Create a new macro and save it as "Run Macros/Exit Database." Program the macro to do the following:
        • Run the macro "Basic"
        • Run the macro "Print Form Item"
        • Close the database
    • Click on the Create tab, and create a new blank form.
    • Name it "Switchboard," and open it in the Design view.
    • Create 3 buttons, and attach your 3 macros.
    • Create a label for each of your buttons.
    • Associate each label with the button command name.
    • Set the background color for the switchboard to a color of your choice.
    • Test your macros

     

     

    Upon a final handshake I will provide a link to the database file that is needed for this one!

    • 9 years ago
    • 10
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      buysell.mdb
    Bids(1)