Results 1 to 2 of 2

Thread: Access 2002 Copy Data from Form into Table

  1. #1
    Join Date
    Dec 2004
    0 times in 0 posts

    Lightbulb Access 2002 Copy Data from Form into Table

    I am trying to copy data inputted into a form to a table.
    this is because there are calculated fields in the form andso in future if a calculation changes all previous entries will change to adjust for the new formula.
    So ..

    I need to copy the data from the form into a table where the data can be stored without it being linked to any formulae.

    Any ideas-I thought i may need to do SQL statement or VB if necessary or is there Anything in Access which could do this???

    Thanks for any ideas guys!!!

  2. #2
    unapologetic apologist fuddam's Avatar
    Join Date
    Nov 2005
    275 times in 146 posts
    easy peasy

    do all the data input with calculations in a query - results will be exactly the same as the form. Base a form on that query, if you still need the form

    anyway, the query can be turned into a MAKE-TABLE query, either for a one-off, or permanently (I assume you don't need the latter)

    it will dump everything into a new table, as static data. No formulae left, of course, because tables can't handle them.

    btw, to do the above, inside the query, go to the QUERY menu and select MAKE TABLE QUERY, etc
    Last edited by fuddam; 09-03-2006 at 04:21 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. copy data to multiple locations.
    By madman045 in forum Software
    Replies: 4
    Last Post: 10-09-2005, 10:32 PM
  2. Replies: 7
    Last Post: 17-06-2005, 01:54 PM
  3. Replies: 4
    Last Post: 11-06-2004, 07:39 PM
  4. Replies: 8
    Last Post: 21-05-2004, 09:58 PM
  5. Comparing field data in VB (access)
    By blockers in forum Software
    Replies: 0
    Last Post: 09-12-2003, 08:18 PM

Posting Permissions

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