Search results

Hi, Our Contacts database has around 4000 individual contacts (and growing), which have been pulled together from four or five seperately maintained databases. As such there are bound to be duplicate records. What would be a good way of querying the database to find duplicate entries (i.e...

I've placed a command button attached to a macro on the form to run the query.

My form has suddenly developed a problem with the Save command button. When clicked, it has started displaying the message "The command or action 'SaveRecord' isn't available now." I haven't made any changes to this command button, so what could have happened and what should I do to fix it?

Hi Bonb, I've created a form with a combo box to choose the client type, and think I've correctly used builder in the query to reference the selected client on the form, but can't get it to work. Could you talk me through with some more detail to see where I've gone wrong?

Hello, I'm trying to get a report based on a parameter query to work. The report is to view all contacts on the database who have been assigned with a particular "Contact Type" - i.e. client, supplier, volunter etc. These Contact Types are themselves sourced from a LookUp table. Unfortunately...

Thanks Bob, works a treat!

The main form of our contacts database has its source in a query which places all contacts in alphabetical order by surname. How do I get the query to sort by surname and then by first name? Also, how can I get the query to run each time a new contact is added so they are put into alphabetical...

I do have a save button on the form - does the code go into the On Click properties?

Where would I put this control?

Hi Colin, The form's properties are already set to do this.

Our Contacts database main form displays all our contacts based on a query which is simply putting all the contacts in the tablke into alphabetical order by surname. I've just noticed that any new contacts that are input are added to the end of the list as they are displayed on the form, despite...

Hi guys, I regularly export the main table in our database to an excel spreadsheet, to provide an additional level of data back-up. (Using File/Export) I was wondering if there is a way of automating this process, either through a command button on a form, or by linking it with shutting the...

Hi, The database I've inherited has a primary key autonumber set up which is randomly generating numbers. It also has another field which has yet to be used, of a clients reference number. I thought it would make sense to use the reference number field as the primary key, as it seems redundant...

Hi Everyone, I've inherited the task of managing a fairly basic contacts database used by the charity I work for. I say basic meaning in terms of its design - the great bulk of our 3500+ client records are stored in a single table made up of approximately 95 different fields. Now I've been...

Thanks Neil, I've done this and am able to select the relevant value from the combo box on the form, but it isn't saving the data back to the table? Sometimes I feel like smacking my head with the palm of my hand and making a "d'oh!" sound!

I'm sure this is a rookie mistake, but I've not been able to figure it out. I recently had to make an alteration to our contacts database to force the selection of one of five values from a drop-down list, as our users were inputting address data with incorrect spellings, or incorrect names...

I see what you mean. What I really want is for users to be able to search for a particular record, say the name "Harris", and if the users click "Next Record" when searching even though "Harris" has been found (i.e. the user clicked "Next Record" in error or didn't notice the record had been...

So simple! Thanks!

Is there a way of getting the Search facility in Access to repeatedly cycle through all records until the user closes the Search window, rather than as it appears to be doing in our Contacts database at the moment - searching once through all the records then stopping?

Hi Everyone, How can I set our contacts database, to automatically default all new contacts that are created to have a "Yes" (or tick) selected against a "Receive Newsletter" field, rather than having to remember to manually tick the newsletter box after a new contact is created?