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 sizbut 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. MrV123

    Excel keeps selecting cells it is like left mousebtn is stuck

    Hi prinand, Don't suppose you managed to find what was causing your problem? I am experiencing exactly the same thing and it's very frustrating. Have been using XL regularly on this laptop and had no problems. All of a sudden it's acting exactly as if the Left button remains clicked after I've...
  2. MrV123

    Getting newly created PK for foreign key in 2nd table

    Many thanks Roy-Vidar - that works perfectly.
  3. MrV123

    Getting newly created PK for foreign key in 2nd table

    Thanks for the reply Golom. The insert SQL statement works fine. You are correct in assuming that "AddressLine1" etc are variables defined n my code - I should have inclued that. The main point I would like to understand is how to write code which will do the following: 1) Insert a record...
  4. MrV123

    Getting newly created PK for foreign key in 2nd table

    I have 2 tables, CONTACT and ADDRESS. The primary key in the ADDRESS table is a foreign key in the CONTACT table. I want to write some VB to add a new Contact. This means first adding an entry in the ADDRESS table (to determine the auto-numbered primary key) and then adding an entry in the...

Part and Inventory Search

Back
Top