Results 1 to 3 of 3
  1. #1
    JackieEVSC is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    70

    Parameter Query

    I have a SQL database with asset numbers that begin with an X (i.e. X80435 or X7147121, etc.) I'm trying to pull the information related to that specific asset tag, but when I scan it in the query it has a space after the last number and it doesn't find it.

    The query parameters are Like "*" & [Enter Asset Number] & "*". If I manually enter the asset tag, I get the information. If I scan the barcode with a scanner, I get nothing. I've reprogrammed the scanner to make sure it has a carriage return (and nothing else) after the scan.



    This is only a problem on one particular device, but we have about 16,000 of these devices, so it's a BIG problem. Is there any way I can scan a number and parse out any spaces at the end in a query?

    Thanks in advance for any help you can give me.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    EVEN with the spaces, it should find it with wildcards.
    Are you scanning into a record? Is it possible, when you scan, the record has not saved, therefore it cant find the #.
    The record MUST save before it can be seen.

  3. #3
    JackieEVSC is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    70
    It's not scanning to a record, it's the parameter for a query. It's the first of three queries to pull and format information. A form is based on the third query, but the information isn't written to the database until they press a button on that form. (Making the user click a button on that form gives the user time to review the information before it's written to the database.)

    Is there any way to accomplish this with a query?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 07-21-2015, 03:38 PM
  2. Replies: 1
    Last Post: 02-28-2013, 01:20 PM
  3. Replies: 3
    Last Post: 08-16-2012, 03:02 PM
  4. Replies: 13
    Last Post: 01-10-2012, 09:56 AM
  5. Parameter Query help...
    By daggy in forum Queries
    Replies: 1
    Last Post: 05-11-2010, 01:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums