coding a event to make a form to "allow edits"

[Dave]

Access 2003
So I have a data entry form that does not ally edits.
My MO in the past was to create a duplicate form for users to make edits to
that data.

I think this is probably novice approach.

I would like to code and event (Double click) to open the same form but
turning on "Allow Edits"

I need help with the syntax of that line of code.

thanks

 

[Graham Mandeno]

Hi Dave

You can simply say:
Me.AllowEdits = True (or False)

However, this will also affect unbound controls on your form. If this is a
problem, then Allen Brown has a nice little function on his website that
locks (or unlocks) only the bound controls:
http://allenbrowne.com/ser-56.html

 

[Dave]

Thanks for the reply:
Can I assume that doing ti this way would require I turn it back off when I
close the form?

dave

Hi Dave

You can simply say:
Me.AllowEdits = True (or False)

However, this will also affect unbound controls on your form. If this is
a problem, then Allen Brown has a nice little function on his website that
locks (or unlocks) only the bound controls:
http://allenbrowne.com/ser-56.html

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Access 2003
So I have a data entry form that does not ally edits.
My MO in the past was to create a duplicate form for users to make edits
to that data.

I think this is probably novice approach.

I would like to code and event (Double click) to open the same form but
turning on "Allow Edits"

I need help with the syntax of that line of code.

thanks

 

[fredg]

Thanks for the reply:
Can I assume that doing ti this way would require I turn it back off when I
close the form?

dave

Hi Dave

You can simply say:
Me.AllowEdits = True (or False)

However, this will also affect unbound controls on your form. If this is
a problem, then Allen Brown has a nice little function on his website that
locks (or unlocks) only the bound controls:
http://allenbrowne.com/ser-56.html

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Access 2003
So I have a data entry form that does not ally edits.
My MO in the past was to create a duplicate form for users to make edits
to that data.

I think this is probably novice approach.

I would like to code and event (Double click) to open the same form but
turning on "Allow Edits"

I need help with the syntax of that line of code.

thanks

Any reason why you haven't just tried it?
You would have had your answer already.

 

[Graham Mandeno]

No, the form will open next time with the default setting that it was saved
with.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Thanks for the reply:
Can I assume that doing ti this way would require I turn it back off when
I close the form?

dave

Hi Dave

You can simply say:
Me.AllowEdits = True (or False)

However, this will also affect unbound controls on your form. If this is
a problem, then Allen Brown has a nice little function on his website
that locks (or unlocks) only the bound controls:
http://allenbrowne.com/ser-56.html

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Access 2003
So I have a data entry form that does not ally edits.
My MO in the past was to create a duplicate form for users to make edits
to that data.

I think this is probably novice approach.

I would like to code and event (Double click) to open the same form but
turning on "Allow Edits"

I need help with the syntax of that line of code.

thanks

 

[Dave]

Well that is a good point.

it came to mind as I was answering the post.
Maybe I should not have been so quick to reply.

dave

Thanks for the reply:
Can I assume that doing ti this way would require I turn it back off when
I
close the form?

dave

Hi Dave

You can simply say:
Me.AllowEdits = True (or False)

However, this will also affect unbound controls on your form. If this
is
a problem, then Allen Brown has a nice little function on his website
that
locks (or unlocks) only the bound controls:
http://allenbrowne.com/ser-56.html

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Access 2003
So I have a data entry form that does not ally edits.
My MO in the past was to create a duplicate form for users to make
edits
to that data.

I think this is probably novice approach.

I would like to code and event (Double click) to open the same form but
turning on "Allow Edits"

I need help with the syntax of that line of code.

thanks

Any reason why you haven't just tried it?
You would have had your answer already.

 

[Dave]

Thanks Graham,

I have actually gone another direction with this. Less code, 1 form.

Thanks for your replies.

dave

No, the form will open next time with the default setting that it was
saved with.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Thanks for the reply:
Can I assume that doing ti this way would require I turn it back off when
I close the form?

dave

Hi Dave

You can simply say:
Me.AllowEdits = True (or False)

However, this will also affect unbound controls on your form. If this
is a problem, then Allen Brown has a nice little function on his website
that locks (or unlocks) only the bound controls:
http://allenbrowne.com/ser-56.html

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Access 2003
So I have a data entry form that does not ally edits.
My MO in the past was to create a duplicate form for users to make
edits to that data.

I think this is probably novice approach.

I would like to code and event (Double click) to open the same form but
turning on "Allow Edits"

I need help with the syntax of that line of code.

thanks

 

[Graham Mandeno]

Hi Dave

I'm glad you've got it nailed.

However, I'm intrigued how you can do it with "less code" than a single
line:
Me.AllowEdits = Not Me.AllowEdits

--


Graham Mandeno [Access MVP]
Auckland, New Zealand

Thanks Graham,

I have actually gone another direction with this. Less code, 1 form.

Thanks for your replies.

dave

No, the form will open next time with the default setting that it was
saved with.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Thanks for the reply:
Can I assume that doing ti this way would require I turn it back off
when I close the form?

dave

Hi Dave

You can simply say:
Me.AllowEdits = True (or False)

However, this will also affect unbound controls on your form. If this
is a problem, then Allen Brown has a nice little function on his
website that locks (or unlocks) only the bound controls:
http://allenbrowne.com/ser-56.html

--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

Access 2003
So I have a data entry form that does not ally edits.
My MO in the past was to create a duplicate form for users to make
edits to that data.

I think this is probably novice approach.

I would like to code and event (Double click) to open the same form
but turning on "Allow Edits"

I need help with the syntax of that line of code.

thanks