Results 1 to 2 of 2

Thread: Exit Query

  1. Aug 13th, 2003, 03:20 PM #1
    Ephesians
    Ephesians is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2002
    Posts
    424

    Exit Query

    Microsoft Access

    How can I embedd a function into a query that will cause the query to shut itself down upon error? I've tried several attempts but nothing seems to work.. I usually get the error that I can't close the query because it's calculating or repainting but I know that in long queries I can abort with control-break. When I use sendkeys for that combination in a function it just skips the record and goes on. Any Ideas?
    Reply With Quote Reply With Quote
  2. Aug 15th, 2003, 02:57 PM #2
    Eras3r
    Eras3r is offline
    Hyperactive Member
    Join Date
    Aug 2002
    Posts
    416
    use DoCmd.RunSQL and have error trapping on it..... if it errors, exit .. or do whatever...
    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