Solved

Validation Rule

Posted on 2014-09-03
4
187 Views
Last Modified: 2014-09-03
Experts, in a validation rule, can I refer to field within the table?   I am referring to [Type] within the field  [ExpectedDisbRecdDate].  Not sure if a rule like this is better placed in a form.

for example:

if [type] = "JBIC",>Date()+30,<Date()+25
the error I get is "enclose text data in quotes"

thanks

ValidationRule
0
Comment
Question by:pdvsa
  • 3
4 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40301454
not really sure what you are trying to accomplish here, but,

try something like this

IIf([type]="JBIC",>Date()+30,<Date()+25)
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40301469
if you are using A2010 or greater, data macro may work for you..
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 40301487
just tried what you have in a table and i am not surprise that it will not accept the entry in the validation rule property..

perhaps use the validation or setting the values of the Datefield using a form.
0
 

Author Closing Comment

by:pdvsa
ID: 40301498
thank you.  I will try the validation rule at the form level.
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now