G
Guest
Hello All,
I have a macro in which I have conditions that must be met before a certain
Macro is run. The problem is I have a number of conditions that must be met
before this command macro will be run and it exceeds the max character length
allowed in the conditions column. This is principally because I have had to
use the the complete identifier (i.e. [Forms]![Work
RequisitionsBackup]![FieldName] = ....) to identify a field on a form instead
of simply it's field name (i.e. [FieldName]=....).
If is use just the field name in the condition it generates an error
evaluating the condition saying you basically tried to fool me and it's not
going to happen.
Here's the Full identifier condition:
[Forms]![Work RequisitionsBackup]![TotalPriceAsProvided]>[Forms]![Work
RequisitionsBackup]![Funding Available] And [Forms]![Work
RequisitionsBackup]![Funding Available]>0 And [Forms]![Work
RequisitionsBackup]![Approval number]<>"As Per Letter" .... I want to add
another condition but I am maxed out character wise
Field name only identifier condition:
[TotalPriceAsProvided]>[Funding Available] And [Funding Available]>0 And
([Approval number]<>"As Per Letter" Or [Approval number] Is Null)
My first question is , is there any way to identify more than one condition
for a field using some operator like "Like"?
for instance will ([Approval number]<>"As Per Letter" Or Is Null) work?
Second, for the life of me I cannot find a description of the 'Like"
operator. Is that written somewhere? If so where and are there other
operators that are not available in the regular Access help files but will
work in Access? And if so how do you get info on them?
Thanks all
Andy
I have a macro in which I have conditions that must be met before a certain
Macro is run. The problem is I have a number of conditions that must be met
before this command macro will be run and it exceeds the max character length
allowed in the conditions column. This is principally because I have had to
use the the complete identifier (i.e. [Forms]![Work
RequisitionsBackup]![FieldName] = ....) to identify a field on a form instead
of simply it's field name (i.e. [FieldName]=....).
If is use just the field name in the condition it generates an error
evaluating the condition saying you basically tried to fool me and it's not
going to happen.
Here's the Full identifier condition:
[Forms]![Work RequisitionsBackup]![TotalPriceAsProvided]>[Forms]![Work
RequisitionsBackup]![Funding Available] And [Forms]![Work
RequisitionsBackup]![Funding Available]>0 And [Forms]![Work
RequisitionsBackup]![Approval number]<>"As Per Letter" .... I want to add
another condition but I am maxed out character wise
Field name only identifier condition:
[TotalPriceAsProvided]>[Funding Available] And [Funding Available]>0 And
([Approval number]<>"As Per Letter" Or [Approval number] Is Null)
My first question is , is there any way to identify more than one condition
for a field using some operator like "Like"?
for instance will ([Approval number]<>"As Per Letter" Or Is Null) work?
Second, for the life of me I cannot find a description of the 'Like"
operator. Is that written somewhere? If so where and are there other
operators that are not available in the regular Access help files but will
work in Access? And if so how do you get info on them?
Thanks all
Andy