Search results

I am not sure if linking will work for what I need to do. I do not need to use the data in the excel file. The data that is exported form the access record into the excel template is used as a template for analysis purposes. The record in access contains project details that will be exported...

So I guess the best way to explain it without exhaustive details is I need to export data to excel then attach that workbook back to the access record it was exported from....hope that makes sense... vba code in access behind a button on a form automates the export of the record to a specific...

Hi, I have some vba code that exports the results of a query to a specific excel workbook. Code in this workbook then takes the exported data to "fill out" areas in the workbook. My staff will then use this workbook to perform analysis on a project. After they have completed the analysis...

Ok so here is the solution I have found to remove the duplicate address from the "TO" field in outlook, as well as the "#" and "mailto:": OutLook = HyperlinkPart(MailList("EmailAddress"), acAddress) OutLook = Right([OutLook],Len([OutLook])-7) MyMail.To = OutLook Thanks for the help, and if...

Thank you Spikepl! So my first update, using the link you posted, is I changed: MyMail.To = MailList.Fields("EmailAddress") to MyMail.To = HyperlinkPart(MailList("EmailAddress"), acAddress) Results: mailto:admin@blahblah So it removed the 2nd address and the "#" but I still have the...

Hello, I have vba code set up to automate a query output to email with outlook. I am having issues with the "TO" field. I have tried different types of code, such as the following: 1) MyMail.To = MailList.Fields("EmailAddress") 2) MyMail.To = MailList.Fields("EmailAddress") & ";" Both of...

Thank you for the quick reply Frothingslosh, I will check that out and report back with my results!

Hello, I am using ms access 2007 and outlook 2010. I have vba set up to send the output of a query to the body of an email. Is there a way I can specify which address to send this email FROM using ms access vba? This is going to be a split database, and every computer has different email...

Hello I have a question about the best way to go about linking an excel workbook to an ms access table? I have researched hyperlinks and attachments and ole objects and I am not sure what is the best option. I believe hyperlinks will be best, because the attachments will bloat the database...

Yes that is the path I was hoping to take so I am glad I understood your previous advice correctly! I think I figured out the issue, I kept the expression above and joined the 2 tables in my query as such INNER JOIN tblMedia ON tblSampleNew.MediaType = tblMedia.ID I assumed this...

I am thinking that I need to be more specific and not just use "ID=" & tblSampleNew.MediaType. I am thinking that since the values for this field are attached to the tblMedia values, that I should specify the column to reference? Something like "ID="tblSampleNew.MediaTypes.Column(1)? I am...

Ok so I tried out this code a bunch of different ways. I realized that the first problem I was having was that I was adding the calculation to the query, but I wasn't deleting the original "Media" column so the query wasn't running correctly. I deleted the "Media" column and instead, added the...

Thank you for the tip Isskint, I will try that out and hopefully that will solve this issue

Hello, I am using MS Access and Excel 2007. I have a query that I need to export to a specific sheet in excel, and the vba is working great and doing what it should. Problem is, some of the data is being exported as numeric, not as text which is what I need. I have several tables related to...