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!

  • Congratulations wOOdy-Soft 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: ph74
  • Content: Threads
  • Order by date
  1. ph74

    AppBuilder Voice Item Length

    Hi, We are currently using Call Pilot Application Builder to define voice prompts for use in symosium. I need to know the length of each message and have searched and searched but can not find the length of the recorded messages. Where do you look find this?? Thanks. PH.
  2. ph74

    SELECT Using INNER JOIN Not Working

    Can anyone help with the following that I think should be working but just comes back with error'80004005' SQLQuery = "SELECT Users.DBID, Position.Position FROM Users INNER JOIN Position ON Users.Position = Position.PositionID" Any ideas appreciated Paul.
  3. ph74

    INSERT INTO Question

    I am using the following INSERT INTO statement, to insert a users RecordID and a CourseID (CSID)into the training table, strInsert = "INSERT INTO training (RecordID, CSID)" & "Values ([RecordID], '" & cboSchedule & "')" DoCmd.RunSQL strInsert The problem being, if there is not already an entry...
  4. ph74

    SQL subquery help

    With the excellent help of these boards I have created the following sql query to select records based on the maximum training start date with a course id of 44. Good start, but i now need to only select records that have a start date of greater than 365 days from these result?? Any ideas...
  5. ph74

    Drop Table in SQL database from access

    I have a DoCmd.TransferDatabase which sucessfully copies a table from my Access DB to an SQL DB BUT only the first time. After checking other posts i need to add a DROP TABLE before the export. How do you drop a table from an SQL DB from within Access??

Part and Inventory Search

Back
Top