By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,475 Members | 954 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,475 IT Pros & Developers. It's quick & easy.

No input updating

P: n/a
TTD
Hi,

I have a form (input type) which is based on a table. Let's say it has 2
fields

1: numeric keyfield
2: textfield.

When the form opens the numeric is automatically added with 1. When I leave
the textfield empty and I close the form, the database is being written. Bu
tI don't want that to happen, if the textfield is empty.

With which command can I prevent Access from writing to the table when I
close the form?

Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Are you saying - if the text is not completed then do not save the record???

You could make the textfield compulsory or you could write a little code
that would undo the changes to the numeric field if the text field is not
completed

Thirdly, you could unlink the numeric field and add the data from the
numeric field using SQL if the text field is completed.

Let me know which one sounds best and I will provide more details.
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...
Hi,

I have a form (input type) which is based on a table. Let's say it has 2
fields

1: numeric keyfield
2: textfield.

When the form opens the numeric is automatically added with 1. When I leave the textfield empty and I close the form, the database is being written. Bu tI don't want that to happen, if the textfield is empty.

With which command can I prevent Access from writing to the table when I
close the form?

Thanks in advance.

---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
Nov 12 '05 #2

P: n/a
TTD
Hi WaW

I don't want to make the textfield compulsary. If the user enters the form
by accident or cahnges his mind and want to leave, then I don't want him to
be bothered by Access.

Undo the changes to the numeric field would be fine. (though unlinking
sounds also interesting).

Thanks in advance

"WindAndWaves" <ac****@ngaru.com> schreef in bericht
news:0Q*******************@news.xtra.co.nz...
Are you saying - if the text is not completed then do not save the record???
You could make the textfield compulsory or you could write a little code
that would undo the changes to the numeric field if the text field is not
completed

Thirdly, you could unlink the numeric field and add the data from the
numeric field using SQL if the text field is completed.

Let me know which one sounds best and I will provide more details.
"TTD" <tt*@hotmail.com> wrote in message
news:c8***********@beast.euro.net...
Hi,

I have a form (input type) which is based on a table. Let's say it has 2
fields

1: numeric keyfield
2: textfield.

When the form opens the numeric is automatically added with 1. When I leave
the textfield empty and I close the form, the database is being written.

Bu
tI don't want that to happen, if the textfield is empty.

With which command can I prevent Access from writing to the table when I
close the form?

Thanks in advance.

---
Please immediately let us know (by phone or return email) if (a) this

email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.