Specify table/query in Code


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Specify table/query in Code

  1. #1
    rae Guest

    Specify table/query in Code


    I am trying to reference data in a table/query that is not being referenced
    by my form in Access. How do I code for the other table/query. If I simply
    type it in like in regular Access it gives me a "Can't find this field" which
    it is not just a field, it is a whole other table/query.

  2. #2
    ArthurWood Guest

    Re: Specify table/query in Code


    Rae,
    What do you mean by "If I simply type it in like in regular Access "?
    Where are you trying to type it in?

    Arthur Wood


    "rae" <reaton@ssm.org> wrote:
    >
    >I am trying to reference data in a table/query that is not being referenced
    >by my form in Access. How do I code for the other table/query. If I simply
    >type it in like in regular Access it gives me a "Can't find this field"

    which
    >it is not just a field, it is a whole other table/query.



  3. #3
    Ron Phillips Guest

    Re: Specify table/query in Code


    In Access, you might just use the name of the table or query in th
    forms designer. If you had a table called "tblTable", in Access you
    can just type in "tblTable" - the equivilent in SQL for this is
    "Select * from tblTable".

    Hope this helps,
    Ron

    On 14 Dec 2000 10:22:39 -0800, "rae" <reaton@ssm.org> wrote:
    >
    >I am trying to reference data in a table/query that is not being referenced
    >by my form in Access. How do I code for the other table/query. If I simply
    >type it in like in regular Access it gives me a "Can't find this field" which
    >it is not just a field, it is a whole other table/query.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center