Solved

In-cell editing bypasses Outlook form

Posted on 2001-06-26
20
185 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
Read this checklist to learn more about the 15 things you should never include in an email signature.
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
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: …

772 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