Solved

In-cell editing bypasses Outlook form

Posted on 2001-06-26
20
188 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
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 …
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…

856 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