Recent content by lhooker

The below DCount statement gives me the number of duplicates records from the "Query_Find_Duplicates_For_Gift_Totals" query. How can I get the names of the duplicate records from the below DCount statement? DCount(" Gift_Totals.[Survey_Taker_Last_Name]", "Query_Find_Duplicates_For_Gift_Totals")

2016

How can I eliminate the Microsoft Outlook email safety message when sending an email using "SendObject" ? Attached is the image of the message.

That gave me the count. Thanks ! ! !

Yes, but how can I determine this from a query called by a form button or VBA ?

To determine which process to take. By the way, both results will be on forms.

Is it possible to retrieve the count of duplicate records (produced from the query below) ? I want to see if there are any duplicate records, if so, then show them on a form. If no duplicate records, then display a report with the single record. In (SELECT [First_Name] FROM [Location_Totals] As...

It appears that when I repaired Outlook (via "File"/"Account Settings"/"Repair") fixed the problem. Thanks for all the help given ! ! !

I have no problems receiving or sending emails. So, how can I correct this ?

I also have the below reference box checked in "Tools" . . . References . . . Microsoft Outlook 16.0 Object Library

Here ya

What does the below error mean and do I fix it ? Runtime Error 2147467259 (80004005) It fails on ==> Set M = O.CreateItem(olMailItem) ' Remember to add REFERENCE to Microsoft Outlook Object Library Dim Msg As String ' Msg = "Dear " & Firstname & ",<P> & _ ' "Your statement balance as...

I have a macro that's giving me a 3211 error. How can I find out which form, table, or query in the macro is open ?

I want to automatically advance to the next textbox after entering a numeric value.

What is needed to move to the next textbox automatically without tabbing ? Current settings are as follows for all textboxes. Tab Index is 12 Tab Index is 13 Tab Index is 14 Tab Index is 15 Tab Index is 16 Tab Index is 17 Tab Index is 18 Tab Index is 19 Tab Index is 20 Tab Stop Yes Auto Tab...