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

    Field looses data

    I have a date field on a form in which the operator enters a date. When I try to use that date in a due date calculation on the save button on the form, I get the "unassigned variable" error. If I put a msginfo command in the depart event of the field, the date shows up. If I put the same...
  2. Ernestw

    Offset Cursor

    When we went from V 10 to V 11, we found our cursor moves ahead of the text. With a remarks field of 250 characters, the cursor leads the text by several character widths before the end of the first line. The real problem occurs when you want to delete a character; until you practice a lot...
  3. Ernestw

    Paradox 11 Report Errors

    We have a number of reports that have run in every version of Paradox up to version 11. In version 11, we are told the paper format is incorrect, and the report will be reconfigured. The warning includes a line that this could take some time. Once we click the OK button, the report comes out...
  4. Ernestw

    Duplicate Records

    I have a table with legitimate and illegitimate records. I want to run a query based on one field, serial_number, that will show the serial number and a count of the records of interest. The following SQL works, but it takes several minutes. SELECT DISTINCT sn, count(*) FROM...
  5. Ernestw

    Query Question

    I have two tables that should have the same records. However, that is not the case. The common field is part_SN. I should like to run a query that selects the records from table 1 that are not in table 2. I built a SQL statement, but it is incredible slow. TIA, Ernie

Part and Inventory Search

Back
Top