LeoK
Last Activity: Apr 11 '08, 01:00 AM
Joined: Mar 23 '08
Location:
-
LeoK replied to Error Application-defined or object-defined error 287 when opening outlook in accessin AccessHey I finally realize what was wrong, for some reason, any code that attempts to access outlook from access will get the some error. I actually have to open up outlook when I first start window, then I can send the email without the error, I didn't notice this becuase I hadn't shut down my computer for about a month, only hibernated. -
LeoK started a topic Error Application-defined or object-defined error 287 when opening outlook in accessin AccessError Application-defined or object-defined error 287 when opening outlook in access
After finally completing my database I was ready to transfer it to our client, but when the access database was opened, everything works great, except for the SEND_EMAIL part, whenever any code that has to do with opening outlook I get a error, [Error Application-defined, or Object-defined error / 287]. I panic, so I try it on another computer and the same thing happened. After further investigation I realize that on both machine outlook wasn't set... -
Hey just want to thank you Stewart, I thought it through and it seems that the club will rarely have an event with more then one venue, so I decided not to add complication. Our teacher said in the beginning that we should stay away from project that requires emailing, and that we were not expected to use any VBA, but I decided to just learn VBA and use it. I think it has been successful and a bit fun, and people like you has helped me a lot so ...Leave a comment:
-
Thanks for the reply, but I am getting a compile error "type mismatch" that highlights the .RecordSource, any idea, thanksLeave a comment:
-
Hey Thankyou very much, I have been pulling my hair out because of this. by the way the SUBFRM_VENUE and the field name is VENUE_ADDRESS. I did manage to get the venue to show up in the email, but it only show the first venue, so if an event has more then one venue only the first one shown up.Leave a comment:
-
what JConsulting said is true, it would just be easier to design a form, with the ID number as a combo box. You can add all the fields that relates to that ID number in the same form. If you do this in the Form wizard on Access 2003 the code for that ID combo is written for you, so that whenever you click on anything on the list the other fields relating to that combo box will automatically update.
The code should look something like this,...Leave a comment:
-
Open outlook in access with body auto fill from form
Hey I am so close from finishing this database I just need one more issue solve thanks. Basically I have a code within a form that opens up outlook and fill in the body of the email, among other informations, with event infos, but I need it to also fill in the Venue. The problems is the venue exist in the form as a subform, and I don't know how to reference it in the code. Here is the code I hope you can help, I ran into so much problems trying to... -
Link Contact table from Outlook to Access
Hello everyone, currently I am building a database for a club in my school. I am at the point where I want to integrate Access with Outlook, this part of the development process has been giving me a lot of problems. I am novice user of Access. I want to basically add all of the emails from a field called EMAIL_ADDRESS from a tabled called MEMBERS to outlooks Contacts list. I also want the contact list to be dynamic meaning if a member is deleted/added...
No activity results to display
Leave a comment: