User Profile

Collapse

Profile Sidebar

Collapse
AustinK
AustinK
Last Activity: Mar 11 '08, 06:09 PM
Joined: Mar 11 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • AustinK
    replied to Can't see some data in VBA recordset
    in Access
    Thanks - that helped me to find the problem. It only listed 3 fields instead of the expected 15-odd. Working back I found I had opened a different recordset with the same name.

    My VBA is very rusty.

    AK
    See more | Go to post

      Leave a comment:

    • AustinK
      started a topic Can't see some data in VBA recordset
      in Access

      Can't see some data in VBA recordset

      I have a query with data from several tables. I open it as a recordset in a VBA module and can get data from some of the fields with eg SomeData = TheQuery!SomeFi eld but for other fields when the code runs I get error 3626 - item not found in this collection.

      It is not a typo - the field names are correct.

      Any hints?

      Is there a way to see what it thinks is in the collection?

      Thanks
      See more | Go to post
      No activity results to display
      Show More
      Working...