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 strongm 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: tobynegus
  • Content: Threads
  • Order by date
  1. tobynegus

    SQL date formats- 01/11/09 not 11/01/09

    I am runnning an INSERT SQL with IN into another database I am having trouble with date format The date the sql is getting is 01/11/09 (1st Nov 09) (this shows correct in the Immediate panel) when the data gets to the other database in comes in as 11/01/09 (11th Jan 09) how can i get this...
  2. tobynegus

    Axport Query from Access to another MDB

    Hi Is it possible to export a query result to another Access database or pull an Access query result into a Access database? any help much aprreciated Toby7
  3. tobynegus

    Change Primary keys VBA

    Hi I am trying to change the primary keys on a table I have two fileds set as primary Keys, I want to drop thease keys (keep the fields) and set a new single primary Key (auto Increment) I have looked on the web but without any success, this must have been done by someone somewhere, any help...
  4. tobynegus

    RefreshLink error 3051

    I have some linked Txt and EXL files, and some code to refresh link, it works fine on the txt files but fails with the xls file. gives error 3051 and says it is already opened exclusively by aniother user! this is a stand alone envioronmnet, and it links fine if i us the manulal Linked Table...
  5. tobynegus

    relink relative TXT files using connect

    I am trying to relink to existing linked csv and txt files, although the location may be different it is always realtive to the mdb file I have tried using the following code (GetPath returns the location of the database, the data is stored in the /RAWDATA folder the tdf.SourceTableName returns...

Part and Inventory Search

Back
Top