Dealing with Fields in VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Microsoft - 31 May 2005 03:43 GMT

I want to do a snippet of code which:

1. Will determine whether a specific named field exists.
2. If the field exists, will assign a new value to it.
3. Will update all fields.

Reply to this Message

Anand.V.V.N - 31 May 2005 05:41 GMT

Hi,
Just one doubt though is this field user specified or a constant field?

Anand

Signature

"Who will guard the guards?"

> I want to do a snippet of code which:
>
> 1. Will determine whether a specific named field exists.
> 2. If the field exists, will assign a new value to it.
> 3. Will update all fields.

Reply to this Message

Microsoft - 31 May 2005 10:32 GMT

Its a user specified field.

> Hi,
> Just one doubt though is this field user specified or a constant field?
[quoted text clipped - 8 lines]
> > 2. If the field exists, will assign a new value to it.
> > 3. Will update all fields.

Reply to this Message

Anand.V.V.N - 01 Jun 2005 11:10 GMT

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/wo
proCount1_HV03081721.asp

Check the baove link, I guess using the example of the usign the count
property, you can modify the code suit your needs.

Hope thsi was helpful

Anand

Signature

"Who will guard the guards?"

> Its a user specified field.
>
[quoted text clipped - 10 lines]
> > > 2. If the field exists, will assign a new value to it.
> > > 3. Will update all fields.

Reply to this Message