Hello,

I have Outlook 2003. I have a Message form named Equipment.oft and an
Appointment form named Alarm.oft.

I need to create a button on my Message form which will take me to the
Appointment form. Can anyone help me with the code on this.

Thanks in advance!

As you describe it, that's not possible. Code runs only on published forms, not on .oft files. If you change your mind and decide to publish the form, though, take a look at the Application.CreateItemFromTemplate method, which is what you'd use to create a new item from an .oft file.

FYI, there is a newsgroup specifically for Outlook forms issues "down the hall" at microsoft.public.outlook.program_forms or, via web interface, at http://www.microsoft.com/office/comm...rogram_f orms

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

"LDMueller" wrote in message ...
Hello,

I have Outlook 2003. I have a Message form named Equipment.oft and an
Appointment form named Alarm.oft.

I need to create a button on my Message form which will take me to the
Appointment form. Can anyone help me with the code on this.

Thanks in advance!

Sorry I didn't describe it better. I did publish my forms so your suggestion
worked perfectly.

Would you by chance have any code for when the second form opens (e.g. the
Appointment form) so that it sets the focus to the "Start Time" field.

Thanks Sue!

"Sue Mosher [MVP-Outlook]" wrote:

As you describe it, that's not possible. Code runs only on published forms, not on .oft files. If you change your mind and decide to publish the form, though, take a look at the Application.CreateItemFromTemplate method, which is what you'd use to create a new item from an .oft file.

FYI, there is a newsgroup specifically for Outlook forms issues "down the hall" at microsoft.public.outlook.program_forms or, via web interface, at http://www.microsoft.com/office/comm...rogram_f orms

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

"LDMueller" wrote in message ...
Hello,

I have Outlook 2003. I have a Message form named Equipment.oft and an
Appointment form named Alarm.oft.

I need to create a button on my Message form which will take me to the
Appointment form. Can anyone help me with the code on this.

Thanks in advance!

That's possible only on custom pages, unless you want to use a SendKeys kludge (which I personally avoid).

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

"LDMueller" wrote in message ...
Sorry I didn't describe it better. I did publish my forms so your suggestion
worked perfectly.

Would you by chance have any code for when the second form opens (e.g. the
Appointment form) so that it sets the focus to the "Start Time" field.

Thanks Sue!

"Sue Mosher [MVP-Outlook]" wrote:

As you describe it, that's not possible. Code runs only on published forms, not on .oft files. If you change your mind and decide to publish the form, though, take a look at the Application.CreateItemFromTemplate method, which is what you'd use to create a new item from an .oft file.


"LDMueller" wrote in message ...
Hello,

I have Outlook 2003. I have a Message form named Equipment.oft and an
Appointment form named Alarm.oft.

I need to create a button on my Message form which will take me to the
Appointment form. Can anyone help me with the code on this.

Thanks in advance!

Okay, then could I somehow code a command button on the form
"IPM.Appointment.IS Notification" so that it copies the data from it's field
named "Needed Date" to a field on another form named "Start Time" which is on
the form named "IPM.Note.IS Equipment Reserve"? Or would this be the same
situation.

Basically what I'm trying to do is this. I have a form named "Equipment
Request" (based off a Message) which has numerous check boxes and drop down
fields. The user completes the form and completes a "needed date" and
"needed time" field on this form. The form is emailed to an IS mailbox and
everyone in the IS department has access to this mailbox.

Once the form arrives in the inbox, someone from IS will look over the form
and reserve some of the equipment and save the form. This provides us with
all our information. What I need is a way of also getting the "needed date"
and "needed time" on everyone calendar without having to manually complete
another form.

Any suggestions would be greatly appreciated.

Thanks!

"Sue Mosher [MVP-Outlook]" wrote:

That's possible only on custom pages, unless you want to use a SendKeys kludge (which I personally avoid).

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

"LDMueller" wrote in message ...
Sorry I didn't describe it better. I did publish my forms so your suggestion
worked perfectly.

Would you by chance have any code for when the second form opens (e.g. the
Appointment form) so that it sets the focus to the "Start Time" field.

Thanks Sue!

"Sue Mosher [MVP-Outlook]" wrote:

As you describe it, that's not possible. Code runs only on published forms, not on .oft files. If you change your mind and decide to publish the form, though, take a look at the Application.CreateItemFromTemplate method, which is what you'd use to create a new item from an .oft file.


"LDMueller" wrote in message ...
Hello,

I have Outlook 2003. I have a Message form named Equipment.oft and an
Appointment form named Alarm.oft.

I need to create a button on my Message form which will take me to the
Appointment form. Can anyone help me with the code on this.

Thanks in advance!

Certainly, if you have published forms, you can put code behind them to copy property values from one item to another. (Terminology alert: The form contains no data. So you are not coping to a field on another form, but to a field on another *item.*)

This would be the easiest approach: If you already have code that creates a new item from a published form, that code should be returning an object variable representing the newly created item. So you would use that object and set its properties to the desired values from the original item, i.e. the item where the code is running. See http://www.outlookcode.com/article.aspx?ID=38 if you need help with property syntax.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

"LDMueller" wrote in message ...
Okay, then could I somehow code a command button on the form
"IPM.Appointment.IS Notification" so that it copies the data from it's field
named "Needed Date" to a field on another form named "Start Time" which is on
the form named "IPM.Note.IS Equipment Reserve"? Or would this be the same
situation.

Basically what I'm trying to do is this. I have a form named "Equipment
Request" (based off a Message) which has numerous check boxes and drop down
fields. The user completes the form and completes a "needed date" and
"needed time" field on this form. The form is emailed to an IS mailbox and
everyone in the IS department has access to this mailbox.

Once the form arrives in the inbox, someone from IS will look over the form
and reserve some of the equipment and save the form. This provides us with
all our information. What I need is a way of also getting the "needed date"
and "needed time" on everyone calendar without having to manually complete
another form.

Any suggestions would be greatly appreciated.

Thanks!

"Sue Mosher [MVP-Outlook]" wrote:

That's possible only on custom pages, unless you want to use a SendKeys kludge (which I personally avoid).

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/article.aspx?id=54

"LDMueller" wrote in message ...
Sorry I didn't describe it better. I did publish my forms so your suggestion
worked perfectly.

Would you by chance have any code for when the second form opens (e.g. the
Appointment form) so that it sets the focus to the "Start Time" field.

Thanks Sue!

"Sue Mosher [MVP-Outlook]" wrote:

As you describe it, that's not possible. Code runs only on published forms, not on .oft files. If you change your mind and decide to publish the form, though, take a look at the Application.CreateItemFromTemplate method, which is what you'd use to create a new item from an .oft file.


"LDMueller" wrote in message ...
Hello,

I have Outlook 2003. I have a Message form named Equipment.oft and an
Appointment form named Alarm.oft.

I need to create a button on my Message form which will take me to the
Appointment form. Can anyone help me with the code on this.

Thanks in advance!