Recent content by CanadianROCK

  1. C

    Bar code scanner input to specific fields

    Populated the Large Gum field with what? each time scanned in current record +1 scan item twice field now shows 2 large gum What determines if the scanned code identifies a stick belonging to the class of Large Gum? I have a query that does that Is it part of the code or do you...
  2. C

    Bar code scanner input to specific fields

    Hello Friends I have a Honeywell Eclipse model MS5145 bar code scanner working with Access Using it to scan client's ID's with bar codes I print and stick onto a ID card works great .. So I have the bar code scanner working with MS Access What I would like to achieve is, Scan a bar code...
  3. C

    Command Button to add value

    My bad paul .. I started with a fresh copy of DB ...And it all works except the ones with " ' " comma in them like 20's and 25's now I assume I have to brackets those ? I tried changing 20'2 ext in table and have the changes populate threw out DB Best i came up with a lookup for...
  4. C

    Command Button to add value

    Seems no matter what i do I error out .. even using "()" brackets I get erros depending of course where I use the brackets or closed brackets .. just get various errors Did manage to change out the 20, 25 etc .. manually went threw DB and changed dependencies
  5. C

    Command Button to add value

    Hi Paul .. Thank you for the Hint towards the solution .. itried the "[]" Brackets .. I either get end of statement ot syntax error . Im reading OH and am going to to remove all the " ' " in my 20's 25's ETC .. TIA Russell
  6. C

    Command Button to add value

    I'm on the road so I can't Rember the error but I get an error Thank you so much all the help Paul Regards Russell
  7. C

    Command Button to add value

    The main form I use is Customer Information Center It should auto open .. the testing card number I use is 123456 but you can use any from table Customers .. I know it's a little or alot rough around the edges But i was and still am on the learning curve Thank You In Advance...
  8. C

    Command Button to add value

    Thank You so very much .. works as I wanted it to But have a small glitch I have a total of 16 fields I use to enter data However very sporadically it will show the entered data in this case "1" then when I click in another field it won't show the value .. unless I either click again to...
  9. C

    Command Button to add value

    I read up on brackets .. good read .. head hit the keyboard a few times .. But part of the curve .. I read up on brackets and closed brackets Also read up on spaces .. SO I tried Underscore for the spaces in Special_Order didn't get any errors when debug .. But didn't work either SO on...
  10. C

    Command Button to add value

    Ok .. Sorry but I get Compile error In source properties Under Mouse down I placed Private Sub Special_Order_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Me.Special Order = Me.Special Order + 1 End Sub Special Order being control source .. I get Compile...
  11. C

    Command Button to add value

    Hrmm I tried something close to that a few days ago .. thought I had it all figured out .. was about to promote myself 2nd level FAIR Access user .. Not so sure now .. Want to click on What was a textbox I will make it a button Want to click button have input of +1 for each click...
  12. C

    Command Button to add value

    I have a form that users input data .. Example "NAME" Crayons Pack of 20 with input field user would enter how many units they sell example 1 or 2 or 3 What i would like is Instead of selecting input field and typing in 1 or 2 or 3 Units sold A command button that each time you...
  13. C

    Howdy Ya'll

    Hello .. Russell here from beautiful Victoria BC Canada I'm a fair MS Access user .. have created some fairly advanced DB's Hobbies are Hunting "just trying to get back in to it " and Computers .. Looking forward to be part of this forum . Regards Russell
See more
Back
Top Bottom