Results 1 to 2 of 2

Thread: Running Database Query

  1. Aug 2nd, 2000, 02:22 PM #1
    Brandr
    Brandr is offline

    Thread Starter
    Junior Member
    Join Date
    Jul 2000
    Posts
    30

    Question

    Hello, I think that this is an easy question with a quick solution. To let you know, I'm running VB5 Enterprise and Access 97. Now onto my question...

    I have a database (scs.mdb) with six different tables and two different update queries. I would like to know how I can code VB so that when a user hits a command button the two queries automattically run.

    I've been experimenting with shelling Access and then using the SendKeys function, but this is a real pain and it won't work. Please help!

    Thanks in advance,
    Brandr Beekman
    [email protected]
    Reply With Quote Reply With Quote
  2. Aug 2nd, 2000, 02:48 PM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Not sure, my Access docs are at home, but you might be able to do a passthru query, just sending the name of your access update queries. At the very least you could create an access object and send the commands to it to run the queries.

    I'll update this later, when I get home.
    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