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!

  • Congratulations TouchToneTommy 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: *

  1. vakjay

    Using SQL command with DoCmd.RunSQL

    I have a form displaying values from a number of tables.(Test Cases, Users, Method, Levels, Priority, Builds). TID is a field linking the table "Test Cases" to another table. Normally when this form is accessed TID value is automatically filled in. If there is a record in Test Case table which...
  2. vakjay

    Conditional selection of fields on a form

    Thanks TheAceMan, "TabControl Change" did the job. Not only that, I was able to fix some other problemsn as well. Previously, these was some code behind those tab click event procedures which have never worked. Now I moved them to TabControl Change and they all started working OK...
  3. vakjay

    How to use a Import Specification file in a different Database

    Hi P27br and RobHudson, Thanks for your replies. P27Br, I will try your solution in future when required. I was able to solve my problem. When your code is in one database and the tables are in a different linked database, you have to create the Import Specication file with the database which...
  4. vakjay

    Conditional selection of fields on a form

    Dear TheAceMan1, Thanks for your reply. I am very new to Access Programming. Could you please explain a bit more. A small example would help me a lot. Thanks again.
  5. vakjay

    Conditional selection of fields on a form

    Hi Lonnie, Thanks very much for your reply. I tried the Click event of tabs. Unfortunately, the code was not run when the particular tab was clicked. I just used a MsgBox to check whether the code is run. This is how I did it. In the design view, I clicked right mouse button on the selected tab...
  6. vakjay

    Conditional selection of fields on a form

    I am using a multi tabbed form. All the tabs are in the details section. These are few text boxes (displaying fields) in the Header section of the form. I want to display these objects only when some of the tabs are selected. They should not be shown when any of the other tabs are selected. Can...
  7. vakjay

    How to use a Import Specification file in a different Database

    I have two databases. The first database contains the switchboard, forms, reports, queries, and all the code. The second database which is linked to the first database contains all the tables. I want to import data to a table in the second database using "DoCmd.TransferText(acImportDelim...

Part and Inventory Search

Back
Top