[AccessD] Forms

Thats the idea Jim. Its for a demo I am giving on SharePoint.Get the feeling this is over complicated?
 
Martin
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Jim DeMarco
Sent: Fri 07/04/2006 20:27
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Forms



How about another suggestion from left field?  One question first: As
each form opens you need to determine whether or not the data in that
form comes from Sharepoint? Then you'll show/hide the text box? (OK 2
questions)


Jim D.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Friday, April 07, 2006 3:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Forms

More or less. I have a text box on every form in the database. If a
condition is true then I want to see the text box. So I figured I need
to set a global and then test it on the on open of each form. If true
then box is visible if not well leave it alone. The text box shows if
the records come from SharePoint. Simply says SharePoint Data.

Martin

Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast

tel: 02890 974477


________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Jim DeMarco
Sent: Fri 07/04/2006 19:54
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Forms



Martin,

These are text boxes on multiple forms that you want to show/hide at one
time based on criteria?  I could conceive of using a collection (or
maybe custom collection class) to hold all refences to the text boxes.
Store it in a global variable and loop through it whenever the condition
is true.

Code might look like:

g_ocoll.Add txtMyTextBox
 If condition = True then
   for i = 1 to g_oColl.Count
      g_oColl.Item(i).Visible = True
   Next i
 end if

Does that make any sense?

Jim DeMarco

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Friday, April 07, 2006 2:29 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Forms

I havea text box set to visable no on many forms. I want to set them all
to visible if a condition is true for the application Cant seem to work
out how to do this from a single point.

Martin

Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast

tel: 02890 974477




************************************************************************
***********
"This electronic message is intended to be for the use only of the named
recipient, and may contain information from Hudson Health Plan (HHP)
that is confidential or privileged.  If you are not the intended
recipient, you are hereby notified that any disclosure, copying,
distribution or use of the contents of this message is strictly
prohibited.  If you have received this message in error or are not the
named recipient, please notify us immediately, either by contacting the
sender at the electronic mail address noted above or calling HHP at
(914) 631-1611. If you are not the intended recipient, please do not
forward this email to anyone, and delete and destroy all copies of this
message.  Thank You".
************************************************************************
***********

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




***********************************************************************************
"This electronic message is intended to be for the use only of the named recipient, and may contain information from Hudson Health Plan (HHP) that is confidential or privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited.  If you have received this message in error or are not the named recipient, please notify us immediately, either by contacting the sender at the electronic mail address noted above or calling HHP at (914) 631-1611. If you are not the intended recipient, please do not forward this email to anyone, and delete and destroy all copies of this message.  Thank You".
***********************************************************************************

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com