Access 2007 articles, fixes and updates - letter H

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft Access 2007 starts with letter H that have been released. The list is daily updated.

• 926535 How to clear the list of recently used files in 2007 Office programs Q926535 KB926535 January 25, 2021
• 263084 How to work with the Outlook E-mail Security Update in an Access database Q263084 KB263084 January 25, 2021
• 283849 How to troubleshoot and to repair a damaged Access 2002 or later database Q283849 KB283849 August 20, 2020
• 2591018 How to obtain Service Pack 3 (SP3) packages in 2007 Office system, 2007 Office servers, and Windows SharePoint Services 3.0 Q2591018 KB2591018 April 10, 2020
• 280372 How to fill a list box or a combo box with database object names Q280372 KB280372 October 23, 2019
• 826511 How to use a setup log to troubleshoot setup problems in Office Q826511 KB826511 May 27, 2019
• 234788 How to find the installation path of an Office application Q234788 KB234788 May 27, 2019
• 300693 How to dynamically set the input parameters of a report at run time in an ADP Q300693 KB300693 April 23, 2018
• 286828 How to implement Query by Form (QBF) in an Access project Q286828 KB286828 April 23, 2018
• 284286 How to reset changes to the Application.Printer object Q284286 KB284286 April 23, 2018
• 283200 How Access projects (ADPs) use the DefaultMaxRecords setting and the T-SQL Set Rowcount statement Q283200 KB283200 April 23, 2018
• 923718 How to troubleshoot a failed installation of the Beta 2 Technical Refresh update for 2007 Microsoft Office suites Q923718 KB923718 April 22, 2018
• 287685 How to concatenate fields in a text box to remove blank lines Q287685 KB287685 April 22, 2018
• 239930 How to obtain built-in constant values for an Office application Q239930 KB239930 April 22, 2018
• 924461 How to change the company name and user name in 2007 Office programs Q924461 KB924461 April 20, 2018
• 289508 How to view error signatures if an Office program experiences a serious error and quits Q289508 KB289508 April 20, 2018
• 306881 How to programmatically change the connection of a Microsoft Access project Q306881 KB306881 April 19, 2018
• 290178 How to create a query that has parameters to evaluate complex criteria in Microsoft Access Q290178 KB290178 April 19, 2018
• 289670 How to synchronize two combo boxes on a form in Microsoft Access Q289670 KB289670 April 19, 2018
• 283874 How to find a record using ADO and Jet OLE DB provider Q283874 KB283874 April 19, 2018
• 209849 How to loop through the references to view their properties in Microsoft Access Q209849 KB209849 April 19, 2018
• 209215 How to reset the page number on a group level in an Access report Q209215 KB209215 April 19, 2018
• 924617 How administrators can use Office policy templates together with the Group Policy settings of Windows Q924617 KB924617 April 18, 2018
• 924284 How to enable the Memory Diagnostic test for 2007 Office products on a Windows Server-based computer Q924284 KB924284 April 18, 2018
• 918583 How to use the Workgroup Administrator utility in Access 2007 Q918583 KB918583 April 18, 2018
• 918574 How to register or unregister ActiveX controls in Access 2007 Q918574 KB918574 April 18, 2018
• 888695 How to use the Common Dialog API in a database in Access 2003 or Access 2007 Q888695 KB888695 April 18, 2018
• 826766 How to make a change to dates by using functions and operators in Access Q826766 KB826766 April 18, 2018
• 824255 How Access resolves Visual Basic for Applications references Q824255 KB824255 April 18, 2018
• 815282 How to convert data values of the Text data type to the proper case format in Microsoft Access Q815282 KB815282 April 18, 2018
• 812719 How to programmatically create a new column in an Access report Q812719 KB812719 April 18, 2018
• 319317 How to automate the process of selecting the printer for a report in Microsoft Access Q319317 KB319317 April 18, 2018
• 308312 How to use Application roles with Access projects and SQL Server 2000 Desktop Edition Q308312 KB308312 April 18, 2018
• 304932 How to manually split a Access database in Microsoft Access Q304932 KB304932 April 18, 2018
• 304408 How to shut down a custom Access application remotely Q304408 KB304408 April 18, 2018
• 304323 How to use ADOX to create an SQL pass-through query in Access Q304323 KB304323 April 18, 2018
• 304302 How to build a dynamic query with values from a search form in Access 2007, in Access 2003, or in Access 2002 Q304302 KB304302 April 18, 2018
• 304104 How to programmatically apply conditional formatting settings to all form controls Q304104 KB304104 April 18, 2018
• 292799 How the Table Analyzer Wizard works Q292799 KB292799 April 18, 2018
• 292461 How to use Visual Basic code to collate and to print two reports Q292461 KB292461 April 18, 2018
• 290623 How to attach an existing SQL Server 2000 Database to SQL Server 2000 Desktop Engine Q290623 KB290623 April 18, 2018
• 290190 How to create two functions to calculate age in months and in years in Microsoft Access Q290190 KB290190 April 18, 2018
• 289562 How to prevent database bloat after you use Data Access Objects (DAO) Q289562 KB289562 April 18, 2018
• 287668 How to use SQLConfigDataSource to create an Access system DSN Q287668 KB287668 April 18, 2018
• 286222 How to optimize Microsoft Access when using ODBC data sources Q286222 KB286222 April 18, 2018
• 285829 How to use data transformation services (DTS) to export data from a Microsoft Access database to an SQL Server database Q285829 KB285829 April 18, 2018
• 278400 How to use form parameters in the RecordSource property in an Access project Q278400 KB278400 April 18, 2018
• 266387 How to find and to list Access VBA procedures by using MFC Q266387 KB266387 April 18, 2018
• 258511 How to obtain the window handle for an Office Automation server Q258511 KB258511 April 18, 2018
• 229802 How to use SetOption to disable warning messages in an Access Application Q229802 KB229802 April 18, 2018
• 210166 How to create pop-up context-sensitive Help by using Windows API WinHelp() Q210166 KB210166 April 18, 2018
• 928116 How to determine which version of a 2007 Office product is installed Q928116 KB928116 April 17, 2018
• 925757 How to enable or disable hyperlink warning messages in 2007 Office programs and in Office 2010 programs Q925757 KB925757 April 17, 2018
• 924614 How to use the repair process in the 2007 Office programs Q924614 KB924614 April 17, 2018
• 924611 How to install the individual 2007 Office features or to repair the installed 2007 Office programs Q924611 KB924611 April 17, 2018
• 924460 How to manage templates in 2007 Office programs and in 2010 Office programs Q924460 KB924460 April 17, 2018
• 919895 How to troubleshoot problems that you may experience when you try to activate a 2007 Office suite Q919895 KB919895 April 17, 2018
• 895456 How to change the product key for Office XP, for Office 2003, and for the 2007 Office system Q895456 KB895456 April 17, 2018
• 892490 How to create a DSN-less connection to SQL Server for linked tables in Access Q892490 KB892490 April 17, 2018
• 827423 How to retrieve the selected items in a multiple selection List Box as a comma-delimited string in Microsoft Access Q827423 KB827423 April 17, 2018
• 826765 How to enforce or disable the startup options in an Access database project Q826765 KB826765 April 17, 2018
• 812718 How to reset an AutoNumber field value in Access Q812718 KB812718 April 17, 2018
• 325233 HOW TO: Hide the Combo Box Drop-Down Arrow on a Form in Microsoft Access Q325233 KB325233 April 17, 2018
• 304473 How to edit records in related tables in a Microsoft Access database Q304473 KB304473 April 17, 2018
• 304466 How to define relationships between tables in an Access database Q304466 KB304466 April 17, 2018
• 304462 How to add lookup fields in a Microsoft Access table Q304462 KB304462 April 17, 2018
• 304458 How to create a crosstab query with multiple value fields Q304458 KB304458 April 17, 2018
• 304428 How to use the query by form (QBF) technique in Microsoft Access Q304428 KB304428 April 17, 2018
• 304356 How to modify query properties in Microsoft Access Q304356 KB304356 April 17, 2018
• 303968 How to create an SQL pass-through query in Access Q303968 KB303968 April 17, 2018
• 292634 How to use a query to filter unique data in Access Q292634 KB292634 April 17, 2018
• 290142 How to open documents from FTP site and save documents to FTP site with Office programs. Q290142 KB290142 April 17, 2018
• 290136 How to create a running totals query in Microsoft Access Q290136 KB290136 April 17, 2018
• 287658 How to move to a specific record from a Combo Box selection in Microsoft Access Q287658 KB287658 April 17, 2018
• 285822 How to determine who is logged on to a database by using Microsoft Jet UserRoster in Access Q285822 KB285822 April 17, 2018
• 285820 How to display images from a folder in a form, a report, or a data access page Q285820 KB285820 April 17, 2018
• 281670 How to force a new line in a MsgBox message in Access Q281670 KB281670 April 17, 2018
• 210276 How to store, calculate, and compare Date/Time data in Microsoft Access Q210276 KB210276 April 17, 2018
• 826208 How to edit the Windows registry to clear the list of most recently used files in Office Q826208 KB826208 April 16, 2018
• 310803 How to resolve reference issues in an Access database Q310803 KB310803 June 20, 2017
• 210362 HOW TO: Use the Attributes Property for TableDef Objects in Microsoft Access Q210362 KB210362 January 7, 2017
• 209502 How to store SQL database login IDs and passwords locally Q209502 KB209502 January 7, 2017
• 168798 How To Parse City, State, and Zip Code into Separate Values Q168798 KB168798 January 7, 2017
• 928723 How to use the Alert ID feature in the 2007 Office programs when you search for a warning or an error message in the Microsoft Knowledge Base Q928723 KB928723 December 9, 2015
• 328828 How to troubleshoot errors that may occur when you update data in Access queries and in Access forms Q328828 KB328828 October 1, 2015
• 935787 How to create legacy Office files in the 2007 Office system Q935787 KB935787 January 16, 2015
• 928027 How to access workbooks that contain menu and toolbar commands for the 2007 Office programs through Office Offline Q928027 KB928027 January 16, 2015
• 926707 Help content does not appear when you click "Help" during the setup of a 2007 Office program on a computer that is running a 64-bit version of Windows XP or of Windows Vista Q926707 KB926707 January 16, 2015
• 926426 Help content may not appear as expected in 2007 Office programs Q926426 KB926426 January 16, 2015
• 274680 How to use MFC to retrieve a list of macro names in an Office document Q274680 KB274680 December 23, 2014
• 949585 How to obtain the latest service pack for the 2007 Office suite Q949585 KB949585 June 13, 2012
• 870622 How to troubleshoot problems that you may experience when you try to print to a local printer by using Office programs in Windows XP Q870622 KB870622 September 18, 2011
• 2534458 How to obtain the latest service pack for the 2007 Office suite Q2534458 KB2534458 April 10, 2011
• 2519419 How to obtain a new product key for a Microsoft Office suite Q2519419 KB2519419 April 7, 2011
• 945598 How to determine the version of an installed 2007 Office language pack Q945598 KB945598 April 7, 2010
• 888696 How to print a check box without borders on a pre-printed form in Access Q888696 KB888696 October 30, 2008
• 319482 How to populate text boxes with multicolumn Combo Box selections Q319482 KB319482 October 30, 2008
• 291539 How to create and drop tables and relationships by using SQL Data Definition Language (DDL) in Microsoft Access Q291539 KB291539 October 30, 2008
• 291264 How to refresh links in a runtime application in Microsoft Access Q291264 KB291264 October 30, 2008
• 289580 How to determine which user has opened a database exclusively in Access Q289580 KB289580 October 30, 2008
• 292783 How to force Microsoft Access to use read-only (snapshot) mode for linked data Q292783 KB292783 January 9, 2008
• 288367 How to configure Office applications to run under a specific user account Q288367 KB288367 August 23, 2007
• 288368 How to configure Office applications for automation from a COM+/MTS package Q288368 KB288368 July 2, 2007
• 830033 How to apply Windows XP themes to Office COM add-ins Q830033 KB830033 May 16, 2007
• 300950 How to troubleshoot custom Smart Tags in Office Q300950 KB300950 April 13, 2007
• 302891 How to start MSBackup.exe from Microsoft Access Q302891 KB302891 March 28, 2007
• 288366 How to configure Office applications to run under the interactive user account Q288366 KB288366 March 28, 2007
• 290148 How to use the Undo feature with inserted objects in Office programs Q290148 KB290148 November 21, 2006