Results 1 to 5 of 5
  1. #1
    kosti is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    6

    A simple question:

    I have a query related to a table, and being updated every time i add a record through a form. I want : after i enter a record, i want the data in the query to be stored automatically in another table, with exactly the same fields as the query, without overwriting or deleting any of the previous records..



    Can i Do that? Through a macro for example?

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I am a little confused. You want to have two tables with exactly the same information? This makes no sense to me. Why would you want that? Some more information on what you are doing may prove helpful.

  3. #3
    A S MANN is offline Advanced System Analyst
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    India
    Posts
    161
    What i understood is that the query calculate some fields data which need to be stored in seperate table for future.
    You need to do following
    1: Convert Query to Make Table Query.Run Query to convert data to New table. Do Not Save changes so that Query will remain select query only. that way all the query fields get map to New Table.
    2: Create a append query taking record source as select query the append source should be new Table.
    3: Creat a macro to run append Query.
    4:In your form where new data is entered at After update Form link to Macro.
    5: when New data is entered, Update Query Run to append data to new table.
    Macro can also be linked to SAVE Button to append Wheneven DATA is saved.
    Hope this solve your problem.

  4. #4
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows 7 64bit Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    It is not good policy to store Calculated Values.

    I would avoid this unless you have special reasons for doing so. e.g. A temp Table to run a complex Report.

  5. #5
    kosti is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    6
    Thanks!!!! I did it by myself :P , much more the way A S MANN wrote... Thank you anyway

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Simple VBA Question
    By koper in forum Access
    Replies: 1
    Last Post: 01-20-2011, 12:07 PM
  2. Simple Question...I hope
    By AndrewCoy in forum Access
    Replies: 1
    Last Post: 07-18-2010, 10:06 AM
  3. Simple question
    By KenM in forum Queries
    Replies: 1
    Last Post: 11-10-2009, 03:32 PM
  4. Simple question?
    By roads.zx in forum Access
    Replies: 0
    Last Post: 10-15-2009, 04:56 PM
  5. Very simple question!
    By fiddley in forum Programming
    Replies: 2
    Last Post: 04-28-2009, 02:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums