Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to get specific data in VB

Discussion in 'Information Technology' started by danijela.simunovic@gmail.com, Nov 1, 2005.

Tags:
  1. danijela.simunovic@gmail.com

    Guest

    Hi!
    I am exporting some data from access to excel and here is my code for
    that:

    DoCmd.TransferSpreadsheet _
    TransferType:=acExport, _
    SpreadsheetType:=acSpreadsheetTypeExcel9, _
    TableName:="Table1", _
    FileName:=strFileName, _
    HasFieldNames:=True, _
    Range:="Sheet1"

    But i would like to export just specific data from Table1. Let's say
    only Dates that are in this year. Where do I put my contition for that
    and how would the code go? Thanks!

    Danijela
     
  2. Loading...


  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    Create a Query to filter only the Records/rows and Fields/columns you want
    and use the Query name in the TableName argument of your code.

    --
    HTH
    Van T. Dinh
    MVP (Access)



    <danijela.simunovic@gmail.com> wrote in message
    news:1130768547.453658.79040@o13g2000cwo.googlegroups.com...
    > Hi!
    > I am exporting some data from access to excel and here is my code for
    > that:
    >
    > DoCmd.TransferSpreadsheet _
    > TransferType:=acExport, _
    > SpreadsheetType:=acSpreadsheetTypeExcel9, _
    > TableName:="Table1", _
    > FileName:=strFileName, _
    > HasFieldNames:=True, _
    > Range:="Sheet1"
    >
    > But i would like to export just specific data from Table1. Let's say
    > only Dates that are in this year. Where do I put my contition for that
    > and how would the code go? Thanks!
    >
    > Danijela
    >
     
  4. danijela.simunovic@gmail.com

    Guest

    I know that I can do it that way but then if I need 10 filters I would
    need to make 10 querys or is there a way to give criteria from VB so
    that one query can preform a job of 10 or more querys?
    Thanks!

    Danijela
     
  5. danijela.simunovic@gmail.com

    Guest

    I did it!!!! Thanks! Don't need to explain! I made it work with one
    query!
    Thanks!
     

Share This Page