Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. liloandstitch

    Adding fields from other tables

    HI, I've created a form in the form wizard using fields from one table, however now i'd like to add a field from another table. How do I go about seeing this table in the design view so I can add some fields from it? Thanks
  2. liloandstitch

    Validation rule

    Hi, I have a validation rule in which users must enter three letters followed by three numbers. I have the rule as 'aaa999'. However, when users enter data, the table lets them get away with three letters only. Shouldn't my validation rule make them enter the three letter/three number...
  3. liloandstitch

    If Statement Help

    Tried your new formula, although when i go to the form it still comes up with #name? Still not sure what's wrong but I definitely appreciate your help.
  4. liloandstitch

    Newbie help

    I've added the validation rule so thankyou!!! Still not sure about the relationship problem. I have a stock table which is made up of two primary keys, DistrNo and SerialNO. The Lineitem has these two fields in it (DistrNo and SerialNo) and it specifies that the DistrNo in LineItem is the...
  5. liloandstitch

    If Statement Help

    I don't want to do this via vb, rather then an if statement in the control source. This is basically what I have now, but it doesn't seem to be working... =IIf([DiscountType]=[P],[NEW PRICE]=[SalePrice]-[Discount],[NEW PRICE]=[SalePrice]*([Discount]/100)) What I'm trying to say is if discount...
  6. liloandstitch

    Newbie help

    Couple of questions. I have a table in which I have types doubles and integers. I need to make sure the length of these fields are certain lengths, eg the integer length is 4 and double length is 7. There is no field in which to specifify this, so do I specify it via an input mask? I also have a...
  7. liloandstitch

    If Statement Help

    Hi, I've designed a form which has a few field in it, three of which are Sale Price, Discount and Discount type. A user will enter the sale price, Discount type ("F" for a dollar discount or "P" for a percentage discount), and also enter the actual discount. I need a field in...

Part and Inventory Search

Back
Top