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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 23:50, Emptypockets451
You need to design a circuit that implements the functions in the following table: s0 s1 function0 0 a + 10 1 a – b1 0 a + b1 1 a – 1s0 and s1 are 1-bit control inputs to select the function of the circuit. inputs a and b are 4-bitnumbers in 2s complement form. the output is also a 4-bit number in 2s complement form. you are allowed to use only one ttl 7483 4-bit adder to implement all the functions. but anynumber of other components (except the adder) can be used. hint: design a combinational logic circuit to modify the input b and the “carry input” of theadder depending on the control inputs s0 and s1.important: lab grade will depend on the working of the circuit & will be checked of by your labinstructor.1. is the output valid for the following input combinations: a. s0 = 0, s1 = 0, a = 7, b = 3? b. s0 = 0, s1 = 1, a = 7, b = 3? c. s0 = 1, s1 = 0, a = -4, b = -5? d. s0 = 1, s1 = 1, a = -8, b = 6? 2. what is the range of inputs (for both a and b) that will produce the valid output for all the functions?
Answers: 3
image
Computers and Technology, 23.06.2019 20:30, maryanapritchak1829
If chris has a car liability insurance, what damage would he be covered for
Answers: 1
image
Computers and Technology, 23.06.2019 21:30, quintonps12
Which of the following includes the three primary network access technologies? dsl, cable modem, broadband lan, wan, man voip, uc, iptv tcp/ip, ftp, dhcp
Answers: 2
image
Computers and Technology, 24.06.2019 10:10, juliana0122
Scanning the road can be thought of as a
Answers: 2
You know the right answer?
Design and create a form named frmQueries that has the following components and characteristics: a....

Questions in other subjects:

Konu
English, 04.11.2020 01:30