Solved

In-cell editing bypasses Outlook form

Posted on 2001-06-26
20
189 Views
Last Modified: 2010-04-08
Is there any way to force the use of a form on a folder?
I have create a form for appoitment entries but when I person adds an entry using in-cell editing the form never gets used.  If not is there a way to associate some code with in-cell editing?
0
Comment
Question by:rkanter
  • 11
  • 8
20 Comments
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6229556
You can associate a form with a particular folder and make it the default.  

Right click on the folder in the folder list.  Go to Properties.  On the first property page there is a drop down that says "when posting to this folder use".  Select your custom form.  I tested this adding an item with in-cell editing and it worked just fine.

--PatriciaC
0
 

Author Comment

by:rkanter
ID: 6229586
I already have that set.  Again, if I create a new item using the new button it works fine.  If I just single click on a date then start typing the appointment subject the form never gets used.  I know this because the form requires the user to put in a category. With in cell editing there is no way to put one in.  If it matters I am using Outlook 2K.
0
 

Author Comment

by:rkanter
ID: 6229590
I already have that set.  Again, if I create a new item using the new button it works fine.  If I just single click on a date then start typing the appointment subject the form never gets used.  I know this because the form requires the user to put in a category. With in cell editing there is no way to put one in.  Also the default for 'show time as' is 'free' if you us in-cell editing and 'busy' if you use the form. If it matters I am using Outlook 2K.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Expert Comment

by:rjcpjc
ID: 6229591
I am using Outlook 2K as well and it works for me.  What view are you using?  You can add the category field to the view.  
0
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6229594
I'm confused by what you mean by Single Click on a date and then start typing the subject though.  
0
 

Author Comment

by:rkanter
ID: 6229601
We are using the day/week/month view.  Try using the day view, click on a time then just type "hello" and hit enter.  It will add an appoinment without running the form or the code behind the form.
0
 

Author Comment

by:rkanter
ID: 6229606
We are using the day/week/month view.  Try using the day view, click on a time then just type "hello" and hit enter.  It will add an appoinment without running the form or the code behind the form.
0
 

Author Comment

by:rkanter
ID: 6229610
By single clicking I meant just highlight a row on the daily calendar like 8:00 AM.  After that just start typing.
0
 

Author Comment

by:rkanter
ID: 6229612
By single clicking I meant just highlight a row on the daily calendar like 8:00 AM.  After that just start typing.
0
 

Author Comment

by:rkanter
ID: 6229615
By single clicking I meant just highlight a row on the daily calendar like 8:00 AM.  After that just start typing.
0
 

Author Comment

by:rkanter
ID: 6229616
By single clicking I meant just highlight a row on the daily calendar like 8:00 AM.  After that just start typing.
0
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6229625
I've tried that also and it seems to work just fine for me in Outlook 2000 and Outlook 2002.  I'll check at home though to make sure it works fine there too.  I did exactly as you suggested.  
0
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6229626
Where is your form published?
0
 

Author Comment

by:rkanter
ID: 6232100
The form is publish in the organization forms library.  Also the form works if the user select to create a new entry.  When you say it works on your machine, does it actually open the form when you create a new entry using in-cell editing?
0
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6232143
When I follow your instructions and single click on a half hour block of time and then just start typing, I can enter a subject.  Then when I click off and then double click on the appointment it opens with the custom form.  My form is published in the Calendar folder though.  That's the only difference.
0
 

Author Comment

by:rkanter
ID: 6232317
My problem is when you first use in-cell editing the form is not used allowing the user to put in invalid data. If the user then double clicks on the created item it will open the form.  Then if the user tries to close the form all the check will take place.  I need the checks to run when the data is first put in.
0
 
LVL 9

Accepted Solution

by:
rjcpjc earned 200 total points
ID: 6232340
Oh.  Well, since the form is never actually opening when you are first inputing the data, I don't think that there is any way around that problem.  All of your checks will run when the form opens, but you are not actually opening a form.  I don't think there is a way around this problem.
0
 

Author Comment

by:rkanter
ID: 6232424
Is there a way of executing code when in-cell editing is used?  I don't mind if I have to maintain two sets of code or forcing the use of a form.  I know some places allow you to disable in-cell editing but only in table view.
0
 
LVL 9

Expert Comment

by:rjcpjc
ID: 6232464
I don't think so.  If this is on a public folder, you could probably write something that would check when an item was added and then send an email to the originator if the item was not added correctly (with the proper syntax).  

This would also work if the calendar folder was stored on the Exchange Server.  

You'd use Exchange Event Scripting for that.  But I'm not sure.
0
 

Expert Comment

by:PandoraMod
ID: 6366332
rkanter, are you still having a problem? If so, please provide more information. If you solved your problem, please let us know how and then we can archive this.

Thanks,
PandoraMod
Moderator @ Experts Exchange
e-mail: pandoramod@experts-exchange.com
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question