Solved Skip one field by name (1 Viewer)

[Puff]

Hi everyone,

Is it possible within a function to ignore one field by it's name? i.e not return any value.

The code I have already ignores the ID number by use of If, Else, Then

With rst
        For Each f In .Fields
            If (f.Attributes And dbAutoIncrField) Then ' always skip the AutoNumber Primary Key
            Else
                clone.Fields(f.Name) = f
            End If
        Next f
    End With

I was wondering if I could also exclude another field just by it's name?

Puffs

 

[theDBguy]

How about?

If (f.Attributes...) AND f.Name = "NameToIgnore" Then

 

[cheekybuddha]

Wouldn't that be:

If (f.Attributes...) OR f.Name = "NameToIgnore" Then

 

[theDBguy]

Wouldn't that be:

If (f.Attributes...) OR f.Name = "NameToIgnore" Then

Sorry, that's correct. Please use OR.

 

[Puff]

Hi Chaps, thank you for this as soon as I get back home, I will test

 

[Puff]

Thanks Guys, works like a charm!

 

[theDBguy]

Thanks Guys, works like a charm!

Hi. You're welcome! @cheekybuddha and I were happy to assist. Good luck with your project.