Search results

  1. I

    Adding leading zero's to numbers in a field

    Hi All Is there an easy way to add leading zeros to existing numbers in a field? Example:00001562 or 00054621 (always 8 characters) when entering the numbers manually I don't have a problem but if I import from a spread sheet, access removes the leading zeros. I have tried setting...
  2. I

    Question Entering data into a form

    PS, the label thing didn't work..
  3. I

    Question Entering data into a form

    All works well but I have one more problem. I now have an item with a barcode that consists of 10 characters. How do I edit your code to allow 15 and 10 character barcodes? Many huge thanks.. Private Sub txtbarcode_BeforeUpdate(Cancel As Integer) 'check code is of right length -...
  4. I

    Question Entering data into a form

    Will test this soon and let you know if all was ok. Many thanks...
  5. I

    Question Entering data into a form

    CJ, I bow to your superior knowledge. However, I inserted the code and the results were as follows: when I scanned a barcode with less than 15 characters, I was presented with the message box "Scanned Wrong code", great, that's what I expected. When I scanned the correct code (The middle one on...
  6. I

    CREATING DROP-DOWN LISTS ON QUERIES

    Can you have the command button open a report showing data collected from running the query?
  7. I

    Question Entering data into a form

    Here is one for you brain boxes... I have a form into which I scan a serial number in one of its text boxes, I can then select search and am presented with a report relating to that serial number. All simple so far. Now for the dilemma... The barcode I scan consists of 15 characters like so...
  8. I

    problem using navigation form

    Thanks JHB I see you added some code to the search button..... Is that all you did? Iann
  9. I

    problem using navigation form

    Ok JHB, i guess i should have attached more info. I have attached the database in question for your reference. when, its still work in progress. Open the navigation form, when open you get the 'Allocate Serial Numbers' subform, from here I can search for info relating to a serial number by...
  10. I

    problem using navigation form

    Hi All I' a newbie to access and need help with a problem. I have a search for that runs a query to list info related to a serial number, this works fine when opened on its own. The problem I have is when I insert it into a navigation form it comes up with an error when hitting search. the...
View older results
Back
Top Bottom