Recent content by teel73

Thank you all for your suggestions and help. I was not able to solve the mystery of why the email draft gets returned undeliverable. However, when I changed the VBA from .Save to .Send the email sent successfully to the intended recipients. So with that being said, the function is working...

Thanks @Gasman for the quick response. And yes, my function is assigned to the BCC column.. The email draft is saved perfectly. When I open it up, I see all the names accurately in the BCC column. The issue is once I send the email. I receive an undeliverable that the email didn't...

I am having the weirdest issue and I don't know if its related to MS Access or MS Outlook. Here's the simple scenario. I have a sendEmail Function that works.. what I mean is the code sends the information from MS Access to Outlook and saves the item as a draft. That part works fine...

Hello, I've been wrecking my brain on this issue: I have a report that includes 4 sub-reports. Each individual report is based on a crosstab query that includes totals. The report previews correctly when I open it. If I choose to export the report manually to a .pdf, the pdf gets created...

BlueIshDan .. your example worked perfectly. Thanks so much.

Thank you BlueIshDan! I will try your example. I am using the activeX control Microsoft Web Browser in ms access 2003. The class property is Shell.Explorer.2.

I hope someone can assist me today. I had no luck with the forum yesterday. Maybe today will be better. I want to create a feature similar to the "find on this page" IE feature. On my form I have a web browser active x control, a text box called: [text_to_find] and I have a command button...

Hello, I hope someone can assist me with this. I am simply trying to find text on a Web Browser Control htm page. Using MS Access 2003, I have a form that includes the activeX Web Browser Control. On load of the form I initialize the web like below: Dim strURL As String...

I hope this is the right place for this question. My issue is simple to explain. When I copy data from Outlook or MS Word that contains bullets or other HTML formatted text, into MS Access text control, the HTML tags are displayed in the tables. The memo field in the table is set to Rich...

Hi, Is there a way to prevent special characters from being converted into symbols when copying and pasting text into a textbox control on a form? For example: If I copy and paste the below bullet item into my textbox, Access will convert the bullet into some weird symbol. How can I fix...

vbaInet, because having to relink 20 tables when the location of the source has moved is a pain and very time consuming.

I am trying to link to oracle tables using VBA. I can link to the oracle tables manually but when I try to use the TransferDatabase method it doesn't work. Here is my code: DoCmd.TransferDatabase acLink, "ODBC Database"...

thanks vbaInet, I will try your approach.

No vbaInet.. that's not correct. The scenario is like this: 1. Db A opens Db B 2. Db B runs code in Db B 3. Db B completes code procedure 4. Db A reports completion to that Db B procedure completed. Db A is a dashboard. The point of this is to have multiple procedures run parallel (at the...

I have 2 databases. When the procedure in database #2 is completed. I want to display a green control in database 1. They are 2 seperate databases, is there a way to trigger a function in one database from another database.