tailieunhanh - access 2007 vba bible phần 9

So với phiên bản đầy đủ, SQL Server 2005 Express (SSE) có một số hạn chế, nhưng nó là tốt để thử nghiệm với SQL Server như là một kết thúc trở lại, hoặc phát triển các ứng dụng nhỏ. SSE bao gồm tất cả các tính năng cơ sở dữ liệu cốt lõi của SQL Server 2005, | Customizing the Ribbon with XML in Access Databases and Add-ins 15 FIGURE A table filled with names of tables and their fields. zstblTableAndFieldNames - B X TableName FieldName - DataType Required ValidationRi tbIBackupInfo SaveDate 8 0 fl ItblBackupInfo SaveNumber 3 0 lj HtblCategories CategarylD 4 0 tbICategories CategoryNa Table filled -1 tblCategories Description 0 tbICategaries Picture i j Print report now 0 tblcategoriesl CategorylD 0 tblCategoriesl CategoryNa 1 1 tblCategoriesl Description 1 h 1 0 tblcategoriesl Picture 0 tbIContacts ContactID tbIContacts FirstName 10 0 tblContacts La st Name 10 0 tbIContacts Salutation 10 0 tbIContacts 10 0 tblContacts City 10 0 tbl Contacts StateOrProvince 10 0 tbIContacts PostalCode 10 0 tblContacts Country 10 0 tbIContacts CompanyName 10 0 tbIContacts 10 0 tblContacts WorkPhone 10 0 Record 1 -4 1 ter 1 Search Selecting the Back up back end database command extracts the name of the back end database from the Connect string of a linked table and presents an InputBox with a proposed save name which can be edited as desired. The InputBox is shown in Figure FIGURE An InputBox with a proposed save name for a back-end database. 557 Part III Adding More Functionality to Office If you run this command in a database that has no linked tables you will instead get the message shown in Figure FIGURE A message when attempting to back up the back end for a database that has no linked tables. The procedures for the List Table Fields List Query Fields Select Options Back up current database and Back up back end database buttons are similar to those in the Extras add-in except that they use the ByVal control As IRibbonControl argument that is needed to run them from Ribbon buttons their code is not listed here. Summary Although at first it may appear that the new Ribbon is not customizable you can in fact customize it at least by adding new tabs and groups with controls to run your code. This .