Search results for query: *

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

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...

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.

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...

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...

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...

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...