Results 1 to 2 of 2

Thread: [RESOLVED]Behind the Scenes Query

  1. Oct 11th, 2005, 08:23 AM #1
    Naughty Dog
    Naughty Dog is offline

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    2

    Question [RESOLVED]Behind the Scenes Query

    Hi,

    I was wondering if there is a way in VBA of running an Access query but NOT showing the datasheet result. I need to run it on a button press but not display because im going to manipulate the results of the query later.

    Thanks in advance.

    Dave
    Last edited by Naughty Dog; Oct 25th, 2005 at 09:33 AM.
    Reply With Quote Reply With Quote
  2. Oct 11th, 2005, 09:10 AM #2
    Dnereb
    Dnereb is offline
    Fanatic Member Dnereb's Avatar
    Join Date
    Aug 2005
    Location
    Netherlands
    Posts
    863

    Re: Behind the Scenes Query

    Sure You can. In fact it's harde to show the data (unbound) then to retriev it

    make sure you have a reference to DAO (since it's acces) or if you want to upscale to other databases in the futere to ADO

    search this site for opening a connectiont to an Access database (*there are plenty examples.

    modify the SQL Query to your need.

    and the recordset wil contain the data you want to have but not to show
    why can't programmers keep and 31 Oct and 25 dec apart. Why Rating is Useful
    for every question you ask provide an answer on another thread.
    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