Recent content by flap14

Hi I have an Orders database for which I set the Order_ID field to autonumber. The I screwed up playing around and now Purchase Order 0001 has Order_ID number 2. Is there an equation/expression I can put in the Validation rule that will make my PO number = Order_ID minus 1? Thanks

Hi I have what is probably a stupid question but I've been struggling with this one for a while. I have an ordering database which has an Orders table (containing Order ID, Date, Supplier etc) and an Order Line table within which I have a combo box for Product name, supplier, price, VAT rate...

I am indeed, the field remains containing a value on screen but with a value of 0 in print preview, pdf and on paper :banghead:

Actually, have just created a report to mimic the form and the same thing is happening. I've double-checked the table and the field is set to Currency and the default value is 0

I do agree with that post but I still don't understand why this is happening. Basically the currency value is there on the screen and in the relevant table, it just doesn't appear once printed. I've checked the 'display when' field in the property sheet but that's fine. Any ideas would be most...

Bob Yes, the delivery fee is in the Order line table upon which the subform is based

Hi I have an Ordering database where the order form contains a subform with the order lines (Order_line_subfrm). In this subform footer I have 4 currency fields, one f which is delivery fee (default is set to zero). When I add a fee into this field on screen, everything works (i.e. adds up) and...