Data validation

Status
Not open for further replies.
F

Fred Boer

Hi!

Well, I am considering how to deal with data validation. I am able to use

the data validation that is available through the Properties sheet. It

appears, however, that the error message popup message is delayed until

saving changes. A couple of questions:

1. Is there a way to limit data entry in a combobox to the "Possible

Values"? Something similar to the "LimitToList" property in Access

comboboxes?

2. Is the built in validation the only available option? Can we do it using

VBA and events?

Thanks

Fred Boer - Amateur Access Enthusiast

Interests: Library software / Z39.50 / Web Services

Freeware Small Library Application available here:

http://www3.sympatico.ca/lornarourke/
 
S

Sue Mosher [MVP]

Are you referring to an Outlook custom form? If so, on the Advanced

Properties dialog for the control, does the MatchRequired property fit your

scenario for #1?

Doing validation with VBA events would mean distributing that VBA code to

each user, for which there isn't a good supported method. If you need to

validate as the user enters data, see

http://www.outlookcode.com/article.aspx?ID=38 for available form code

events.

Sue Mosher

"Fred Boer" <fredboer1@NOyahooSPAM.com> wrote in message

news:uXIgWCF%23JHA.4560@TK2MSFTNGP03.phx.gbl...
> Hi!

> Well, I am considering how to deal with data validation. I am able to use
> the data validation that is available through the Properties sheet. It
> appears, however, that the error message popup message is delayed until
> saving changes. A couple of questions:

> 1. Is there a way to limit data entry in a combobox to the "Possible
> Values"? Something similar to the "LimitToList" property in Access
> comboboxes?
> 2. Is the built in validation the only available option? Can we do it
> using VBA and events?

> Thanks
> > Fred Boer - Amateur Access Enthusiast
> Interests: Library software / Z39.50 / Web Services
> Freeware Small Library Application available here:
> http://www3.sympatico.ca/lornarourke/

>
 
F

Fred Boer

Hello Sue:

Although I've only been working with Outlook for a week or two, it's seems

obvious that you are one of the gurus in this field! Thanks for your help.

Yes, the "MatchRequired" advanced property does seem to be what I need. A

follow up question, however: where the heck in the Outlook Help system can I

get information on these advanced properties? I've spent about half an hour

trying everything I can think of but can't find anything.

With respect to my VBA question, I must apologize for my careless use of

terms. I think what I meant to say was "VBScript" not "VBA". I meant to

refer to the programming environment used by Outlook. The question rephrased

would be, perhaps, "Is it common/possible to use code in VBScript to do data

validation on custom form fields?"

Thanks again!

Fred

"Sue Mosher [MVP]" <suemvp@turtleflock.com> wrote in message

news:OeYyfaG%23JHA.3612@TK2MSFTNGP04.phx.gbl...
> Are you referring to an Outlook custom form? If so, on the Advanced
> Properties dialog for the control, does the MatchRequired property fit
> your scenario for #1?

> Doing validation with VBA events would mean distributing that VBA code to
> each user, for which there isn't a good supported method. If you need to
> validate as the user enters data, see
> http://www.outlookcode.com/article.aspx?ID=38 for available form code
> events.
> > Sue Mosher
> > >

> "Fred Boer" <fredboer1@NOyahooSPAM.com> wrote in message
> news:uXIgWCF%23JHA.4560@TK2MSFTNGP03.phx.gbl...
> > Hi!
>

>> Well, I am considering how to deal with data validation. I am able to use
> > the data validation that is available through the Properties sheet. It
> > appears, however, that the error message popup message is delayed until
> > saving changes. A couple of questions:
>

>> 1. Is there a way to limit data entry in a combobox to the "Possible
> > Values"? Something similar to the "LimitToList" property in Access
> > comboboxes?
> > 2. Is the built in validation the only available option? Can we do it
> > using VBA and events?
>

>> Thanks
> > > > Fred Boer - Amateur Access Enthusiast
> > Interests: Library software / Z39.50 / Web Services
> > Freeware Small Library Application available here:
> > http://www3.sympatico.ca/lornarourke/
>

>
>>


>
 
S

Sue Mosher [MVP]

To get to the Outlook Developer Help, open the VBA window and press F1. It's

also available online at MSDN.

Outlook has two programming environments -- VBScript for code behind Outlook

forms and VBA for macros and application-level event handlers. Information

on using VBScript to handle users' interaction with the controls on the

form, including validation, is at the link I posted earlier.

Sue Mosher

"Fred Boer" <fredboer@NOyahooSPAM.com> wrote in message

news:%23NXRIZL%23JHA.200@TK2MSFTNGP05.phx.gbl...
> Hello Sue:

> Although I've only been working with Outlook for a week or two, it's seems
> obvious that you are one of the gurus in this field! Thanks for your help.

> Yes, the "MatchRequired" advanced property does seem to be what I need. A
> follow up question, however: where the heck in the Outlook Help system can
> I get information on these advanced properties? I've spent about half an
> hour trying everything I can think of but can't find anything.

> With respect to my VBA question, I must apologize for my careless use of
> terms. I think what I meant to say was "VBScript" not "VBA". I meant to
> refer to the programming environment used by Outlook. The question
> rephrased would be, perhaps, "Is it common/possible to use code in
> VBScript to do data validation on custom form fields?"

> Thanks again!

> Fred

> "Sue Mosher [MVP]" <suemvp@turtleflock.com> wrote in message
> news:OeYyfaG%23JHA.3612@TK2MSFTNGP04.phx.gbl...
> > Are you referring to an Outlook custom form? If so, on the Advanced
> > Properties dialog for the control, does the MatchRequired property fit
> > your scenario for #1?
>

>> Doing validation with VBA events would mean distributing that VBA code to
> > each user, for which there isn't a good supported method. If you need to
> > validate as the user enters data, see
> > http://www.outlookcode.com/article.aspx?ID=38 for available form code
> > events.
>

>> "Fred Boer" <fredboer1@NOyahooSPAM.com> wrote in message
> > news:uXIgWCF%23JHA.4560@TK2MSFTNGP03.phx.gbl...
> >> Hi!
> >
>>> Well, I am considering how to deal with data validation. I am able to
> >> use the data validation that is available through the Properties sheet.
> >> It appears, however, that the error message popup message is delayed
> >> until saving changes. A couple of questions:
> >
>>> 1. Is there a way to limit data entry in a combobox to the "Possible
> >> Values"? Something similar to the "LimitToList" property in Access
> >> comboboxes?
> >> 2. Is the built in validation the only available option? Can we do it
> >> using VBA and events?
> >
>>> Thanks
> >> > >> Fred Boer - Amateur Access Enthusiast
> >> Interests: Library software / Z39.50 / Web Services
> >> Freeware Small Library Application available here:
> >> http://www3.sympatico.ca/lornarourke/
> >
>>
>>>

>

>>


>
 
F

Fred Boer

Thanks again. I have (finally) figured out how to find what I needed in

Outlook help. I was looking in the "Microsoft Outlook Visual Basic

Reference", but the help I needed was in "Outlook - Forms> Control

Reference".

The question I'd like to ask the developers of the Help system is: "Why the

heck when I type "MatchEntry" in the search textbox, is nothing found!?".

Surely you should be able to enter the name of any property/method/object

and be linked to help entries for that item....

Cheers!

Fred

"Sue Mosher [MVP]" <suemvp@turtleflock.com> wrote in message

news:%23l%23N5mL%23JHA.1340@TK2MSFTNGP05.phx.gbl...
> To get to the Outlook Developer Help, open the VBA window and press F1.
> It's also available online at MSDN.

> Outlook has two programming environments -- VBScript for code behind
> Outlook forms and VBA for macros and application-level event handlers.
> Information on using VBScript to handle users' interaction with the
> controls on the form, including validation, is at the link I posted
> earlier.

> > Sue Mosher
> > >

> "Fred Boer" <fredboer@NOyahooSPAM.com> wrote in message
> news:%23NXRIZL%23JHA.200@TK2MSFTNGP05.phx.gbl...
> > Hello Sue:
>

>> Although I've only been working with Outlook for a week or two, it's
> > seems obvious that you are one of the gurus in this field! Thanks for
> > your help.
>

>> Yes, the "MatchRequired" advanced property does seem to be what I need. A
> > follow up question, however: where the heck in the Outlook Help system
> > can I get information on these advanced properties? I've spent about half
> > an hour trying everything I can think of but can't find anything.
>

>> With respect to my VBA question, I must apologize for my careless use of
> > terms. I think what I meant to say was "VBScript" not "VBA". I meant to
> > refer to the programming environment used by Outlook. The question
> > rephrased would be, perhaps, "Is it common/possible to use code in
> > VBScript to do data validation on custom form fields?"
>

>> Thanks again!
>

>> Fred
>

>> "Sue Mosher [MVP]" <suemvp@turtleflock.com> wrote in message
> > news:OeYyfaG%23JHA.3612@TK2MSFTNGP04.phx.gbl...
> >> Are you referring to an Outlook custom form? If so, on the Advanced
> >> Properties dialog for the control, does the MatchRequired property fit
> >> your scenario for #1?
> >
>>> Doing validation with VBA events would mean distributing that VBA code
> >> to each user, for which there isn't a good supported method. If you need
> >> to validate as the user enters data, see
> >> http://www.outlookcode.com/article.aspx?ID=38 for available form code
> >> events.
> >
>>> "Fred Boer" <fredboer1@NOyahooSPAM.com> wrote in message
> >> news:uXIgWCF%23JHA.4560@TK2MSFTNGP03.phx.gbl...
> >>> Hi!
> >>
>>>> Well, I am considering how to deal with data validation. I am able to
> >>> use the data validation that is available through the Properties sheet.
> >>> It appears, however, that the error message popup message is delayed
> >>> until saving changes. A couple of questions:
> >>
>>>> 1. Is there a way to limit data entry in a combobox to the "Possible
> >>> Values"? Something similar to the "LimitToList" property in Access
> >>> comboboxes?
> >>> 2. Is the built in validation the only available option? Can we do it
> >>> using VBA and events?
> >>
>>>> Thanks
> >>> > >>> Fred Boer - Amateur Access Enthusiast
> >>> Interests: Library software / Z39.50 / Web Services
> >>> Freeware Small Library Application available here:
> >>> http://www3.sympatico.ca/lornarourke/
> >>
>>>
>>>
>>
>>>

>

>>


>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
e_a_g_l_e_p_i Changing where data .pst is saved to Using Outlook 3
J Deliver new messages to New or Existing Data File? Using Outlook 2
G Outlook 2016: Want IMAP Data Files on My D: Drive and Not C: Drive Using Outlook 1
T vba extract data from msg file as attachment file of mail message Outlook VBA and Custom Forms 1
D Outlook 2016 Unable to load Outlook data pst file Using Outlook 5
V Form data not sending for some users Outlook VBA and Custom Forms 2
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 10
T How can Exchange be configured to sync/push one-way so that the server data can't be affected Exchange Server Administration 0
C Can't create Outlook data file Outlook Wishlist 0
T Extract Data From Outlook Tasks Using Outlook 0
F outlook.com Exchane Server corrupts data Since September 2019 Using Outlook.com accounts in Outlook 6
T Extract Data From Outlook Tasks Using Outlook 0
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
R "Can't store Outlook data files under the AppData folder. Please choose another folder." Using Outlook 6
C How to export Outlook data to csv? Using Outlook 0
RBLampert Assigning a newly (re)created e-mail account to a specific .pst data file Using Outlook 2
S newly added shared mailboxes downloading 500GB data a day Exchange Server Administration 1
M Using field names to capture a data element Using Outlook 0
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
M Outlook 2016 Requesting data from server Using Outlook 0
G Entered data in custom field goes in card and does not stay in list view Outlook VBA and Custom Forms 1
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
Sofia Manni Some of my favorite data in outlook. Using Outlook 2
A Outlook 2016 Will Not Show Any Data In the People Pane Using Outlook 17
A Script to fetch data from mails in restricted collection and sending them to excel Using Outlook 1
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
P Microsoft Outlook is requesting data from the server Using Outlook 2
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
K How to access emails found to be located in "Top of Outlook data file"? Using Outlook 3
M adding corresponding contact form data on a mass scale Using Outlook 5
J Calendar data can be viewed on Outlook.com, but no longer syncs to Outlook 2013 Using Outlook.com accounts in Outlook 3
M Retrieve data from GAL and put it in Clipboard Using Outlook 1
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
G Using Data From Combo Box in Appointment Body Outlook VBA and Custom Forms 6
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
Diane Poremsky Set Another Data File as Default When Using an Exchange Account Using Outlook 0
Diane Poremsky How to Compact the Data File When you Close Outlook Using Outlook 0
T Uploading Outlook 2016 Contacts to Exchange Server Drops "Company" field data in 30% of records Exchange Server Administration 4
Diane Poremsky Rename Email Accounts and Data Files in the Folder List Using Outlook 0
J create .pst data file for new gmail account Using Outlook.com accounts in Outlook 1
M Dilemma: to add to existing data file or not to? Using Outlook 16
R Exporting Excel data to Outlook 2016 Calendar Outlook VBA and Custom Forms 20
Diane Poremsky Data loss may occur during public folder migration Using Outlook 0
Diane Poremsky Use a macro to copy data in Outlook email to Excel workbook Using Outlook 0
A How to export one email data to excel Using Outlook 1
Diane Poremsky Create Appointments Using Spreadsheet Data Using Outlook 0
S Outlook data file cannot be accessed message Using Outlook 5
L outlook data file confusion Using Outlook 1
M Extracting cell data from table Outlook VBA and Custom Forms 2

Similar threads

Top