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
|Library not Registered||16||49|
|Importing and Dropping Table in Access||11||24|
|Problem with syntax with TransferDatabase||3||14|
|ensure than when a form opens it always starts with a NEW record||2||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!