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

How to clear form fields on loading?

P: n/a
I'm a Newbie to this group and would be grateful for assistance as I get up
to speed.

I'm working on my first Access project and need to be able to 'clear' fields
on a form when first loaded. Access seems to want to display a record in the
newly opened form. The form is for 'Amend' only (ie no create new record or
delete) and the user should specify the record to be worked on, rather than
the system supplying information which has to be overtyped/cleared.

This is probably an easy one but I haven't found a solution in my
documentation yet!

Thanks in anticipation and Seasons Greetings etc

David
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
David,
Look at the properties of your form
Set DataEntry to Yes
--
Hope this helps
Arno R
"David Jarman" <da****@jarman.co.uk> schreef in bericht
news:bs***********@ID-128884.news.uni-berlin.de...
I'm a Newbie to this group and would be grateful for assistance as I get up
to speed.

I'm working on my first Access project and need to be able to 'clear' fields
on a form when first loaded. Access seems to want to display a record in the
newly opened form. The form is for 'Amend' only (ie no create new record or
delete) and the user should specify the record to be worked on, rather than
the system supplying information which has to be overtyped/cleared.

This is probably an easy one but I haven't found a solution in my
documentation yet!

Thanks in anticipation and Seasons Greetings etc

David

Nov 12 '05 #2

P: n/a
Hi Arno

Many thanks - I set the Property 'DataEntry' to 'Yes' and then allowed
additions. The form then worked OK. Could you recommend a book to help me
get into Access quickly?

Seasons Greetings

David

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
David,
Look at the properties of your form
Set DataEntry to Yes
--
Hope this helps
Arno R
"David Jarman" <da****@jarman.co.uk> schreef in bericht
news:bs***********@ID-128884.news.uni-berlin.de...
I'm a Newbie to this group and would be grateful for assistance as I get up to speed.

I'm working on my first Access project and need to be able to 'clear' fields on a form when first loaded. Access seems to want to display a record in the newly opened form. The form is for 'Amend' only (ie no create new record or delete) and the user should specify the record to be worked on, rather than the system supplying information which has to be overtyped/cleared.

This is probably an easy one but I haven't found a solution in my
documentation yet!

Thanks in anticipation and Seasons Greetings etc

David


Nov 12 '05 #3

P: n/a
David,
The Access <your version> Developers Handbook is almost a 'Must' for serious programming.
But if you are a 'starter' then this is way too difficult.
Search this group a bit on Google for more book recommandations at different levels.

--
Hope this helps
Arno R
"David Jarman" <da****@jarman.co.uk> schreef in bericht
news:bs***********@ID-128884.news.uni-berlin.de...
Hi Arno

Many thanks - I set the Property 'DataEntry' to 'Yes' and then allowed
additions. The form then worked OK. Could you recommend a book to help me
get into Access quickly?

Seasons Greetings

David

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
David,
Look at the properties of your form
Set DataEntry to Yes
--
Hope this helps
Arno R
"David Jarman" <da****@jarman.co.uk> schreef in bericht
news:bs***********@ID-128884.news.uni-berlin.de...
I'm a Newbie to this group and would be grateful for assistance as I get up to speed.

I'm working on my first Access project and need to be able to 'clear' fields on a form when first loaded. Access seems to want to display a record in the newly opened form. The form is for 'Amend' only (ie no create new record or delete) and the user should specify the record to be worked on, rather than the system supplying information which has to be overtyped/cleared.

This is probably an easy one but I haven't found a solution in my
documentation yet!

Thanks in anticipation and Seasons Greetings etc

David



Nov 12 '05 #4

P: n/a
A good book for the "complet novice" is Microsoft Press' "Microsoft Access
<versionnumber> Step by Step"; a good next book is Microsoft Press'
"Microsoft Access <versionnumber> Inside Out" (the Access 2003 edition is by
MVP John Viescas or Que's "Special Edition - Using Microsoft Access
<versionnumber>" by Roger Jennings, and then, as a deskside companion
reference for the developer, "Access <versionnumber> Developer's Handbook"
by Litwin, Getz, et al, published by Sybex. There are (many, many) other
good books, but these are some with which I am personally familiar.

Larry Linson
Microsoft Access MVP

"David Jarman" <da****@jarman.co.uk> wrote in message
news:bs***********@ID-128884.news.uni-berlin.de...
Hi Arno

Many thanks - I set the Property 'DataEntry' to 'Yes' and then allowed
additions. The form then worked OK. Could you recommend a book to help me
get into Access quickly?

Seasons Greetings

David

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
David,
Look at the properties of your form
Set DataEntry to Yes
--
Hope this helps
Arno R
"David Jarman" <da****@jarman.co.uk> schreef in bericht
news:bs***********@ID-128884.news.uni-berlin.de...
I'm a Newbie to this group and would be grateful for assistance as I
get
up to speed.

I'm working on my first Access project and need to be able to 'clear' fields on a form when first loaded. Access seems to want to display a record
in
the newly opened form. The form is for 'Amend' only (ie no create new
record
or delete) and the user should specify the record to be worked on, rather than the system supplying information which has to be overtyped/cleared.

This is probably an easy one but I haven't found a solution in my
documentation yet!

Thanks in anticipation and Seasons Greetings etc

David



Nov 12 '05 #5

P: n/a
Many thanks for your advice Larry. Will follow up on the information.

Happy New Year!

David

"Larry Linson" <bo*****@localhost.not> wrote in message
news:2g*****************@nwrddc03.gnilink.net...
A good book for the "complet novice" is Microsoft Press' "Microsoft Access
<versionnumber> Step by Step"; a good next book is Microsoft Press'
"Microsoft Access <versionnumber> Inside Out" (the Access 2003 edition is by MVP John Viescas or Que's "Special Edition - Using Microsoft Access
<versionnumber>" by Roger Jennings, and then, as a deskside companion
reference for the developer, "Access <versionnumber> Developer's Handbook"
by Litwin, Getz, et al, published by Sybex. There are (many, many) other
good books, but these are some with which I am personally familiar.

Larry Linson
Microsoft Access MVP

"David Jarman" <da****@jarman.co.uk> wrote in message
news:bs***********@ID-128884.news.uni-berlin.de...
Hi Arno

Many thanks - I set the Property 'DataEntry' to 'Yes' and then allowed
additions. The form then worked OK. Could you recommend a book to help me get into Access quickly?

Seasons Greetings

David

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
David,
Look at the properties of your form
Set DataEntry to Yes
--
Hope this helps
Arno R
"David Jarman" <da****@jarman.co.uk> schreef in bericht
news:bs***********@ID-128884.news.uni-berlin.de...
> I'm a Newbie to this group and would be grateful for assistance as I get
up
> to speed.
>
> I'm working on my first Access project and need to be able to
'clear' fields
> on a form when first loaded. Access seems to want to display a
record in
the
> newly opened form. The form is for 'Amend' only (ie no create new

record
or
> delete) and the user should specify the record to be worked on,

rather than
> the system supplying information which has to be overtyped/cleared.
>
> This is probably an easy one but I haven't found a solution in my
> documentation yet!
>
> Thanks in anticipation and Seasons Greetings etc
>
> David
>
>



Nov 12 '05 #6

P: n/a
Thanks for your advice Arno. Will follow up on this.

Happy New Year!

David

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
David,
The Access <your version> Developers Handbook is almost a 'Must' for serious programming. But if you are a 'starter' then this is way too difficult.
Search this group a bit on Google for more book recommandations at different levels.
--
Hope this helps
Arno R
"David Jarman" <da****@jarman.co.uk> schreef in bericht
news:bs***********@ID-128884.news.uni-berlin.de...
Hi Arno

Many thanks - I set the Property 'DataEntry' to 'Yes' and then allowed
additions. The form then worked OK. Could you recommend a book to help me get into Access quickly?

Seasons Greetings

David

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
David,
Look at the properties of your form
Set DataEntry to Yes
--
Hope this helps
Arno R
"David Jarman" <da****@jarman.co.uk> schreef in bericht
news:bs***********@ID-128884.news.uni-berlin.de...
> I'm a Newbie to this group and would be grateful for assistance as I
get up
> to speed.
>
> I'm working on my first Access project and need to be able to
'clear' fields
> on a form when first loaded. Access seems to want to display a
record in the
> newly opened form. The form is for 'Amend' only (ie no create new
record or
> delete) and the user should specify the record to be worked on,
rather than
> the system supplying information which has to be overtyped/cleared.
>
> This is probably an easy one but I haven't found a solution in my
> documentation yet!
>
> Thanks in anticipation and Seasons Greetings etc
>
> David
>
>



Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.