Search results

  1. A

    Setting up proper relationships

    Hello Everyone. I need some help of setting up the proper realtionships in a few tables. I am new to access so am still trying to get my head around these sort of problems. I have, to keep it simple 3 table ItemList ItemSpecification Packaging I thought it would be a good idea to setup...
    • Argi
    • Thread
    • Replies: 17
    • Forum: Tables
  2. A

    Updating Form Fields From Table

    Hello Everyone. I was wondergin if anyone knows how i can update my fomr fields when selecting a combobox value. For example i have a table that has say these fields ItemNo ItemWeight ItemDescription It is the primary table for ItemNo and has refernetial integrity checked as well as...
    • Argi
    • Thread
    • Replies: 19
    • Forum: Forms
  3. A

    Calculating check digit - no MOD in Access

    Thank you for the great infromation.
  4. A

    Combining Multiple Fields On Form

    Thanks for the good info.
  5. A

    Link tables and form

    Hi All. I have tables T1 and T2, fields F1 and F2 exist in T1 as well as T2, i also have created a from called FRM1. T1 is th table i use to enter data that does nto change that often, T2 is the table with most of the data and also includes the fields of T1. I use a combo box in FRM1...
    • Argi
    • Thread
    • Replies: 0
    • Forum: Forms
  6. A

    Calculating check digit - no MOD in Access

    Got it working, thanks. Created new field and referenced field using Mod 10 and it worked, thanks for the pointers.
  7. A

    Calculating check digit - no MOD in Access

    Guys i have no idea hwo to create a function, so maybe i need to try to get the Mod thing working. 247 Mod 10 does return 7 and this is the result i want however myexpression returns the sum of 89. If i do this Myexpression Mod 10 it returns 79 instead of 9 =(Mid([UPC Zeea...
  8. A

    Combining Multiple Fields On Form

    Thank you it worked nicely.
  9. A

    Calculating check digit - no MOD in Access

    Hello All, i am trying to calculate check digit, have it working fine with 1 glitch, when check digit is 0 my formula brings back a value of 10 as 10-0 is 10. I will paste formula, i know it is way over kill but keep in mind i am very new to Access and i had to figure this one out on my own...
    • Argi
    • Thread
    • Replies: 8
    • Forum: Forms
  10. A

    Combining Multiple Fields On Form

    Need some help. I am combining 3 fileds or at least trying to. Two of them are Text fields with numberic values the thirs is a calculated field. Field 1 is COMPANYUPC (6 digits) field 2 IS PRODUCTCODE (5 digits) filed 3 IS CHECKDIGIT (1 digit) I tried "filed 1 + field 2 + field 3" but it...
    • Argi
    • Thread
    • Replies: 3
    • Forum: Forms
  11. A

    New To Access

    Hi All. I am new to Access. Found myslef often referring to this forum for information so i decided to sign up. It seems like there are some very helpfull and knowledgeable members, glad to see so many helping hands. Thanks for having me.
View older results
Back
Top Bottom