search for books and compare prices
Tables of Contents for Troubleshooting Microsoft Access 2002
Chapter/Section Title
Page #
Page Count
About this book
xiii
Troubleshooting tips
xv
Charts and graphs
2
10
Quick fixes Fixing query parameters • Fixing sample data • Resizing a chart
2
2
I made changes to a chart in Microsoft Graph, but they were not retained
4
2
The legend labels on my chart don't say what I want
6
2
The columns in my chart aren't in the order I want
8
2
I see an error message and my chart appears blank
10
2
Controls, placing and formatting
12
10
Quick fixes Changing properties in more than one control • Changing the type of control • Adding an & to a command button title • Revealing a hidden command button
13
1
My option group doesn't work the way it should
14
2
I'm having trouble creating, organizing, and sizing a tab control
16
2
I can't make an image fit on a command button
18
2
I get an error message when I click a hyperlink
20
2
Controls, viewing data
22
118
Quick fixes Column widths • Fixing date formats • Automatically resizing text boxes
23
1
The order of the rows in my list box or combo box isn't right
24
2
I see #Error or #Name? in a field instead of a value
26
2
I don't get the right results with conditional formatting
28
2
I need to deal with null values in a form or report
30
2
The text box control labels are in the way
32
1
The items in my list box or combo box take too long to appear
33
107
Forms, viewing data
140
10
Quick fixes Setting properties in Form view • Don't print buttons • Setting tab order • Wrong records in a text box • Data entry in multiline text boxes
140
2
I'm having trouble entering data in my combo box or list box
142
2
My subform doesn't print the way I want
144
2
My form is blank where there should be data
146
2
My subform doesn't show the data I expected
148
2
Importing and linking
150
10
Quick fixes Linked spreadsheet errors • Finding linked tables • Filtering linked records • Importing from Microsoft Works
150
2
I copied a linked table, but it is linked and not in my database
152
2
I'm having trouble with an imported table
154
2
I get errors when I import a spreadsheet or text file to my Access database
156
2
I get errors when I try to append a spreadsheet or text file to an Access table
158
2
Macros
160
10
Quick fixes Documenting macros • Turning off macro warnings • Getting the SendKeys action to work • Fixing AutoKeys macro
160
2
I can't put a multiline message in a message box
162
2
I get a ``Can't find the macro'' error message
164
2
My SetValue macro runs at the wrong time
166
2
I see an error message when I try to use a form with converted macros
168
2
Menus
170
12
Quick fixes Hiding menus • Missing menu commands • Missing macro messages
170
2
I can't get my built-in menu bars back the way they were
172
2
Some of the built-in menus or commands aren't displayed
174
2
My custom menus don't show up when I open my form
176
2
My shortcut menus aren't right
178
2
I can't change the name of the shortcut menu I created
180
2
Pictures and OLE objects
182
10
Quick fixes OLE objects and foreign file formats • Replacing an object with an image • Changing the color display • Keeping an image from being edited
182
2
My linked image doesn't show the changes I made
184
2
My calendar control doesn't look right and shows the wrong date
186
2
I can't edit my OLE object
188
2
A picture is distorted and doesn't fit the frame
190
2
Queries, action
192
12
Quick fixes Unexpected parameter prompts • Type mismatch messages • Trouble updating primary key fields
192
2
My update query causes errors
194
2
I can't get my append query to work right
196
2
Using a find duplicates query to delete duplicate records didn't work
198
2
I'm not getting the results I need with a parameter query
200
2
I see a strange error message when I run my make-table query
202
2
Queries, calculations
204
10
Quick fixes Correcting type mismatches • Grouping records in a field • Retaining currency formatting • Misplaced functions
204
2
I keep getting blanks instead of real values
206
2
I get a strange result when I use the First function in a query
208
2
My query shows the wrong calculation results when I try to summarize data
210
2
My autolookup query isn't working
212
2
Queries, crosstab
214
10
Quick fixes Mistaken field names • Too many columns • Parameter settings in crosstab queries • Empty columns
214
2
Saving a crosstab query as a report doesn't work
216
2
I'm having trouble grouping numbers in rows in my crosstab query
218
2
I'm having trouble grouping and arranging columns in my crosstab query
220
2
I can't sort or specify column headings in a crosstab query the way I want
222
2
Queries, selection criteria
224
12
Quick fixes If you're prompted for a parameter when you run a select query • You need to treat wildcards and operators differently in a criterion • You need to set the Unique Records property of the query to Yes • You need to select which records you want to see
224
2
I get the wrong records when I combine criteria
226
2
What's up with wildcard characters?
228
2
I see too many records in the query results
230
2
My query doesn't return as many records as I expected
232
2
I want to see only a few top values in each group of records
234
2
Queries, simple select
236
12
Quick fixes Keeping duplicate values at bay • Missing input tables • Correcting column names
237
1
I don't see all the records from one of the tables in my query
238
2
The records aren't in the order I wanted
240
2
The query doesn't display the number of columns I expected
242
2
My query takes too long to return the results
244
2
I can't sort on a lookup field in my query
246
2
Relationships
248
10
Quick fixes Edit relationships • Identify relationships
249
1
I get an error message about ambiguous outer joins
250
2
Access won't let me edit or delete a record
252
2
I can't build the relationship I want in a query
254
2
I can't enforce referential integrity on a relationship
256
2
Reports, creating
258
10
Quick fixes Calculating running sums • Sorting on absent fields • My report is too wide
259
1
I can't group records in a report the way I want
260
2
I can't keep duplicate data out of my report
262
2
My report snapshot isn't working right
264
2
I can't calculate averages without including the zero values
266
2
Reports, previewing and printing
268
12
Quick fixes The Keep Together properties are not set correctly • A report with missing data • The report's title control
268
2
When I print my report, every other page is blank
270
2
Some of my mailing labels are blank
272
2
My multiple-column report isn't printing right
274
2
I'm trying to print only selected labels, but Access won't let me
276
4
Sorting
280
10
Quick fixes Sorting with the asterisk • Sorting column order • Sorting by absent field
280
2
My records aren't in the order I want when I sort by more than one field
282
2
I'm having trouble sorting on lookup and memo fields
284
2
I can't sort a text field in numeric order
286
2
I can't sort grouped records in a report the way I want
288
2
Table design
290
10
Quick fixes Deleting a primary key • Excluding null values from tables
291
1
I get an error message after designating a primary key
292
2
I need to control errors in my data
294
2
Too many records have the same value in the index
296
2
I don't know which data types and properties to choose in a new table
298
2
Toolbars
300
11
Quick fixes Hide a toolbar • Dock a toolbar • Toolbar name not in list
300
2
I can't get my built-in toolbars back the way they were
302
2
Some of the built-in buttons aren't displayed
304
2
I can't create the custom toolbar I need
306
2
When I paste an image on a button, it doesn't look right
308
3
Glossary
311
8
Quick fix index
319
4
Index
323
<