Results 1 to 2 of 2

Thread: (Access) VB script for button

  1. Aug 22nd, 2008, 06:27 PM #1
    ctekk2005
    ctekk2005 is offline

    Thread Starter
    New Member
    Join Date
    Aug 2008
    Posts
    1

    (Access) VB script for button

    Ok, kind of stuck here. I am looking for a script to embed in a button in access that will take the current record seen on the form and copy it to a historical table. Then once the move is complete delete the record from the original table. All query appends have come up short and I am not as advanced in VB script as I thought to get this one. Any ideas?

    Thanks
    Reply With Quote Reply With Quote
  2. Aug 25th, 2008, 06:36 AM #2
    Hack
    Hack is offline
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: (Access) VB script for button

    Welcome to the forums.

    Are you familiar with writing SQL INSERT queries and SQL DELETE queries?

    It sounds like that would to the trick for you.

    Have a look at our Database FAQ section.
    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


Click Here to Expand Forum to Full Width