Connecting Tech Pros Worldwide Help | Site Map

Can I easily determine the data mode for an open form object?

  #1  
Old November 12th, 2005, 11:37 PM
MLH
Guest
 
Posts: n/a
Can I run a procedure and read a value to indicate data mode
like A_EDIT or A_READONLY (Access Basic in Access 2.0) ?
  #2  
Old November 12th, 2005, 11:37 PM
Allen Browne
Guest
 
Posts: n/a

re: Can I easily determine the data mode for an open form object?


When you OpenForm using A_READONLY as the DataMode, Access sets several
properties for the form, and you can read the properties. In later versions,
the properties are AllowEdits, AllowDeletions, and AllowAdditions, e.g.:
? Forms("MyForm").AllowEdits

Can't recall if they have the same name in A2.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CRCI@NorthState.net> wrote in message
news:96ho90pscps1ib9l5cpp5oka306nb2u5qn@4ax.com...[color=blue]
> Can I run a procedure and read a value to indicate data mode
> like A_EDIT or A_READONLY (Access Basic in Access 2.0) ?[/color]


  #3  
Old November 12th, 2005, 11:38 PM
MLH
Guest
 
Posts: n/a

re: Can I easily determine the data mode for an open form object?


Thanks Allen. BTW, I've been off the forum for a long time now.
What's up with the character assassination posts being made
in this forum? I find it deplorable. Can I go read about it somewhere
offline to find out what can be done to prevent it?

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx

On Sat, 8 May 2004 11:01:56 +0800, "Allen Browne"
<AllenBrowne@SeeSig.Invalid> wrote:
[color=blue]
>When you OpenForm using A_READONLY as the DataMode, Access sets several
>properties for the form, and you can read the properties. In later versions,
>the properties are AllowEdits, AllowDeletions, and AllowAdditions, e.g.:
> ? Forms("MyForm").AllowEdits
>
>Can't recall if they have the same name in A2.[/color]

  #4  
Old November 12th, 2005, 11:38 PM
Allen Browne
Guest
 
Posts: n/a

re: Can I easily determine the data mode for an open form object?


Best prevention is not to feed the troll.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CRCI@NorthState.net> wrote in message
news:m3pp90ltd2a9ae2hofqjquu2rca66uga8f@4ax.com...[color=blue]
> Thanks Allen. BTW, I've been off the forum for a long time now.
> What's up with the character assassination posts being made
> in this forum? I find it deplorable. Can I go read about it somewhere
> offline to find out what can be done to prevent it?
>
> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxx
>
> On Sat, 8 May 2004 11:01:56 +0800, "Allen Browne"
> <AllenBrowne@SeeSig.Invalid> wrote:
>[color=green]
> >When you OpenForm using A_READONLY as the DataMode, Access sets several
> >properties for the form, and you can read the properties. In later[/color][/color]
versions,[color=blue][color=green]
> >the properties are AllowEdits, AllowDeletions, and AllowAdditions, e.g.:
> > ? Forms("MyForm").AllowEdits
> >
> >Can't recall if they have the same name in A2.[/color][/color]


Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 14th, 2005 04:15 AM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 11:37 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 09:56 PM
comp.lang.c Answers to Frequently Asked Questions (FAQ List) Steve Summit answers 0 November 13th, 2005 03:15 AM