Connecting Tech Pros Worldwide Help | Site Map

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

 
LinkBack Thread Tools Search this Thread
  #1  
Old November 12th, 2005, 10:37 PM
MLH
Guest
 
Posts: n/a
Default Can I easily determine the data mode for an open form object?

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, 10:37 PM
Allen Browne
Guest
 
Posts: n/a
Default 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, 10:38 PM
MLH
Guest
 
Posts: n/a
Default 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, 10:38 PM
Allen Browne
Guest
 
Posts: n/a
Default 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]


 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,662 network members.