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 gkittelson 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. daftKev

    How to suppress select unique record identifier?

    To close this thread to overcome the message I actually used the Send Keys method as per the following:- 'Connect to the MOUT_PO_INTERFACE table SendKeys ("{ESC}") strTableName = "LocalMOUT_PO_INTERFACE" DoCmd.TransferDatabase acLink, "ODBC", _ "ODBC;DSN=MAXIMO;", acTable...
  2. daftKev

    How to suppress select unique record identifier?

    I guess that would be the easiest method, I'll give it a go with an additional def query.dhookom thanks for your help
  3. daftKev

    How to suppress select unique record identifier?

    Thanks for your reply dhookom, however I would prefer to use the table link method, is there a way to suppress the prompt? I have tried using the Sendkeys {esc} to automatically do this but cant get it to work.
  4. daftKev

    How to suppress select unique record identifier?

    Hi, I'm new to the group, and I have a problem that is causing me to go prematurely grey. I have created links to an external Oracle database using ODBC, however 2 tables I've connected to have no primary key and therefore get the select unique record identifier dialogue, how can I suppress...

Part and Inventory Search

Back
Top