Reply to thread

Message: [QUOTE="Trent Shirley, post: 4818948"] I banged my head on the other problem for a LONG time. I made certain all connections were closing and that no variable names were the same between the two different forms and even went as far as forcing the current folder and form information back to correct information just in case but none of it made any difference. The person who attempted this fix before me spent hours on the phone with Microsoft who could not identify what the cause of the crash was. Interestingly, when the calendar form accessed an Access 97 database with DAO.DBEngine.35 it worked perfectly. When we converted the database to Access 2000 and changed the DAO reference to .36 as needed, the calendar form still worked correctly but the New Hire form that called it would crash. Unfortunately I cannot set the New Hire form to discard changes as it is part of the workflow that they go into that form, change data then call the calendar form that updates the database. When they exit the New Hire form it has to save the changes or they end up having to go in and modify the data twice. What I am attempting now is to incorporate all the functions from the custom appointment form directly into a page on the New Hire form so that no call to an external form is needed. It should be relatively straightforward. I already have set it up so that it can create the calendar entries by pressing a button in the New Hire form. It currently is using the default appointment form though so all of the additional form field data from the custom form is lost. I have figured out how to specify the form to use but am still trying to figure out how to pass the custom values into the custom form. I will puzzle it out through trial and error eventually. I have it writing the normal fields correctly like Subject, Categories, Location, Start Time, End Time, etc. I just have not yet had success passing over the the custom data like cost center info, contact info, division name, project number, etc. I have been scouting for sample code that passes custom fields to a custom appointment form. I have little experience with Outlook forms but I can read and adapt sample code pretty well. Once I figure out the little hangup with these custom fields and I am CERTAIN it is a simple error on my part, then I will have it all working. Right now I am using something like this. Set NewEntry =TheseItems.Add("IPM.Appointment.MAC Calendar Entry") (Where TheseItems is the path to the folder) NewEntry.Subject = strSubject NewEntry.Location = strLocation ........ For the custom fields I am trying this. NewEntry.userproperties("txtProjNumber") = ProjNum I am not certain if txtProjNumber above would refer to the display name or the field name of the field I want to insert the data into in the appointment form. ProjNum is the value that I want to insert. I have tried this in several different variations and all have failed so it could be the syntax is incorrect. I just do not know enough about it and have no reference material except what I can find on the web. [/QUOTE]

Verification