Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Create a new Query in Design View. Close the Add Table dialog box. From the Query menu, select SQL Specific, and then click Union. Add the following SQL statement to the Query: SELECT LastName & ", " & FirstName, EmployeeID FROM Employees UNION SELECT '(All)', null FROM Employees Save the Query as EmpUnionAll, and then close the Query. Open the Employees form in Design view. Double-click on the ReportsTo combo box to bring up the control properties. On the Data tab of the Properties box, change the Row Source to the EmpUnionAll query that you created above. Change the Bound Column property on the Data tab from 1 to 2. On the Format tab, change the column width from 0 to 2;0. Open the form in Form view. Notice that you can now select '(All)' from the combo box list.
|How to include a comma in a currency field within an expression in a query in Access 2010||3||28|
|Newbie needs help printing from a form.||10||19|
|MS Access Calculation wont work||5||35|
|Search Form not Querying||2||10|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
21 Experts available now in Live!