Solved

In-cell editing bypasses Outlook form

Posted on 2001-06-26
20
192 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

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…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

691 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