Solved Urgent .. How To Remove The Last Record with * Mark In Datasheet Form Which Appears Automaticly ?

[Safari]

Hi ,

Urgent .. How To Remove The Last Record with * In Datasheet Form Which Appears Automaticly ?

THANKS

 

[Minty]

Hi, and welcome to AWF!

Set the form to not allow new records.

 

[Safari]

Hi, and welcome to AWF!

Set the form to not allow new records.

its prevent add records at all ..
i want to add records if i need that .. not to prevent add at all

 

[Gasman]

So switch it off and on as needed.?

 

[Safari]

Please provide a better explanation of your problem..

i want to add records if i need that .. not to prevent add at all

 

[Safari]

So switch it off and on as needed.?

i want to add records if i need that .. not to prevent add at all

 

[Minty]

You can't have both without some form of control to switch between the two modes of operation.

How are you opening the datasheet form, from another form?
If so you can specify how the form opens - Adding new records, or not.

 

[Gasman]

Ok, so you have a button Add, when clicked you enable addtions and change the caption to Save.
After you have added all the records your want, click Save, change the caption back to Add, and disable addtions.?

It is a feature of Access!

 

[arnelgp]

remove the Default Value (0) in table design.

 

[Safari]

You can't have both without some form of control to switch between the two modes of operation.

How are you opening the datasheet form, from another form?
If so you can specify how the form opens - Adding new records, or not.

i open datasheet as sub form
i add data in main form then add anther data to sub form
i want after i add all data i need not to appear new record .
thanks

 

[mike60smart]

You have the correct configuration of a Main Form with a Subform to add records.

The default blank new record line is how access works.

Why do you need to hide the blank new record line?

 

[Safari]

You have the correct configuration of a Main Form with a Subform to add records.

The default blank new record line is how access works.

Why do you need to hide the blank new record line?

yeah .. i want to disable add new record automaticly

 

[mike60smart]

As it has been explained earlier, Access will not do that for you.

 

[Safari]

As it has been explained earlier, Access will not do that for you.

mmm .. thanks for your kind efforts

 

[Minty]

i want after i add all data i need not to appear new record .

Ask yourself - how will Access know you have entered all your subform data? It's not omnipotent (unfortunately) .

If there is a logical process that can work out when you have entered all your data, then you could possibly automate the switching off of the <New> record entry.

 

[Gasman]

Have you tried arnelgp's suggestion in post #11 ?

 

[Safari]

yeah ... not working

 

[The_Doc_Man]

i want after i add all data i need not to appear new record .

You know how to decide when you have added all the data you need. If Access could recognize this situation then you could have it reset the sub-form to no longer allow adding new data. But if Access has no way to recognize that you have "all the data you need" then it won't do it. Access is an automaton, not a genius or a mind-reader. If you can define a test for the "added all the data you need" condition then Access can act on it.

 

[Safari]

thanks

 

[arnelgp]

did you come up with a solution?