USA: +1(669)289-8683 
Sign in
- Start Access, and then open the BuySell database..
- Extract the file, and save it to your desktop.
- 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: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 beepOpen 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 formCreate 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 commandReselect the form “Item”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 databaseClick 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!
