subject

Design and create a form named frmQueries that has the following components and characteristics: a. Set the form's Caption property to Instruction Queries.

b. Add a list box control (approximately 1 inch from the top of the form and 1 inch from the left border of the form) with a Name property value of lstQueryList that displays all the query names contained in the Instruction database, excluding those that start with a "~" character. To place the query names in the list box control, use a SQL SELECT statement to retrieve the query names from the MSysObjects table, and display the queries in reverse alphabetical order (descending order). (Hint: Use the same SQL select query that you used in the module.) Widen the list box control to approximately 2.25 inches.

c. In the attached label control, change the caption to Available Queries, formatted with a 12-point, bold, italic Calibri font, position the label above the list box control, and increase the width of the label control to fit the text.

d. Add two command buttons below the list box control. The left command button should display the Preview icon below the word Preview, and the right command button should display the MS Access Query icon below the word Display.

e. Create a macro for the form that moves the focus to the first query name in the list box control when the form loads.

f. Create a macro that causes the query datasheet to display the selected query, and then configure the form so the macro runs when a user double-clicks a query name in the list box.

g. Create a macro that causes the query datasheet to display the selected query, and then configure the form so the macro runs when a user selects a query name in the list box and clicks the right command button (the Display button).

h. Create a macro for the left command button (Preview button) that opens the selected query in Print Preview.

i. Set the background color of the Detail section to Light Blue 3 in the Standard Colors section. Set the background color of the list box and the two command buttons to Light Blue 2.

j. Disable the form's shortcut menu, record selectors, and navigation buttons, but do not disable the Close button.

k. Test the form.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 21:30
Write a function named printfloatrepresentation(float number) that will print the floating point representation of a number using the format given below. (sign bit) exponent in binary (assumed bit).significandfor example if the number passed an argument is 71 yourprogram should print (0) 10000101 (1).00011100000000000000000similarly if the number passed to the function as argument is -71 the program should print (1) 10000101 (1).00011100000000000000000
Answers: 3
question
Computers and Technology, 23.06.2019 09:00
What provides an array of buttons for quick access to commonly used commands and tools
Answers: 1
question
Computers and Technology, 23.06.2019 16:00
What is the biggest difference between section breaks and regular page breaks? section breaks are more difficult to add than page breaks. section breaks make it easier for you to view the document as an outline. section breaks allow you to have areas of the document with different formatting. section breaks are smaller than regular page breaks.
Answers: 2
question
Computers and Technology, 23.06.2019 16:30
You have read about the beginnings of the internet and how it was created. what was the internet originally created to do? (select all that apply) share research. play games. communicate. share documents. sell toys
Answers: 1
You know the right answer?
Design and create a form named frmQueries that has the following components and characteristics: a....
Questions
question
Chemistry, 09.01.2021 04:30
question
Mathematics, 09.01.2021 04:30
question
English, 09.01.2021 04:30