The MS Access FIND and REPLACE function works well on the active form (or page of a tabbed form) but I need it to search the other tabs (pages) which contain subforms with their respective tables. For example, Tab 1 (Companies) has Form 1, Table 1. Tab 2 (Contacts)has a subform and table 2. If I do a "FIND" on a Tab 1 field, it only searches Table 1. I want to search Table 2 also.
When the problem occurs "sporadic", it's my guess you have a text field with an embedded quote causing the trouble.
Just remove the single quotes and make the concatenation like:
"[textfield]" & chr(34)
Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…