Search results

There are only two (2) columns.

I want to retrieve values in one table (column 1) and write the content into another table (horizontally). I currently do not have any workable code.

No, I want all contents from the first column saved into variables.

Thank you ! ! ! . . . but "lRecCount" returns zero records

Can someone provide me an example on VBA code that will allow me to read an existing table in MS Access (with 2 columns) and store the first column contents into variables ?

How can I make [A1] an acceptable varible that will be allowed with the below "Forms" statement ? That is make [A1] change to [A2], [A3 , [A4], [A5], [A6] . . . etc. [Forms]![Form_Questions]![A1] = varX I tried the statement below, but it did not work. Counter = 1 Do While Counter <= 25...

George, I'm not sure. Also, how would I set up Outlook globally (via VBA) ?

I figured out what is happening with my delayed e-mails. It is due to Microsoft Outlook's "Delay Delivery" option. You can locate it by opening an e-mail, click on "Options", then click on "Delay Delivery". Locate the "Delivery options" section and uncheck the "Do not deliver before" box. When I...

GPGeorge, This even happens when sending to myself. Any suggestions ?

Here are my references.

Tom, I'm running Outlook 2016. My problem is that my e-mail sent by the MS Access SendObject command is arriving days latter. I had this problem before, but I can't remember how I fixed it. I vaguely remember selecting an additional reference (from the Object Library). I can't remember which DB...

What Microsoft Access references (in the Object Library) are needed to send e-mails (Outlook, Gmail, Yahoo . . . etc.) with the SendObject command ?

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 ! ! !