Recent content by vaughanmcd

  1. V

    Query return characters upto first space

    Genius , Thank you
  2. V

    Query return characters upto first space

    It works when there is two or more string with spaces, But errors when there is a single string with no spaces. Is there a way to just copy it over if its a single string aswell in the same fuction? eg: BLS208 = BLS208 00110 0022018 = 00110 At the moment the query says conversion error when it...
  3. V

    Query return characters upto first space

    Yes that work perfect, Thanks
  4. V

    Query return characters upto first space

    Hi I need to return charters upto the first space. Some of the lines have more than one space. eg: LG-LIP-9024WMB 0021812 I want LG-LIP-9024WMB or 9414894016190 FSHVE1260GL-FR 0021032 I want 9414894016190 or MS14 0029180 I want MS14 I tried this but not working New Supplier Part: Left([Search...
  5. V

    Continuous form search

    Hi been playing around with the VBA code , but my knowledge of this is poor. I'm wanting to have the check box on the form to filter to show only Inventory Items that have been marked as True and the refresh the list. Then the same in reverse, If the user takes the check mark off then list is...
  6. V

    Continuous form search

    Just to explain the check box a bit further , I was hoping to tie the check box in so that if the user checked it the filter would only include records with True in the Inventory Item column. See my attachment screen shot. Thanks
  7. V

    Continuous form search

    Hello I have this bit of code for a search on a continuous form and it is working , I want improve it a bit by adding a check box to only include a predefined word in the data on the form "True" How would I change the code to allow the results to only include records with the word "True" from...
See more
Top Bottom