Results 1 to 4 of 4

Thread: ** RESOLVED **Access Query Results shown in Excel S/Sheet

Threaded View

  1. Jul 10th, 2003, 03:04 AM #1
    TheBionicOrange
    TheBionicOrange is offline

    Thread Starter
    Frenzied Member TheBionicOrange's Avatar
    Join Date
    Apr 2001
    Location
    Cardiff, UK
    Posts
    1,818

    Question ** RESOLVED **Access Query Results shown in Excel S/Sheet

    I'm trying my luck posting in here as it looks pretty empty.

    I have an Access DB and, via a VB front end I need to execute a query and show the results in an Excel spreadsheet, only I'm not too sure which is the best way to go about it.

    I thought maybe create the query in Access, and then make the VB prog just execute the query and then duno the results in Excel, but I need an input parameter for the query (week no) as it will change week on week.

    Is it possible to design a query in Access allowing for an input parameter ? or do I need to design a form ? If so thats gonna be a bit pointless as I have a VB front end where the week no is entered, so would rather use it from there ...

    Am I making any sense ?
    Last edited by TheBionicOrange; Jul 11th, 2003 at 02:47 AM.
    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