Search results

  1. Y

    OPENMODULE (STRIPSTRING FUNCTION)

    Thanks Robin and Chris for your help. It is starting to make sense. I am going to try to get this to work. Sometimes books and help menus don't cut it. Thats where personal experience rules. Have a good day! Yankee
  2. Y

    OPENMODULE (STRIPSTRING FUNCTION)

    Thanks for the information. One more question? The user is entering an address into a form. I then run an afterupdate function to strip the not wanted punctuation. Can I create your function as a module and execute an afterupdate event procedure and pass the new stripped string back to the...
  3. Y

    Combo boxs?

    Chisty, Check out the Orders Form on the Northwind Sample Database that came with Access. The customer Id box sounds like it might do the same function you want to do. Look at the afterupdate event procedure for "customer id". I was able to create a combo box that once you selected something...
  4. Y

    OPENMODULE (STRIPSTRING FUNCTION)

    I want to call up a form and have the user enter an address and then go through the below module to remove all characters not wanted. The module works fine in degug test. I just can't figure out how I can link this function to my form. I set the properties of an address data item to afterupdate...
  5. Y

    ELIMINATE SUBTOTALING SINGLE LINE GROUPS

    This worked great! Thanks for the creative input.
  6. Y

    ELIMINATE SUBTOTALING SINGLE LINE GROUPS

    I would like to display only a subtotal for a group of records (more than 1). If the group is only one record then I would not want to display a subtotal value. Can this be done in reports. Example: if I have a one record for the group with a value of $500.00, then I would not want to print...
  7. Y

    ELIMINATE COMMA'S AND DASHES IN DATA ITEMS

    I am trying to prevent my users from entering a comma or dash in an address data item field on a form. Can I create an expression in the properties ValidationText box to do this, or do I need to do something else? Any help would be appreciated!!
  8. Y

    BLANK SHEET AT END OF REPORT

    Can I eliminate the last page of my report that is blank (no record data) except for the page header information? Not sure what to change to eliminate this sheet which is a waste of paper.
  9. Y

    EXPORT SPECIFICATION NAME

    I AM TRYING TO CREATE A EXPORT SPECIFICATION NAME FOR MY MACRO. WHERE DO I CREATE A SPECIFICATION NAME TO EXPORT DATA VIA A MACRO TO A FIXED WIDTH TEST FILE?
  10. Y

    Check Box

    I have several check boxes setup in my form tied to data fields. If I check the box the table stores a text value of -1. I would like use the check box information in a report that would display a value other than -1. For example, if the data value is -1 then print the word "YES" blank would...
Top Bottom