Recent content by Icepickle

  1. I

    entire report blank when no detail data exists

    works perfectly. thanks again :)
  2. I

    entire report blank when no detail data exists

    yes they are in 2 seperate tables, and and this is the sql statement: SELECT qPrintHeader.OrderNumber, qPrintHeader.status, qPrintHeader.bt_name, qPrintHeader.bt_id, qPrintHeader.bt_address, qPrintHeader.bt_city, qPrintHeader.bt_postal, qPrintHeader.st_name, qPrintHeader.st_id...
  3. I

    entire report blank when no detail data exists

    I have a report that prints invoices, and in the page header area it contains most of the invoice information such as labor cost, customer info, etc. In the detail section of the report i have the line items, and a line contains a part, vehicle charge, etc. Some invoices dont have any line...
  4. I

    specifying a record by its unique primary key value

    I have a table, and there are many records, each with a unique value in the OrderNumber field I have a text box on a form, and i want it to work so that the user types in a OrderNumber value, and it loads that record into the form (the form is bound to the table) I already know how to load...
  5. I

    saving long text to a memo field

    I have a text box on a form, and when a button is clicked it runs a code to save the contents of the text box to a memo field in a table. Im using the DoCmd.RunSQL UPDATE command to send the contents of the text box to the memo field, but with long strings get cut off after a hundred characters...
See more
Back
Top Bottom