PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Adjusting a Button Control to register a different number||12||41|
|Email Excel WB by selecting name from a dropdown list to Outlook.||5||42|
|updating subform when combobox is updated||4||15|
|Word 2016 (32-Bit) - Hangs when attempting to select an existing list for Mailings||13||25|
Join the community of 500,000 technology professionals and ask your questions.