Search results

Perfect! Thx so much . . .

I created a Find Duplicate Qry. The results look like this: ID# Group Birth Grade 11111 300 12/11 4 11111 300 12/11 5 22222 400 10/10 1 22222 400 10/10 2 33333 500 09/09 6 33333 500 09/09 7 The qry looked for duplicates in the first three columns (ID#, Group, and Birth), so the results...

I tried copying the Input Mask from the table into the Input Mask of the report and that worked. You pointed me in the right direction. Thx

There is nothing in the Format property value in the table; there is only the Input Mask for a nine-digit zip below the Format property value. I tried pasting that in the property in the report but that didn't work. Another idea? Thx, Wm

The Compact and Repair worked without even having to import objects to a new database. Thanks so much!

I have a table in which the ZipCode column has the following Input mask to return a 9-digit zip code: 00000\-9999;;_ In the table the zipcode fields look like 12345-6789. In the qry based on the table the zipcode fields look the same. In the report based on the query, however, some of the...

I have a table in which I have been successfully deleting unwanted rows. However, there is one row that Access will not allow me to delete. When trying to delete it, I get an error message: "The Search Key was not found in any record." I am simply clicking on the left of the row to select the...

Thanks. I was able to find it in 2010 version. File/Options/Current Database

Access 2010/XP I have an Access file that is named: N&D Mailing12.mdb However, when I open it, the filename at the top of window is N&D Mailing11: Database (Access 200 file format). What is causing the "12" to change to "11" in the filename? Thanks. William

Thx. I discovered that the field name was being controlled by the Name & Caption function, found on the Fields Ribbon which appears once the table is opened. The field name will default to the name in this control unless the name of the field is changed in Data view. Changing the name in Data...

XP/2010 I have a table with a field name "distcode." I need to change it simply to all caps; DISTCODE. In Design Mode I type DISTCODE, save, and when I view the table the field name is all caps. But when I close the database and reopen the table the field name is back to all small letters...

No, there is not a password.

XP/Access 2010 I have an Access database with a table linked to an Excel file. When I try to update the linked table to a different Excel file, I get an error message that says "'file 1 $' is not a valid file name." Both the currently linked file and the one I want to update the link to have...

Yes, perfect, thanks. And thanks to Bob, too.

I have a query that returns a result like this: ID Status Date 30001 GFA 06/14/2011 30001 GFA 06/15/2011 30001 GFA 06/16/2011 ID (5 digits), Status (GFA), and Date are three fields. The three records are identical except for the date. What I need the query to do is to return only one...

Yes, that is exactly what I did. Thanks so much!

XP/2010 I'm new to 2010 and mostly I find it intuitive but am stumped about what I am seeing in the Navigation window. Left clicking on "All Access Objects" shows the following checked: Object Type All Access Objects Right Clicking shows the following selections: Category - Object Type Sort...

Thanks, Bob. I tried printing on a couple different printers and the same problem occurred. I went back to Access and discovered that the column setting was too narrow and after adjustment all was well. Thanks for helping me to narrow down the possibilities. Wm

XP/Access 2010 I have a report that does not print data on the right side of the page as I expect it to and can't figure out why. The page margins are set to narrow, or .25 inches. The page size is correct (8.5 x11 landscape). The data that doesn't print is a good .6 inches from the right page...

Thanks, everyone. The discussion enabled me to piece together the final formula that returned what was needed: IIf(Nz([Allocated])+(Nz([Carryover]))=0,0,(Nz([Approved])/(Nz([Allocated])+(Nz([Carryover]))))) Wm