Post by jacksch_ » Sun, 08 Feb 2004 04:29:06

I tryid to realize an e-shop with frames and parnet.value. It works.
But up to now it is a little bit long winded. So I have for every
text.field an parent.value like this:
parent.value = document.form.field1.value
Is it possible to implement with fields? So I would have a solution
with a for-loop.
Maybe someone could help me.

1. Field Property (OldValue) not available in Field Object defined with Dim As Field?

2. Calculated fields: Display Sum() of field X where FIELD Y is blah

Does this do it for you ---
SELECT tblOrderTrans.clubno AS Club,
& " - " &
Sum(IIf([tblOrderTrans]![ordmembact]=1,[tblOrderTrans]![ordvalue],0)) AS [Act
1 Orders],
& " - " &
Sum(IIf([tblOrderTrans]![ordmembact]=2,[tblOrderTrans]![ordvalue],0)) AS [Act
2 Orders], Count(IIf([tblOrderTrans]![ordmembact] Like
7,[tblOrderTrans]![ordmembact],Null)) & " - " &
Sum(IIf([tblOrderTrans]![ordmembact]=7,[tblOrderTrans]![ordvalue],0)) AS [Act
7 Orders]
FROM tblOrderTrans
WHERE (((tblOrderTrans.ordprodgrp)<>"Z"))
GROUP BY tblOrderTrans.clubno;

Build a little - Test a little

3. Joining fields into one field dependent on value of another field

4. Maybe problem still not solved, field.field.field should be possible to.

5. Adding fields to alert emails - any field or just canned fields?

6. Text Form Field, Check Box Form Field, Drop-Down Form Field

7. Fields within fields that cross-ref to other fields and do not upd

8. Help on Mailmerge field (field length) - field getting truncated

9. Print all fields following 10th field and selected fields - awk/sed/perl

10. Generate field(s) definition as Field Editor's "Add All fields" function ?

11. Showing table field in unbound field unbound field

12. text field to date field field

13. Maybe problem still not solved, field.field.field should be possible to.

14. 2 Related field or Auto fill up 2nd field after 1st field entered

15. On a report, print field A or field B based on value in field