Search results

I was wondering if it is possible to add SentOnBehalfOfName to nikalopolis's code above so that I can set the "From" field with a specific email address. Thank you!

Thank you for your suggestion! Late binding worked for me! You are the best! Thank you so much for your help!

I have updated the code above!

This is the code that screen scrapes data from Refelction. It stops at "With Session". We check off "Refelction for IBM 7.0" reference to run this automation. We usually get the same error if it is not checked. I am thinking this reference is good for the 32-bit.

It's an Access database that captures and stores in a table using VB Code. I hope this answers your question. Thank you!

Good afternoon, I have a database that I use to screen scrape data from IBM Reflection Terminal to create a weekly report. It has been working great until our company decided to upgrade all the computers from 32-bit to 64-bit. Now, we get "Error 430: Class does not support Automation or does...

Hello, I tried Left$, VBA.Left but it did not work. It worked for form field names but not for table field name. I have found a work around by unchecking the reflection library before running your code above and checking it back after execution via vba code. It may not be an ideal way but it...

I just figured out that a reference Library called "Reflection for IBM 7.00 Object Library" is creating the issue. If I uncheck it, I don't get any error message. However, the other form that works with reflection stops working. So, I need that library checked. Please let me know if anyone has...

Hello, I am still getting the same Run-time error 3085 with the message "Undefined function 'Left' in expression." in the line below. GetCon = DCount("*", "tblYourTable", "Left([RDEFNumber]," & MainLen & ")='" & DetMain & "'") Else DetMain = Me.RDEFNumber MainLen = Len(DetMain) GetCon =...

Hello, Thank you again for your help. I have 2 little problems. First, in the actual database the RDEFNumber has 5 digits and the code above automatically chops the last digit with "-". I believe the code above is for 4 digit numbers. Is it possible not to limit this? the second, I am getting...

Thank you all for the quick responses!!

This is exactly what I was looking for. Thank you so much for your help. You are the best!

Hello, I am not sure if it is possible to implement this but I would like your input. We get request from client via a web based form which contains a unique ID number called RDEFNumber. When we process the request internally, we use this number to identify the request throughout the process...

I am from New York and trying to learn Access to use it at work. I have used sample databases from this forum to further my knowledge before but never posted anything. Thanks to this forum which has given me a lot in terms of learning the basics of VBA and database. Thank you