CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. August 9th, 2001, 02:14 PM #1
    mtrack81
    mtrack81 is offline Junior Member
    Join Date
    Jul 2001
    Posts
    17

    tabledef or Querydef

    In access 97, Can i use either tabledef or querydef in order to get a large group of records from different tables in my database and put them together? I have multiple tables where they have the same fields of equal type, and want to bunch the data for when i run a massive search on the records... i hope i was clear enough, any ideas please let me know.. thanks..

    Reply With Quote Reply With Quote
  2. August 9th, 2001, 03:09 PM #2
    Iouri
    Iouri is offline Elite Member
    Join Date
    May 2000
    Location
    New York, NY, USA
    Posts
    2,878

    Re: tabledef or Querydef

    Tabledef and Querydef are the collections which hold names of the tables and queries respectively.
    If you need to get data from the similar tables you can use either UNION or JOIN

    Iouri Boutchkine
    [email protected]
    Iouri Boutchkine
    [email protected]
    Reply With Quote Reply With Quote
  3. August 9th, 2001, 06:14 PM #3
    enigmaos's Avatar
    enigmaos
    enigmaos is offline Member
    Join Date
    Aug 2001
    Location
    New York, USA
    Posts
    169

    Re: tabledef or Querydef

    you can use Querydef, which only looks for either pre-defined queries in Access or queries defined in your program, depending on where you point it to.
    As for combining all the data together, try JOIN or UNION.

    [email protected]

    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

Featured