When Access queries won't update
Thursday, August 07, 2008 12:43 PM
Once you know why the query won't update, you can rethink the query's structure to obtain a more flexible query.
Microsoft Access
When Access queries won’t update
One of the most frequent questions I receive is about queries that won't update data.
When you try to update a value via a query, Access tells you that the query isn't "updateable". That's not a bug at work; Access is working exactly as it should.
When this happens, your only choice is to rethink the query's structure.
The first step is to figure out why the query isn't updateable. The following queries aren't updateable:
- Any query with a GROUP BY clause.
- Any query with a TRANSFORM clause.
- Any query that uses an aggregate function (SUM(), MAX(), COUNT(), and so on) in the SELECT clause.
- Any query that contains a DISTINCT predicate.
- Any query that contains a UNION operator.
- Any query that contains a subquery in the SELECT clause.
- Any SQL Pass-Through query.
- Any query based on three or more tables where there is a many-to-one-to-many relationship.
- Any query that's based on a read-only query.
Sometimes a query that should be updateable isn't. Usually, something outside the query is the influence:
- The underlying tables might be read-only. Or the database is opened in read-only mode.
- The user must have permission to update the underlying data.
- The record may be temporarily locked. Try again later.
Once you know why the query won't update, you can rethink the query's structure to obtain a more flexible query.
Microsoft Word
Include chapter numbers with page numbers in Word
Word's Chapter numbering styles not only number your chapter headings, they can also display the chapter number with the page number in a header or footer. Follow these steps:
- Click on the page where you want the first chapter title to appear.
- For Word 2002/2003, go to Format | Bullets And Numbering, click the Outline Numbered tab, and then click the Chapter option, as shown below.
In Word 2007, click the Multilevel List button in the Paragraph group on the Home tab and then click the Chapter option as shown below.
- Click the Center button to center your chapter title, if desired.
- Go to Insert | Page Numbers. (Click Page Numbers on the Insert tab in 2007.)
- Click Bottom Of Page.
- Click Right.
- Click the Format button. (In Word 2007, click Format Page Numbers.)
- Select the Include Chapter Number check box and then click OK twice.
Each time you come to a new chapter, follow step 2 to insert the chapter title. Word will automatically number the chapters for you and place the chapter number alongside the page number in the footer.
Microsoft Excel
Quickly control screen magnification in Excel
I never use the wheel on my mouse. I don't have a good reason; I just can't recall ever using it before. However, I recently discovered that the wheel increases and decreases the screen magnification in Excel. It's so simple to use:
- Hold down the Ctrl key.
- Move the wheel forward to zoom in.
- Move the wheel backward to zoom out.
While moving the wheel, watch the Zoom control on the Standard toolbar update accordingly.
Moving the wheel forward and backward scrolls the screen.
There are currently no comments for this post.