Affiliates

Amazon.com


Popular Microsoft Books

Easy Microsoft Windows XP
Easy Microsoft Windows XP
Easy Microsoft Windows XP Home Edition, 4th Edition covers more than 150 of the most important tasks. 

Windows Vista Inside Out
Windows Vista Inside Out
Learn everything you need to know for working with Windows Vista--from the inside out! 

Microsoft Windows Vista Step by Step
Microsoft Windows Vista Step by Step
The smart way to learn the latest version of Microsoft Windows... 

Excel 2003 Essential Training
Excel 2003 Essential Training
Excel 2003 Essential Training with Mark Swift is a movie-based workshop 

PowerPoint 2003 Essential Training
PowerPoint 2003 Essential Training
PowerPoint 2003 Essential Training with David Rivers is a movie-based tutorial designed to help new and existing PowerPoint users 

Word 2003 Essential Training
Word 2003 Essential Training
Word 2003 Essential Training with David Rivers is a movie-based tutorial for users 

Access 2007 Bible
Access 2007 Bible
Harness the power of Access 2007 with the expert guidance in this comprehensive reference... 

Popular Microsoft Related Websites

Microsoft Corporation 

Microsoft Excel Tips from Excel Tip .com / Excel Tutorial / Free

Microsoft Excel Tips from ExcelTips Online

Tutorials From FunctionX

Free Computer Help, Tech Support, and Tips at MalekTips: Windows 

TechTutorials: A Free Computer Reference Site and Directory

Introduction To Windows Vista

VistaMaNiA- Windows Vista - Home

Windows Vista Team Blog

#1 Windows Vista Ultimate

Windows Vista Weblog



Microsoft Access Resources    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Resource covering the following applications - MS Windows XP, MS Windows Vista, MS Word, MS Excel, MS Access, MS OutLook, etc.,

  Microsoft Access Resources

How to reset the page number on a group level in an Access report  
The page number appears in the page footer Start Access and then open the sample database Northwind.mdb or the sample project NorthwindCS.adp. ... Method 2: The page number appears in the page header Start Access and then ... 

Issues that you may encounter when you open or are using a Microsoft Office Access database on a computer that is running Windows Vista  
Describes a series of issues that you may encounter when two or more Windows Vista-based computers are trying to use a shared Access database at the same time. Provides a workaround.. 

When you enter a list of strings for the RowSource property in an Access form or report, the strings are truncated  
In a Microsoft Access form or report, you enter a list of strings for the RowSource property of a combo box or of a list box that displays a value list.  

How to use SQLConfigDataSource to create an Access system DSN  
Use VBA in Access to call the SQLConfigDataSource function. ... Copy the sample database Northwind.mdb to the root directory of drive C. Create a new Access database.  

Description of the update for the 2007 Office programs: April 9, 2007  
Microsoft has released an update for Microsoft Application Error Reporting. This update fixes an issue with Microsoft Application Error Reporting that may cause some information about application errors to be sent to Microsoft without notifying you. 

Error message when you try to install a 2007 Office program: "Error 1935. An error occurred during the installation of assembly component"  
When you install one of the 2007 Microsoft Office programs that are listed in the "Applies to" section, the installation is not completed successfully. ... Then, try to install the 2007 Office program again.  

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  
You click Help during the setup of a 2007 Microsoft Office program on a computer that is running a 64-bit version of Microsoft Windows XP or of Windows Vista. ... Use the Office Customization Tool to run the 926707.reg file before the 2007 Office program is installed. 

You cannot export a report to an Excel format in Access 2007  
Discusses a problem that may occur when you run a macro that was created in an earlier version of Excel. Workarounds are provided. 

Error message when you try to install a 2007 Office suite or program: "Error 1321. Setup cannot modify the file "  
Describes that you may receive error message 1321 when you try to install 2007 Office suites and programs in a folder that has the "Encrypt contents to secure data" setting enabled. ... contents to secure data setting is enabled on the folder in which you are trying to install the 2007 Office suite ... 

Error message when you try to install a 2007 Office update package: "The installation of this package failed"  
You download and try to install an update package for a 2007 Microsoft Office suite. ... OFF2007 Office2007 Office 2007 To work around this problem, you must download the update package for the 2007 Office suite, and then manually extract and run the update package's Setup program.  

How to enable the Memory Diagnostic test for 2007 Office products on a Windows Server-based computer  
By default, the Memory Diagnostic test that is included with Office Diagnostics for 2007 Microsoft Office products is disabled on computers that are running Microsoft Windows Server. ... When you run Office Diagnostics for 2007 Office products ...  

You may be prompted to restart the computer after you remove a 2007 Office program or after you install an update  
You remove a 2007 Microsoft Office program from the computer. ... For example, this issue may occur when any of the following programs are running on the computer: Microsoft ActiveSync Microsoft Office Communicator Microsoft Office OneNote 2007  

How to manage templates in 2007 Office programs  
In Access 2007 Blank Database ... Microsoft Office Access 2007 does not allow for templates to be advertised. However, templates can be set to Not Available in Access 2007. ... For example, the English (US) version of 2007 Office installs a 1033 folder.  

How to troubleshoot a failed installation of the Beta 2 Technical Refresh update for 2007 Microsoft Office suites  
Describes how to troubleshoot a failed installation of the Beta 2 Technical Refresh update for 2007 Microsoft Office suites. This article describes how to troubleshoot a failed installation of the Beta 2 Technical Refresh (B2TR) update for 2007 Microsoft Office suites.  

You are prompted two times to type your username and your password when you try to open or to save a 2007 Office document  
You try to open a 2007 Microsoft Office document that is on a shared folder, or you try to save a 2007 Office document to a shared folder. When you do this, you are prompted two times to type your username and your password to access the shared folder.  

The Navigation Pane is not displayed when you use the NavigateTo action and then call the WindowUnhide RunCommand action in Access 2007  
You hide the Navigation Pane programatically by using the WindowHide RunCommand action in Microsoft Office Access 2007.  

A new empty row is added to the One table when you add a row to the Many table of an updatable One-to-Many query in Access 2007  
Describes a problem that occurs when you create an updatable One-to-Many join query that uses an output list that includes a complex field. Provides a workaround.  

How to use the repair process in the 2007 Office programs  
Describes how the repair process in the 2007 Microsoft Office system works. ... provides step-by-step methods that describe how you can use the repair process in the 2007 Office programs. ... If the source files can be accessed, a Windows Installer dialog box may briefly appear during the repair process.  

How to troubleshoot problems that you may experience when you try to activate a 2007 Office product  
how to change the product key, click the following article number to view the article in the Microsoft Knowledge Base: 895456 How to change the product key for Office 2003 and for Office XP If you are trying to install an Original Equipment Manufacturer (OEM) version of a 2007 Office product ...  

Description of the numbering scheme for product code GUIDs in 2007 Office suites and programs  
Describes how to read the GUIDs in 2007 Office suites and programs to determine information about version, release, and language of a suite or program. This article describes how to read the product GUID in the Microsoft Windows registry to determine information about the 2007 Microsoft Office ...  

Error message when you convert a database file from an earlier version of Access into an Access 2007 file: "Run-time error '13': Type mismatch"  
When you convert a database file from an earlier version of Microsoft Access into a Microsoft Office Access 2007 file, the application may stop responding if you try to run or compile code that uses Data Access Objects (DAO). ... To do this, follow these steps: Start Access 2007.  

A query may return corrupted data for Memo fields when you run the query against a SharePoint list in Access 2007  
You run an advanced query against a SharePoint list from Microsoft Office Access 2007. ... For more information about Access 2007, visit the following Microsoft Web site: http://www.microsoft.com/office/preview/programs/access/highlights.mspx  

Error message when you try to export an Access 2007 table that contains more than 65,000 rows to an Excel workbook: "You selected more records than can be copied"  
You try to export a Microsoft Office Access 2007 database table that contains more than 65,000 rows to a Microsoft Office Excel 2007 workbook (.xlsx) or to an Excel 2007 binary workbook (.xlsb).  

Error message when you try to add a new item value to a linked table in Access 2007: "Invalid argument"  
You create a new database in Microsoft Office Access 2007.  

The subform appears to be blank after you close a Filter by Form view without applying the filter in Access 2007  
When you close a form in Microsoft Office Access 2007, the subform appears to be blank.  

The Search text box continues to appear in an Access 2007 database after you click to clear the "Show Search Bar" check box  
After you click to clear the Show Search Bar check box, the Search text box continues to appear in the Navigation Pane of a Microsoft Office Access 2007-based database.  

The data in a report or in a form is not updated in Access 2007  
In Microsoft Office Access 2007, the data in a report or in a form is not updated when the following conditions are true: You open a report and a table at the same time, and you change the data in the table.  

Error message when you try to split a database by using the Database Splitter in Microsoft Office Access 2007: "Could not lock file"  
When you try to split a database by using the Database Splitter in Microsoft Office Access 2007, you may receive the following error message: Database Splitter Could not lock file. ... When Access 2007 creates a locking file, the file name extension changes from ".accdb" to ".laccdb".  

Fonts in a 2007 Office program may not appear as clear as expected  
To turn off ClearType fonts in a 2007 Office program, use one of the following methods: Microsoft Office Access 2007, Microsoft Office Excel 2007, Microsoft Office PowerPoint 2007, or Microsoft Office Word 2007 Click the Microsoft Office Button , and then click program Options . 

The Access Replication Wizard COM add-in may appear as #401 in Access 2007  
The Access Replication Wizard COM add-in may appear on the list of add-ins as #401 when you run the Add-in Manager or when you open the Add-ins dialog box in Microsoft Office Access 2007. ... The Acecnf.dll file has replaced the Wzcnf.dll file in Access 2007. 

Access 2007 may close unexpectedly when you try to change the Control Source property for a control that is on a report or on a form in Layout view  
In Microsoft Office Access 2007, when you try to change the Control Source property for a control on a report or on a form, Access 2007 may close unexpectedly.  

A 2007 Office program may stop responding when you try to print a document  
Describes a problem that may occur on a Windows Vista-based computer when you try to print a document from a 2007 Office program to a Dell printer. ... This problem may occur if the following conditions are true: You are running the 2007 Office program on a Windows Vista-based computer.  

You cannot open the front-end database when the back-end database is encrypted by using a password in Access 2007  
When you try to open a front-end database in Microsoft Office Access 2007 after you encrypt the back-end database by using a password, the front-end database does not open. ... In this situation, when you open the front-end database, Access 2007 tries to ...  

How to change the company name and user name in 2007 Office programs  
Describes how to change the company name and user name in 2007 Office programs. This article describes how to change the company name and the user name in 2007 Microsoft Office programs after you run the Setup program. ... To determine the program version information in 2007 Office programs ...  

How to disable hyperlink warning messages in 2007 Office programs  
Decsribes how to disable hyperlink warning messages in 2007 Office programs. This step-by-step article describes how to prevent 2007 Microsoft Office programs from displaying a warning message every time that you click a hyperlink in a 2007 Office program.  

Some Office 2003 proofing tools may not behave as expected in 2007 Office programs  
Describes behaviors that may occur because some Office 2003 proofing tools are incompatible with 2007 Office programs. ... This behavior may occur because some Office 2003 proofing tools are incompatible with 2007 Office programs. ... Language Access Excel Groove ...  

Installation fails, and you receive an error message when you try to install a 2007 Office suite or a 2007 Office program by double-clicking an .msi file: "Error 1713" or "MSI Error 41"  
Describes an issue that occurs because you cannot install the 2007 Office system or an individual 2007 Office program by running an .msi file that is provided in the 2007 Office suites. ... This issue occurs by design in the 2007 Office suites.  

The "Full Name" and "Organization" information is automatically populated when you install 2007 Office programs  
Describes an issue where the "Full Name" and "Organization" information is automatically populated when you install 2007 Office programs. ... This issue occurs because the registry stores information for the fields from an earlier installation of 2007 Office programs ...  

The data in a SharePoint list differs from the data in an Access 2007 table when you export the table from Access 2007 to a SharePoint list  
You export a table that contains a multivalued lookup field from Microsoft Office Access 2007 to a Microsoft Windows SharePoint list. ... Note When you export an Access 2007 table to a SharePoint list, you must have only one unique index on the ID field of the table.  

Setup program crashes when you try to install a 2007 Office suite on a 64-bit version of Windows Server 2003  
how to change the product key, click the following article number to view the article in the Microsoft Knowledge Base: 895456 How to change the product key for Office 2003 and for Office XP If you are trying to install an Original Equipment Manufacturer (OEM) version of a 2007 Office product ...  

How to install and to repair 2007 Office features  
Provides step-by-step instructions about how to install and repair 2007 Office programs and features. This article describes how to install 2007 Microsoft Office features. It also describes how to repair 2007 Office programs and features. 

The installation state of a shared Office component in an installed 2007 Office program is not reflected in the Setup program of a second installed 2007 Office program  
Describes an issue in which the components that are changed in the Setup program of an installed 2007 Office program may not be detected in the Setup program of a second installed 2007 Office program. ... You install two 2007 Office programs. ... program when you install the first 2007 Office program. 
Advertisement



Advertisement



Copyright © MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster