How to clear form fields on loading?

[David Jarman]

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

[Arno R]

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

[David Jarman]

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

[Arno R]

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

[Larry Linson]

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

[David Jarman]

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
>
>

[David Jarman]

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
>
>