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!

Search results for query: *

  1. Ernestw

    Error Printing Paradox 8 Reports from NT

    We had an earlier question regarding printing reports, and we came up with the following solution. We added a routine to the library (the code follows), and a small form with a Print button and a Close Button. The code is given below. To overcome the dialog error box problem, we added the...
  2. Ernestw

    Field looses data

    I found the problem. Enough said.
  3. 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...
  4. Ernestw

    Offset Cursor

    In chasing this problem on another website, I came across the following comments. It agrees with my experience in that if I select 800 by 600 for my display, the cursor behaves properly. Programmer 1: This is a known problem in P10 when using at least ZoomBestFit, perhaps other...
  5. 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...
  6. Ernestw

    Paradox 11 Report Errors

    To overcome the dialog error box problem, we added the following function to lib1. Library Routine: method OpenReport(orient String,rptName String) var repinfo ReportPrintInfo prnOptions PrinterOptionInfo tc tCursor strReportName String ;// tmp handle to report name rHandle Report...
  7. Ernestw

    Paradox 11 Report Errors

    We seem to have solved the problem. We added Print and Cancel buttons on the report, and we don't get the error. I had hoped to post a reply here with the ObjectPAL code, but I haven't been able to get it. We moved buildings, and the individual who has the code is bogged down getting the...
  8. Ernestw

    Paradox 11 Report Errors

    Lance, Resaving did not help. The reports all have the default style sheet. I built a new report, assigned a style sheet, and received the same error when I went to print. I have copied the error displayed: "Report layout settings (page size, paper orientation) have been changed...
  9. 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...
  10. Ernestw

    Duplicate Records

    Hans and Lance, I can now identify the potential records of interest in about 10 seconds; a vast improvement over the SQL. Yes, I need to do it in two steps. The initial query from Hans will build my list of potential serial numbers, and I can add the other requirements in a second query...
  11. 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...
  12. Ernestw

    Query Question

    Hans, Thank you. Your suggestion works fine. Ernie
  13. 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