INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Field Value AND Field Description Property

Field Value AND Field Description Property

(OP)
I am trying to update one table with data from another as well as a field property value (description)...
It like I can almost get it to work...!! Ha..!!
Just not setting up the references to the table the right way I guess...
Below is what I am working with...
Any suggestions or examples would be greatly appreciated..!!!

Thanks in advance..!!
air1access

rs1.MoveFirst
Do While Not rs1.EOF
For i = 1 To FieldCount - 1
If Not IsNull(rs1("Value" & i)) Then
rs2.AddNew
rs2!IID = rs1!IID
rs2!Value = rs1("Value" & i)

Set tbl = db.TableDefs(rs1)
Set fld = tbl.Fields
Set prp = rs1.Properties("description")
rs2!Ck_Type = prp.Value

rs2.Update
End If
Next i
rs1.MoveNext
Loop

RE: Field Value AND Field Description Property

Not sure why you need to do this. I believe the Description property must first be created before it can be updated. Use your favorite web search page with 'access field.createproperty'

Duane
Hook'D on Access
MS Access MVP

RE: Field Value AND Field Description Property

(OP)
Not wanting to update the description property for the fields. They are already updated, just want to "read" the description property for each field and update that to a different table fields value... I hope this makes sense..!!!

RE: Field Value AND Field Description Property

You are setting a property:

Quote (air1Access)

Set prp = rs1.Properties("description")
Then you state:

Quote (air1Access)

Not wanting to update the description property for the fields.
... update that to a different table fields value

If the field description hasn't been set/created in the design interface or in code it will not exist and will generate an error if you attempt to reference it.

Duane
Hook'D on Access
MS Access MVP

RE: Field Value AND Field Description Property

PH,
Agreed. It would help to see all the declarations etc.

Duane
Hook'D on Access
MS Access MVP

RE: Field Value AND Field Description Property

(OP)
Dang..
Sorry about this.. After all that - I was just told that the data I'm building is no longer needed... Next project..!!
Thanks for the help fellas..!!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close