Help With IF Syntax? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

Topic

New Reply

How can I change the following not to include tables with _Bak_ in the table name?

The following is not working?

And tdf.Name “*_Bak_*” _

Thanks, John

If (tdf.Attributes And (dbSystemObject Or dbHiddenObject)) = 0 _
    And tdf.Name  "zTableFields" _
    And Left(tdf.Name, 1)  "~" _
    And Left(tdf.Name, 2)  "ez" _
    And tdf.Name  "*_Bak_*" _
    Then

Reply | Quote

Replies

Change

And tdf.Name "*_Bak_*"

to

And Not tdf.Name Like "*_Bak_*"

Reply | Quote

Thank you

Reply | Quote