Results 1 to 3 of 3

Thread: archiving ind records

  1. 05-06-2003, 02:31 PM #1
    shep
    shep is offline Registered User
    Join Date
    May 2003
    Location
    uk
    Posts
    2

    archiving ind records

    on my form page i would like to create a command button that when pressed sends the record to a archive table
    Reply With Quote Reply With Quote
  2. 05-07-2003, 04:37 AM #2
    PinkPanther2003
    PinkPanther2003 is offline Registered User
    Join Date
    Feb 2003
    Posts
    102
    Hi Shep,

    That's excellent.

    It is possible.

    1. Make the queries to Insert the records into one table and delete from the other

    2. On the button click event start a transaction (this will make sure the records aren't added to one table and not deleted from the other).

    3. Execute the queries.

    4. If all goes well commit your transaction.

    5. Tell the user the good news.

    6. Using proper case is good for readability.

    HTH,

    Peter
    Reply With Quote Reply With Quote
  3. 05-07-2003, 07:04 AM #3
    shep
    shep is offline Registered User
    Join Date
    May 2003
    Location
    uk
    Posts
    2

    command button

    cheers peter i will give that go let you know how i get on
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules