Access Help PLEASE!!!!!!!!

Discussion in 'OT Technology' started by JohnDSU, May 25, 2005.

  1. JohnDSU

    JohnDSU New Member

    Joined:
    Nov 15, 2004
    Messages:
    90
    Likes Received:
    0
    Okay I was told to fix up this database and I can't figure it out. I want to change the code but I can't figure it out.
    Select Case optGroup
    Case 1 'Reports
    qry$ = qry$ & " INTO tmp_report IN 'C:\ACCESS\Database.MDB'"
    tblName$ = "tmp_report"

    It's from a query builder form that someone set up. I want it to just read the table tmp_report that is already in the database and not have to link it to this other one. Anyone have any clue how to rewrite that code?? :dunno:
     
  2. RyanL

    RyanL OT Supporter

    Joined:
    Nov 30, 2004
    Messages:
    4,584
    Likes Received:
    0
    Location:
    St. Paul, MN
    What is the database you are using?

    In mysql it is just SELECT [FIELD_NAMES or * for all] FROM [TABLE NAME]

    In your case 'SELECT * FROM tmp_report' would give you everything in tmp_report...

    I guess I am not really clear on what you want to know...
     
  3. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    um, looks like an access db to me. :mamoru:
     
  4. kingtoad

    kingtoad OT Supporter

    Joined:
    Sep 2, 2003
    Messages:
    55,923
    Likes Received:
    11
    Location:
    Los Angeles
    :uh:
     

Share This Page