Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
This has been working fine for years but a few months back, I intermittently get these three popups for each lookup (I click on OK or Cancel on each popup and the data is still retrieved from the database):How do I stop these popups? Thanks.
strDatabaseName = "C:\AccessReferences\Patient Information.mdb" strSQL = "SELECT DISTINCT * FROM Contacts WHERE (([Contacts].[FirstName] & "" "" & [Contacts].[LastName])=""" & strName & """) OR ((Contacts.CompanyName)=""" & strName & """)" With ActiveDocument.MailMerge.OpenDataSource strDatabaseName, wdOpenFormatText, False, True, True ', , , , , , , , strSQL GetFaxNumber = ActiveDocument.MailMerge.DataSource.DataFields("FaxNumber").Value
Join the community of 500,000 technology professionals and ask your questions.