Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ImpMan
  • Content: Threads
  • Order by date
  1. ImpMan

    How to get properties of subForm

    I have placed a subform on a main form. The name of the subform on the mainform is subform1. The source object object for subform is subFormDetails Within subformDetails I have some code running. How do I retrieve what the subform is called on the mainform using code. The return value I want...
  2. ImpMan

    Query Performance, optimising for a network

    I do not understand the following: Query1 links many tables together and will show all the records Query2 is a simple select query of query1 and only shows records related to a specific part Query2 always runs faster (by a couple of seconds)than Query1. Why? All the tables are in databases on...
  3. ImpMan

    SQL Inner Join Query Problem

    These two SQL queries return a different number of records. Why? The 'From Tablen' expression varies depending where I start my join from in the Access expression builder. Why should this make a difference? SELECT Table1.f4, Table2.f4 FROM Table1 INNER JOIN Table2 ON (Table1.f3 = Table2.f3) AND...
  4. ImpMan

    Problems with TransferDatabase and CopyObject Methods

    I am using either the CopyObject or TransferDatabase methods to move tables, queries and forms to another database. There are no problems with the tables or queries but there are problems with the forms. The problem is that when the code executes the code will probably work first time (not...
  5. ImpMan

    Problem with focus and subform with no records

    I have a main form with subform. A combo on the mainform is linked to the subform. Nothing complicated there. That works fine. Also on the mainform is a text box. The contents of the text box are changed using the 'on change' event from the combo. This process only works when the subform...

Part and Inventory Search

Back
Top