Microsoft Access
295 Stories
Hide the Ribbon programmatically in Access and Excel 2007
Techguide All of the Office 2007 applications sport the infamous Ribbon. Unfortunately for developers, the Ribbon object isn't as easy to control as its earlier counterpart, the command bar object.
Tags: Microsoft Office, Microsoft Corp., Mouse, Microsoft VBA, Microsoft Excel 2007, software, Microsoft Excel, Microsoft Word 2007, Microsoft Access, spreadsheet
Prevent Excel from turning fractions into dates
Techguide Excel can recognize cell entries as fractions if the appropriate fraction format is applied to the cell before data is entered.
Tags: Microsoft Office, Fraction, Cell, Printer, Microsoft Excel, Printing, Microsoft Corp., Microsoft PowerPoint, Microsoft Access, database table
Prevent duplicates when entering data into Excel
Techguide Duplicate values, when not valid entries, return erroneous summaries and totals. Here's what to do to prevent duplicates in a specific range using Excel's Validation feature.
Tags: Microsoft Office, MsgBox, Entry, Microsoft Excel 2007, Microsoft Excel, job, Microsoft Access, Microsoft Office, Microsoft Word, HTML
How to use the At and Ln indicators in Word's status bar
Techguide At and Ln are used in automating special format requirements. Here's what you need to know.
Tags: Microsoft Office, Form, Cell, Database, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, window, spreadsheet
Three tips for avoiding project estimating mistakes
Techguide Project cost oversights are incredibly common, but IT project managers can avoid estimating mistakes by being well prepared upfront. An expert offers some advice.
Tags: Project management, IT project management, Microsoft Corp., Microsoft SQL Server, Client, Project, project manager, Server, Microsoft SQL Server 2008, Hardware
Microsoft probing ActiveX attacks targeting Access feature
News Vulnerability in ActiveX control for feature in Microsoft Access is being used for targeted but limited attacks, Microsoft says.
Tags: Security, Business applications, Microsoft Corp., ActiveX Control, Attack, Microsoft Windows Server, IM, Microsoft Internet Explorer, trusted site, Microsoft Office
Microsoft Access 2010 new feature overview
Techguide Here are some of the new features you can expect to see in Access 2010, including a Web-ready format and an improved macro environment.
Tags: Microsoft Office, Microsoft Office, Row, Database, Cell, Field, Microsoft Corp., Data Type Gallery, Access 2010, Office Theme
Display hidden data in an Excel chart
Techguide By default, Excel displays only visible data in a chart. Consequently, if you hide worksheet data, Excel won't display that data in a chart.
Tags: Microsoft Office, Database, Option, Chart, Microsoft Corp., Tools Menu, Figure B, Microsoft Excel, Microsoft Word, technique
Quickly delete every nth row in Excel
Techguide Susan Harkins explains how to use AutoFilter to delete specific rows in a worksheet.
Tags: Microsoft Office, Row, Column, MsgBox, OrderID, Microsoft Word Override Word, Microsoft Corp., Goto, Clear, Microsoft Excel
Use VBA to find hidden Excel sheets
Techguide If you have hidden sheets in Excel, it might be helpful to programmatically manipulate those sheets.
Tags: Microsoft Office, Document, File, Backup, File System, ASCII, Microsoft VBA, Microsoft Excel, Microsoft Windows, Microsoft Access
Copy hundreds of rows of Excel formulas in three steps
Techguide Copying formulas in Excel is relatively simple, unless you need to copy down through dozens or even hundreds of cells. Here's a foolproof trick to get it done.
Tags: Microsoft Office, Cell, Real Estate, Survey, Microsoft Excel, toolbar, Microsoft Access, dialog box, window, Microsoft Visual Basic
10+ keyboard shortcuts for entering special characters in a Word document
Techguide If you prefer to enter special characters yourself on a case-by-case basis, it's handy to know a few keyboard shortcuts.
Tags: Microsoft Office, keyboard shortcut, keyboard, Microsoft Excel, Microsoft Access, dialog box, technique, window, Microsoft Office, Microsoft Word
10+ things that are broken in Access 2007
Techguide If you switch to Access 2007, you'll encounter more than just a radical new interface--some things are just plain broken. See what you can hotfix and what you'll have to live with.
Tags: Microsoft Office, Field, Slide, Microsoft Windows Vista, Tool, shortcut menu, Microsoft VBA, Microsoft PowerPoint, printer, toolbar
A quick method for counting Access records in a form
Techguide There are several ways to count the records in a form's recordset. In fact, Access forms display the record count by default.
Tags: Microsoft Office, Method, File, Tool, Tools Menu, Microsoft Excel 2007, File Menu, Microsoft Excel, Microsoft Access, dialog box
Use Access Office Links tool to convert a report to an Excel worksheet
Techguide Here's a quick and easy trick for getting your Access report data into Excel--organized just the way you want.
Tags: Microsoft Office, Option, Tool, check box, shortcut menu, Microsoft Excel, Microsoft Word 2007, Microsoft Access, Microsoft Office, Microsoft Word
