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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by EddStewart

  1. EddStewart

    Find Primary Key in table

    Hi, I'm importing a number of tables from an outside .mdb into my DB and need to automatically determine which field in the imported tables is the primary key. Can anyone help with some VBA code that can do this? Kind Regards, Edd Stewart
  2. EddStewart

    ODBC, why so slow?

    Hi, I'm trying to write a program which will access sales and purchase invoices in Sage Line 50 v7 and then do simple calculations on this data to find how much stock is required to be ordered etc. I'm using Access '97 to do this but i've run into some difficulties with its speed over ODBC...
  3. EddStewart

    Division by Zero with dates

    Hi, I have a problem with Access VBA that has me stuck so if anyone can help me, I would be most grateful: Set rstDest = db.OpenRecordset("SELECT * FROM TotaledOrders WHERE OrderDate = " & rstSrc!DateOrdered) Here I am trying to create/open a recordset containing all records with an...
See more

Part and Inventory Search

Back
Top