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 11:00
How does a policy manual an organization? a. it boost productivity. b. it create awareness in employees about the organization’s values. c. it employees achieve targets. d. it safeguards the organization from liabilities.
Answers: 1
question
Computers and Technology, 22.06.2019 22:30
Which of the following factors would your hypothetical supervisor look at when deciding whether to test a biological material sample for dna? the amount of other evidence you have implicating a suspect in a crime the annual budget for the crime lab both of the above none of the above; you would almost always order a test
Answers: 3
question
Computers and Technology, 23.06.2019 03:30
In vista and windows 7, the appearance and personalization option allows you to change the
Answers: 1
question
Computers and Technology, 23.06.2019 19:30
You can apply several different worksheet themes from which tab?
Answers: 1
You know the right answer?
Design and create a form named frmQueries that has the following components and characteristics: a....
Questions
question
English, 28.07.2019 16:00
Questions on the website: 13722361