Checking Two Conditions in a Macro

  • Thread starter Thread starter Jani
  • Start date Start date
J

Jani

Is there a way to check two conditions in a macro at the same time? I want to
check to see if both a date and name are in a table before appending the
data. These need to be checked at the same time as in the dbo table there
could be the same date from another 'name' or the 'name' could be for a
different date. My current code is shown below and the error message states
that the tblDots can't be found but I know it is in the database. Any help
would be appreciated. Thanks! Jani

[tblDots]![Name]=[dbo_uDotsAll]![Name] &
[tblDots]![DistDate]=[dbo_uDotsAll]![DistDate]
 
They're boolean expressions. Use the And operator:

[tblDots]![Name]=[dbo_uDotsAll]![Name] And
[tblDots]![DistDate]=[dbo_uDotsAll]![DistDate]
 
Geez - you're quick! I changed to AND and am still getting a message that the
tblDots can't be found. The message is 'you may have specified a control that
wasn't on the current object without specifying the correct form or report
context. I tried entering
! and then table! preceding the code but
those didn't work. Any ideas on what I'm doing incorrectly?

Douglas J. Steele said:
They're boolean expressions. Use the And operator:

[tblDots]![Name]=[dbo_uDotsAll]![Name] And
[tblDots]![DistDate]=[dbo_uDotsAll]![DistDate]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Jani said:
Is there a way to check two conditions in a macro at the same time? I want
to
check to see if both a date and name are in a table before appending the
data. These need to be checked at the same time as in the dbo table there
could be the same date from another 'name' or the 'name' could be for a
different date. My current code is shown below and the error message
states
that the tblDots can't be found but I know it is in the database. Any help
would be appreciated. Thanks! Jani

[tblDots]![Name]=[dbo_uDotsAll]![Name] &
[tblDots]![DistDate]=[dbo_uDotsAll]![DistDate]
Click to expand...
Click to expand...
 
Sorry, I didn't notice that you were referring to a table. You can't refer
to fields in tables like that. You need to use DLookup to get a specific
value.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Jani said:
Geez - you're quick! I changed to AND and am still getting a message that
the
tblDots can't be found. The message is 'you may have specified a control
that
wasn't on the current object without specifying the correct form or report
context. I tried entering
! and then table! preceding the code but
those didn't work. Any ideas on what I'm doing incorrectly?

Douglas J. Steele said:
They're boolean expressions. Use the And operator:

[tblDots]![Name]=[dbo_uDotsAll]![Name] And
[tblDots]![DistDate]=[dbo_uDotsAll]![DistDate]


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Jani said:
Is there a way to check two conditions in a macro at the same time? I
want
to
check to see if both a date and name are in a table before appending
the
data. These need to be checked at the same time as in the dbo table
there
could be the same date from another 'name' or the 'name' could be for a
different date. My current code is shown below and the error message
states
that the tblDots can't be found but I know it is in the database. Any
help
would be appreciated. Thanks! Jani

[tblDots]![Name]=[dbo_uDotsAll]![Name] &
[tblDots]![DistDate]=[dbo_uDotsAll]![DistDate]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top