Search results

Hey everyone! So I was wondering if there was a way to send an attachment in an email without having to use a specific path (i.e. each record has a different attachment). Below is my code: Private Sub SendEmail_Click() Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem...

So I tried that and couldn't get that to work. It works just fine if I type in a file path, similar to your example, but I can't get it to pull the article from that specific record. So below are a slim version of my db, front and back end. Maybe letting you play with it will get something...

I get "Error 438: Object doesn't support this property or method" Private Sub SendEmail_Click() Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Dim objAttach As Outlook.attachment Set olApp = Outlook.Application Set objMail = olApp.CreateItem(olMailItem)...

Thanks for the clarification. When I run the code, I get a "compile erorr: Invalid or unqualified reference." It then highlights the .Attachments in the code line Set objAttach = .Attachments.Add(Me.Article)

I have been mulling over this now since yesterday and I just can't seem to get it right heres the latest: Private Sub Command175_Click() Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem Dim objAttach As Outlook.Attachments Set olApp = Outlook.Application 'Create e-mail item Set...

Thanks for the info, so how would I have this module run on a "on-click" event?

Well, I almost have it working, I am still struggling with the attachment. This is my coding: Private Sub Command174_Click() Dim olapp As Outlook.Application Dim olNewMail As Outlook.MailItem Dim eTo, eSubject, eBody As String eTo = "" eSubject = "Article Please Read"...

Alright I got everything to work, just by adding & (duh :)) except for the pdf attachment.

pbaldy, thanks for your reply! I see what you are saying, perhaps you could provide some additional guidance. There are 6-7 fields that I want to send in the body of the email. How would I go about having all of these included in the email. For example: I want to send Title, AuthorLN...

Hello all, I have a searchable database that is set up in a similar fashion as Allen Browne's example found here. In the "search results" I then have a button that allows the user to view each form in a single view, using the following code: Private Sub Command151_Click() DoCmd.OpenForm...

Basically the exact same coding, I think it has to do with how its trying to grab the data from the record source. If I set the record source to just the article table, it will display the information fine, with the exception of the author information. But then I am missing the author...

Hey all! My forms for some reason aren't pulling the data saved in the db. Particularly the SearchArticle and EditArticle forms. Any guidance would be much appreciated, I have never made this "complex" of a db before so all of this is new to me :)

I attached the db and the backend data. The issue I am having is that the search form isn't pulling the data and I can't figure out why, which is why I was starting with the relationships.

Hello everyone still pretty new, but the community here has been so helpful! So heres my possible, but probable issue: I was hoping someone could help me with the structure of my database. This is what I have. What I am trying to accomplish is having the users be able to search, edit article...

Works perfect thank you so very much!

Wow thanks for your quick response, I'll take a look and see how it works out :)

Hello seems like there is an active community here so it seems like a good place for me to increase my knowledge of access :). My question is that I have a search form that is very similar to one created by Allen Browne found here. What I would like to do is then allow users to click on a...