Recent content by kkeegler

  1. K

    Form to query to report

    I repeatedly enter new customer to a form from on which I can click a button to print a letter and then click another button to prepare the evevlope. As long as there are no interruptions the form can be scrolled back and forth to accomplish these tasks. If the form is closed I then need to go...
  2. K

    Parameter Value error

    Fixed The junior member bows to the senior member. It certainly pays to know exactly where to look. Thanks very much for fixing a very irritating problem. :)
  3. K

    Parameter Value error

    I looked and there was nothing there.
  4. K

    Parameter Value error

    I click a command button on a form to print a report and get a message box that calls for a parameter value to be entered with the notation "tblClientInformation.ClientReTracePrice" The requested print report is a fax cover sheet to my client. The parameter error has nothing to do with the...
  5. K

    Apostrophe problem

    PERFECT!!! Fast and accurate - it doesn't get any better than that. Thanks
  6. K

    Apostrophe problem

    A button opens a new data entry form and works for all my clients except when the name contains an apostrophe like O'Brien The code follows: Private Sub cmdNewSubscriber_Click() On Error GoTo Err_cmdNewSubscriber_Click Dim stDocName As String Dim stLinkCriteria As String...
  7. K

    Modify form

    Resolved...spelling error located
  8. K

    Modify form

    Modify Form I guess you need more info. I know how to change lables, field names etc. The currency field and product name sets the price on that product and the field name passes to my customer invoice after a few calculations such as totals with other purchases, sales tax calcs. etc. That...
  9. K

    Modify form

    I am a newbe - so here goes. I need to change a product I sell to another name, i.e. ReTrace to No Record. Is there way to locat all instances of "Retrace" in Tables, Forms, Reports, SQL statements etc and simply change it to "No Record" Similar to the Find Replace option. I already tried...
Back
Top Bottom