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

    Update query only working on some records

    I bought a barcode font. The font needs an asterisk before and after the field. I have eight fields represented in barcode. All scan after printed except for one field, even though the data field is formatted identically ... "*" & [Table.Field] & "*" . The older records in the table format correctly and can be scanned ... it's only the new records that won't.

    I noticed that the field that won't scan does not have a * at the end. After beating my head against the wall I decided I'd run an update query to put the * before and after the data (figuring I could resort to running it in a macro before the form opens if need be), but it only worked on older records in the table. I get a * at the beginning and end of all the older records, but the new ones only have a * at the beginning ... it its not putting a start at the end.



    Does anyone have any idea why some records in the same table will NOT update? This is driving me batty!!! Thanks.

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Any chance you can put a stripped-down copy of your db here - with mock data, if necessary - so I can see the problem first-hand?

  3. #3
    JackieEVSC is offline Advanced Beginner
    Windows 7 32bit Access 2007
    Join Date
    Oct 2011
    Posts
    70
    I figured it out!! For some reason the data in the AS400 database is importing trailing spaces after the service tag data. I'm not sure why, since it didn't do that before. Once I figured that out, I used the "Trim" function in the data query to parse out the trailing spaces and the barcodes are scannable now. Very odd, but it's working now. Thank you for your offer to help!

  4. #4
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Ah! I work with data from AS400 too - and it has become almost second nature for me to use Trim on values coming out of there.
    I'm not sure why the spaces aren't removed before inserting.

    Glad you solved your problem!

    Happy trails!

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

Similar Threads

  1. Update query not updating records
    By toer121 in forum Queries
    Replies: 1
    Last Post: 08-25-2011, 07:08 AM
  2. Update Inner Joing Query not working??
    By snowmman99 in forum Access
    Replies: 2
    Last Post: 09-08-2010, 12:15 PM
  3. Replies: 2
    Last Post: 06-14-2010, 09:38 PM
  4. IIf Update Query working OK but a better way?
    By dreamweaver547 in forum Queries
    Replies: 7
    Last Post: 04-19-2010, 09:47 AM
  5. Update query for ID #s to link records
    By fspswen in forum Queries
    Replies: 0
    Last Post: 11-20-2009, 01:52 PM

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