?
Solved

In-cell editing bypasses Outlook form

Posted on 2001-06-26
20
Medium Priority
?
193 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 800 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
This article describes how to import Lotus Notes Contacts into Outlook 2016, 2013, 2010 and 2007 etc. with a few manual steps. You can easily export and migrate Lotus Notes contacts into Microsoft Outlook without having to use any third party tools.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

800 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