Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    cut/paste fields (access 2000)

    i maintain a database in my volunteer job & do everything thru help files & logic, i admit that i don't know anything serious about databases (vba is a blessing for us novices). can i cut an existing field in a table & paste it into a new, related table? i did it in a practice table & it looks ok, anything i should know about going on behind the scenes?

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: cut/paste fields (access 2000)

    I don't know what VBA has to do with it, but yes, you can copy a field in design view and paste it into the design view of another table without any problems. If you don't know anything about databases, though, I would strongly suggest you learn .. quickly. Relational database design is somewhere between an art and a science, and bad design is the easiest to achieve and the hardest to live with.
    Charlotte

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Swindon, Wiltshire, United Kingdom
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: cut/paste fields (access 2000)

    There's nothing in particular to remember except that, if you select the whole row in the table design view, then all of the properties set in the original field will come over with the field when it is pasted into the new table. The data will not come with the field. If you want the data to come over you could try copying the field rather than cutting it and then copying the data from the original table and paste it separately (although copying and pasting data in this way will paste the data in the same order as it was in the original table).

    This will work between any tables, whether they are linked or not. If you are looking to ensure that data in the pasted field links in some way to the records in the new table then you may have to start looking at an update query to ensure that the link is correct.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •