User Profile

Collapse

Profile Sidebar

Collapse
mpslanker
mpslanker
Last Activity: Jul 13 '09, 03:03 AM
Joined: May 10 '07
Location: Arlington
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mpslanker
    replied to Import, Append/Update question.
    in Access
    Thanks again J, you don't know how much I appreciate it. I beginning to think I wasn't going to find an answer that I could even understand.

    So far I have enjoyed the VBA experience I have recieved, I am really into programming but I am still pretty new at it. I am only 21 (in 6 days anyway) and I was recommended for this new position. They found out I was pretty capable on the computer and have been pushing me to see what all I...
    See more | Go to post

      Leave a comment:

    • mpslanker
      replied to Import, Append/Update question.
      in Access
      Nevermind, I caused there error I messed up the line before it.

      So far it ran all the way through with no problems, and I double checked the data. IT'S PERFECT. I don't know what I would have done without your help. Thank you so much again.

      Sincerely,

      Matthew...
      See more | Go to post

        Leave a comment:

      • mpslanker
        replied to Import, Append/Update question.
        in Access
        So the single tick marks made the difference, and it is coming along a lot faster than I expected it to. Everything is starting to make sense. I did run into a new error that I don't understand. The program breaks at:
        If rs1.Fields(J).N ame = rs.Fields(I).Na me Then ' if the field names match...update the value
        Throwing another error:
        Run-time error: '3265'
        Item not found in this collection.
        I don't understand where the collection...
        See more | Go to post

          Leave a comment:

        • mpslanker
          replied to Import, Append/Update question.
          in Access
          I may wind up having to go that route, but I wanna try the other way first. (I love learning new things)

          I had to go in and make sure when the text file imported pulled the field names in too, and that they had the same name as the table the data is being appended to. After I got all that taken care of and the above function modified with the appropriate table/column names, I now recieve a runtime error. Error #3464: "Data type...
          See more | Go to post

            Leave a comment:

          • mpslanker
            replied to Import, Append/Update question.
            in Access
            Wow, that was an incredibly quick response, and so far it makes perfect sense. I know a little bit about using VBA so I should be able to stumble through it, until I figure how out it all fits together. Thank you so much. I really appreciate it. I will get to work on getting that in my database and let you know how it goes. Thanks again.

            Sincerely,

            Matthew....
            See more | Go to post

              Leave a comment:

            • mpslanker
              started a topic Import, Append/Update question.
              in Access

              Import, Append/Update question.

              This is my first time posting here, so if I have made any mistakes (i.e. wrong forum area, etc) I am sorry.

              I have an Access database that I have to import a text file into and append it to a certain table. I know this part of my question has been answered and I understand how to do it quite well after searching long and hard for an answer to my next part. I can either import the text file directly into the table or into it's own...
              See more | Go to post
              No activity results to display
              Show More
              Working...