Search results for query: *

Hi all Is there anyway I can use an action query to automatically delete duplicate records and leave one unique record remaining? The duplicate values are only in one field. I have tried to use the find duplicates wizard, but this displays both occurances of the duplicated record, and if...

Is there any way I can create a variable as a recordset, set the variable to an SQL statement and create a message box that displays a list of values returned by a field (or 2) in the SQL statement? Thanks in advanced. Nick

I am currently creating a project management database which will be stored on a shared drive. Each project that will be logged on the database will have it's own folder on the shared drive where any documents/spreadsheets etc related to that project will be stored. I have created a field in my...

Is there anyway of creating a relationship between tables that will find a close match rather than an exact match to take input errors into consideration? The filed that may contain input errors is an imported text file so validation is not an option. Any ideas? Thanks :-)

I have created 2 sub-forms on a form that are both based on cross-tab queries. The subforms are continouse forms with a sum for each field in the footer. However, only one sub-form correctly calculates the sum, the other says #NAME?. All control sources are spelt correctly because the form...

Occasionally when some of my databases are opened, I am shown the error message "Unrecognized Database Format", or "Not a Valid Bookmark." Any ideas how to stop this?