Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Find and replace

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Find and replace

Resolved · Low Priority · Version 2003

Reply Wed 21 Jan 2009, 14:08Delegate Hilary said...

Hilary has attended:
Access Intermediate course
Access Advanced course
Access Introduction course

Find and replace

I have a large databse with about 15,000 records. When I try to find and replace text in a table, how come it doesn't search the entire database and I have to run the find/replace quite a few times to change all?

For upcoming training course dates see: Pricing & availability

Reply Tue 27 Jan 2009, 16:49Trainer Rajeev said...

RE: find and replace

Dear Hilary

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

When you use find/replace normally it only replaces the data in the field where the cursor was blinking.

If you want the data on the entire table to be replaced then you need to click on the drop down arrow of Look In of the Replace dialog box. Choose the name of the table and then choose replace all.

Please be very careful of this option as it will replace the entire data in the table. Thgere are some cases where you might not want to replace every singe entry!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Access articles

· A Greater Understanding Of Your Business With Access Reports
· Access VBA Training Adds Power to your Databases
· How To Use The Analyze Table Tool In Access
· Be Top Of The Form With Access 2007
· Find Out All About Microsoft Access Report Sections

Please browse our web site to find out more about
access class ms training and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips