Search results

:(I am working with Access 2010 and all of a sudden I get this error message when I click on an Event procedure to edit the code "Microsoft Access has stopped working." I have the protection code turned on with a password. Since I cannot turn the password off and cannot get the code, I can't...

I am in a subform and trying to put the selected record's workorderID into another form (frmworkorder) and then populate all the the related text boxes in the frmworkorder. The workorderID is put into a combo box, this works, but the combo box after update "event procedure" does not run. I can...

How can I open Paint using vba or macros? I want to click on the bound object frame and have Paint open up so the user can make a drawing. I also want to double click a drawing in the bound object frame and have Paint open up in the edit mode. Thanks for any help. Richard Iam still looking...

I have created Outlooks Tasks and Appointments in Access 2007. It worked great. Then I had to replace the computer with a new one and some of the Outlook dll libraries were missing. Old computer was running Window XP & Access 2007 New computer running Windows 7 pro & Access 2007 My customers...

Thanks Chris I will be working on this Monday or tuesday. Have a great week. Richard

Chris, I am having a problem with selecting then center, underline and hanging indent. I look and tried a lot of things with the link you provided. And :confused: because nothing is working. I have been given this code and trying to correct it so the Word document does not have to be edited...

Well I have put this in my code in various places and I do not think I am doing it right because The paragraph does not format Distribute. WordApp.Selection.ParagraphFormat.Alignment = wdAlignParagraphDistribute I will be reading more on the link you gave me because now I have underline and...

Thanks again, I put all this into my favorites and it will inhance my programming experience. Richard

Thanks stopher for the help on distribute. Is there any site on the web or a book that shows all the wordapp.selections? Have a great day, Richard

Hi everyone, I have the below code working to build a Word document from Access. It works, but I want to justify/distribute the text in the Do loop. I have not found an way to do it on the WEB or the forum. I figure that the code would be like word.App.selection.distribute = true/false. Can...

Pulling my hair out!:confused: I am trying to inport Outlook 2007 Contact list into Access 2007 table. Running debug, the code stops at the RED text rs("olfirstname") = .FirstName. I get this error message "Invalid or unqualified reference". I find a lot of Access contacts to Outlook on the...

spikepl, Played with the chr(34) some more and It works :D Thanks for helping me and now I can relax from the panic mode. Richard

Im not sure what you mean. Set objAppointmentItem = objAppointment.Items.Find("[Subject]=" & Forms!frmShowAllOutlookTasks_fromPopup_1!OLSubject) where do I place chr(34)?

The message I got from Immediate window is: [Subject]=It is almost done first

spikepl, the print.debug just tells me that I get the OLSubject but the Set objAppointmentItem = Nothing. Still lost Richard M

:mad: Pulling my hair out trying to update an appointment in Outlook. The code I am using stops running at this line. Set objAppointmentItem = objAppointment.Items.Find("[Subject]=" & Forms!frmShowAllOutlookTasks_fromPopup_1!OLSubject) this line and gives me an error code of -2147352567...

Do you have an exchange server?

My problem was setting a task in my Outlook not another user.

It should, it worked in MS 2000 database running in 2007 but you have to have the correct references. Good luck. Richard

unixkid, try this. It gets the data from the form. Code is for MS 2007 Function fncAddOutlookTask() Dim strAnsDate As String Dim strAnsTime As String Dim OutlookApp As Outlook.Application Dim OutlookTask As Outlook.TaskItem strAnsDate =...