Search results

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.

Hello, I hope this can be achieved. I have 2 database files. database A has a button (buttonRun) that when clicked, it opens database B and runs the autoexec macro. In database A, there's a label control (lblRun) next to the buttonRun that has its back style property set to transparent...

Hopefully this is the right forum. From MS Access, I connect to Excel, I copy a chart then I would like to paste the chart into a Word document. I have been able to successfully connect and open both the Excel document and Word document from Access. I'm also successful with copying the Excel...

So if I do this: Sheets("Access_Data").Range("a3:D3").ClearContents That will get rid of the data in all rows down to the last row of data?

Hello, I am trying to connect to excel from Access database. Once I make the connection I want to delete data from a range on a specific sheet. There are 4 columns on the spreadsheet but i wouldn't know how many rows. So for example, A1:D50... but I may not know what the last row is. How...

I am trying to provide the user a custom search feature. They want to enter a keyword or phrase and search 3 memo fields and filter the form base on the records found. they also want to be able to search the whole phrase or any part of the phrase. I have a like expression for any part of the...