Adding new field in form.

[aligahk06]

Dear All,

i have a existing table and i added two new fields in existing table.Now i want to add the newly added fields to my form.While opening the form in design view i added the field but the added field and their corresponding label could not be adjusted according to desired location.



Please advise how could i add the newly added fields in my form and could adjust the field according to desired place.

Please assist..

rgds,
aligahk06

[Bob Fitz]

...could not be adjusted according to desired location.....

Do you mean that you can not resize the controls or move their position on the form.

[aligahk06]

yes , I can't resize and move thier position according to my position.

[Bob Fitz]

Can you post a copy of the db

[aligahk06]

Sir,

DB attached .
1. I want sdays control and expr1 control appear in form design view.
2. i want an expression in sdays field value sothat it calculate how many days from drain date and current date.
3. if refilldate field value entered then it shows in expr1 the text open.
4. All control data appear in landscape view for print the form if required.
Please assist,

thank you..

[Bob Fitz]

Sir,

DB attached .
1. I want sdays control and expr1 control appear in form design view.
2. i want an expression in sdays field value sothat it calculate how many days from drain date and current date.
3. if refilldate field value entered then it shows in expr1 the text open.
4. All control data appear in landscape view for print the form if required.
Please assist,

thank you..

You have not attached the db

[aligahk06]

Please find in original post.

[Bob Fitz]

There's not much that I can do with a db that's password protected

[aligahk06]

password : cc6432

[Bob Fitz]

Sir,

1. I want sdays control and expr1 control appear in form design view.
2. i want an expression in sdays field value sothat it calculate how many days from drain date and current date.
3. if refilldate field value entered then it shows in expr1 the text open.
4. All control data appear in landscape view for print the form if required.
Please assist,

thank you..

1) I don't understand your problem here. I had no problem in dragging fields from the "Existing Fields List" to the Detail section of the form. I was also able to create new controls, resize them, move them and bind them to fields in the forms Record Source.

2) Use:
=DateDiff("d",[Drained Date],Date())
as the Control Source property of a text box on the form.
The field called "sdays" in the table is not required because you would not usually save calculations to an field in a table. The calculation should be done whenever and wherever it is required.

3) Sorry, I don't understand your requirement

4) Printing data is usually done with a report.

[aligahk06]

Sir,
thank you i did as per ur guidance.

[mike60smart]

Hi

PMFJI but I would imagine you are carrying out services on Drains for a Tenant.

If this is the case then you need more than 1 Table.

You need a table for the Tenants Details and another for the multiple times that the Drains are Cleared.

[Bob Fitz]

Sir,
thank you i did as per ur guidance.

Another couple of things for your consideration......

I think you have the wrong Control Source settings for the checkboxes?
In any case, you might want to remove the field "DrainedClose" from the table. If "DrainedDate" has a value then then surely "DrainedClosed" is True and vice versa.
My guess is that the same would apply to the field called "RefillOpen".

[ssanfu]

I would add that the Tenant name should be 2 fields. It is hard to split the name into first and last names if you want to sort/print by last name.


BTW - "Tenent" should be "Tenant".

Tenent was the common spelling in the 1600s for tenet, which was defined as a belief or principle.