how to create qr code in vb.net Part 6: Linking Access and the Web in VS .NET

Encode Code128 in VS .NET Part 6: Linking Access and the Web

27

27

27

27

27

27

Microsoft Office Access 2003 Inside Out The procedure for creating a data access page from an existing form or report is very simple. In fact, I created many of the sample data access pages that you find in the Housing Reservations application (Housing.mdb) by converting an existing form or report. You can convert a form or report to a data access page in two steps:

27 27 27 27 27 27

a data access page:

for the new data access page, change the As box to Data Access Page, and click OK. One of the simple forms that you can convert to a data access page in the Housing Reservations application is frmDepartments, as shown in Figure 27-27.

You need to fix the two combo boxes before you can successfully convert the form. The Manager combo box is based on a parameter query. Also, the Postal Code combo box uses a query that returns more than 50,000 rows this won t perform well in a data access page. Open the frmDepartments form in Design view and make the following changes:

27 27 27 27

can see in Design view and that is displayed when you re on a new row in the form) and delete it. Now, choose Save As from the File menu, change the name to Departments, and select Data Access Page in the As drop-down list. Click OK to create the new data access page. Access shows you a New Data Access Page dialog box where you can choose the folder where you want to save the HTML file for your new data access page. Navigate to the folder you want and click OK. Access opens the resulting page in Page view, as shown in Figure 27-28. You can find this converted form saved as dapXmplDepartments in the sample database.

27 27

When you have created Visual Basic code behind your form or report, converting to a data access page does not convert the code to VBScript. However, Access does save all your Visual

Microsoft Office Access 2003 Inside Out Basic code in a comment section at the end of the HTML file to assist you in creating similar functionality in VBScript. To see the code, switch the new page to Design view, and then click the Microsoft Script Editor button on the toolbar or press Alt+Shift+F11 to open the VBScript editor window. You can scroll down toward the bottom of the HTML to find your Visual Basic code saved as a comment, as shown in Figure 27-29. You ll learn more about working in the VBScript editor later in this chapter.

27 27 27 27 27 27

Converting a report to a data access page is also simple. As long as the report does not have any subreports or bound OLE objects, the data access page should look nearly identical to the report. The conversion process also handles grouping levels nicely, so your data access page ends up grouped in the same way as your report. To try this out, open rptFacilities in Design view as shown in Figure 27-30.

This report is reasonably simple, but it does include one group and a sort within the detail list of rooms. Because the data access page conversion cannot handle percentages, you should delete the percentage calculation text box and label in the FacilityID Footer section. You should also delete the text box that displays the current date and time (=Now()) and the text box that displays Page x of y in the Page Footer section and close up that section to zero height. Choose Save As from the File menu, change the name to Facilities, and choose Data Access Page in the As drop-down list. Click OK in the Save As dialog box, choose a location for the new data access page HTML file, and click OK in the New Data Access Page dialog box to convert the report. Your result should look like Figure 27-31.