Datasheet View - Text clear

[Guest]

Hi,

Could anybody solve this problem?

I need to show Form in Datasheet view where all the fields need to be clear
except Autonumber field.

To explain you further, When i open form in Datasheet view, whatever the
data i used before, it is coming again when i re-open.

In the Form(Datasheet view) i have used Autonumber field. Hence, When i open
again the default value of the autonumber ONLY should come. Rest data
whatever we used earlier need to be clear.

I used below code in 'Form load' where it shows some error.

Text1.text = "" / Text1.value = ""
Combo1.value = ""

Pls.suggest me

ngr.

 

[Graham R Seach]

I need to ask why you want to do that? Do you want only one record
displayed, or do you want to be able to overwrite all the existing record?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Guest]

Hi,

Thanks a lot to understand my problem...

1. Actually, I need to enter the data in Datasheet view as a input which
will be stored into the table. When i enter, if the previous data is
existing, i would need to enter under the existing records which would cause
increase the lines and which will be inconvenient to see. Hence, if the data
is current record, it will be convenient to enter as well as visible.

2. I need to show only one record which is current record. It means the
autonumber of current number shall come & stand.

3. No,I dont need to overwrite.

Thanks in advance..

ngr

 

[AccessVandal via AccessMonster.com]

Hi,

It's not possible to use a form in datasheet for searching records.
And remove that two lines in the form's load event, it does nothing.

Unless the you insert its as a subform, using the main unbound form as a
search tool.

solar wrote:
Hi,

Thanks a lot to understand my problem...

1. Actually, I need to enter the data in Datasheet view as a input which
will be stored into the table. When i enter, if the previous data is
existing, i would need to enter under the existing records which would cause
increase the lines and which will be inconvenient to see. Hence, if the data
is current record, it will be convenient to enter as well as visible.

2. I need to show only one record which is current record. It means the
autonumber of current number shall come & stand.

3. No,I dont need to overwrite.

Thanks in advance..

ngr

I need to ask why you want to do that? Do you want only one record
displayed, or do you want to be able to overwrite all the existing record?

[quoted text clipped - 28 lines]

 

[Graham R Seach]

Sorry for not getting back to you earlier; I've been very busy.

I'm afraid I still don't understand what you're trying to do. First you say
you want to use a datasheet; then you say you only want to see the current
record. In that case, a datasheet seems pointless.

I'm not able to understand what you're trying to say in the remainder of
your text. I'm guessing you've use a translation service. What is your
native language? Perhaps if you write your question in your language, there
may be someone here who understands that language.

Don't give up - just try again.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia