Hi,
I have on Form three Fields:
Field1 Value *123456*72.47*
I need to split that value following to:
Field2 Value 123456
Field3 Value 72.47
Can somebody help.
Thank's in advance
Thank You OnTheFly.
It's working fine.
I have on more question.
I will try to hide subform content using CheckBox (placed on MainForm).
If ChekBox=True the subform must be unvisible.
How to do it?
Bob
Hi,
I have a check box in form and a subform.
If check box value is True, subform must be unvisible.
And If check box value is False, subform is visible.
Can somebody help to dissolve above described.
Thank's in advance.
Hi,
I have a subform (in DateSheet)on form.
If by condition in one field in Subform row
(DateDiff>=30) I need to paint in Yellow colour all that rows where this condition is true.
Thank's in advance,
Bob
Hi,
Value in Field2 I enter manualy.
Date-month.
Field1-Counter messure for last month.
Field2-Counter messure for this month.
Field3-Diff=[Field2]-[Field1].
ID Date Field1 Field2 Diff
1 01.07.04 100 200 100
2 01.08.04 200 350 150
Regards,
Bob
Skip,
Thank's for help.
The value from current record Field2 must be assigned (copied) to Field1 for the next record.This operation for each next record.
And we can use only one table.
The amount of records will be grow till 1000.
I'm novice in VBA.
Please help dissolve my question.
Bob
Hi,
I have a one table T1:
ID 1
Date 01.07.04
Field1 A
Field2 B
How to assign Field2 value "B" to Field1 for the next record ?
Next records must look so:
ID 2
Date 01.08.04
Field1 B
Field2 C
ID 3
Date 01.09.04
Field1 C
Field2 D
e.t.c...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.