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 John Tel 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: Vulton
  • Content: Threads
  • Order by date
  1. Vulton

    Am I duplicating using IF and WHERE in a trigger?

    Here is the SQL trigger. It seems to me that checking in the inserted table in the IF statement means I don't need it in the WHERE clause. Any help simplifying this would be appreciated. CREATE TRIGGER TriggerInstallationComplete ON [mpadmin].[TblLotVisitsReason] FOR INSERT AS IF EXISTS...
  2. Vulton

    Returning fields along with the MIN function

    This qry returns the wrong C_JobNum and C_PhaseNumber actualy it always returns the 1st record in the table rather than the record the Min statement is returning. Can someone please show me how to make this work correctly? SELECT Min(Abs([C_Longitude]- (-117.61583))+Abs([C_latitude]-...
  3. Vulton

    Find closest Latitude/Longitude in a table using actual location

    My code works but is WAY WAY to slow. Please help me to find a better/faster way to find the closest record to given cordinates. Currently I have code that when given a latitude and longitude it will go record by record thru a table with latitudes and longitudes calculating the distance between...
  4. Vulton

    Need for Speed (not the white stuff)

    Ok I have read the FAQ's and searched I don't even know how many boards so now it's time to beg some help. I have several functions that read/write to a backend SQL database. I have read that it is not good to leave open a record set and to let connection pooling do its job. I had the recorsets...
  5. Vulton

    Why does this qry shut down access 2000?

    I have tried exporting to another DB... making a new one and remaking this qry... compacting and repairing... making a new 2000 db in 2003 access and then opening this in 2000. This qry will run but trying to save any change made to it closes access with no error. Perhaps someone will be good...
  6. Vulton

    If NewRecord in Tblone then append that record to tbltwo

    I have 3rd party application that uses a access database to keep track of "daily work". I can link to the tables in this aplications database and would like to append the information in the linked tables to my SQL tables as the aplication adds records to its tables. So... For each new record...
  7. Vulton

    ReLink Access Table Using UserName

    I have an Access Front End that links to several other backend databases. Three of the tables linked to are in an access database that is created from a 3rd party software "on the fly". Every user of this 3rd party software has his/her own user directory where this database is created in...

Part and Inventory Search

Back
Top