Updating an access database
The Find and Replace dialog box will appear as shown in Figure 3-07 in your book and you will be able to type in the value that you want to locate.To process the request, click on the Find Next button.By commenting, you are accepting the IBM commenting guidelines and the DISQUS terms of service.Add Update Delete Retrieve String Record Connection Sql Server Website Dataset Bacup and Restore Email Edit User Programming Programming Interview Questions Beginner Asp. Top of the Page When you locate records using the Find button, all of the records in your table will still be displayed.There will be times that you will only want to see the records that match the criteria that you are searching for.In this case, you can use the Filter option instead of the Find option.
Actually I am trying to update the Bot table MFG with the Big table MFG when Big. In this example, we've selected the Big and Bot tables.If the value exists in the table, Access will move to that record.At this point you can close the Find and Replace dialog box or click on the Find Next button again to find the next record in the table that contains the same search value.Another feature of the Find and Replace dialog box is the ability to replace the located or found values with an alternate value.
To perform this, click on the Replace Tab in the dialog box and put the Find and Replace values in the appropriate boxes.
Next, build the query like the one below: This query will update the MFG field in the Bot table with the value in the MFG field in the Big table when the PART values match.