[AccessD] Access 2007: Keep bound text box - delete label...

Darryl Collins Darryl.Collins at coles.com.au
Thu Apr 16 19:16:48 CDT 2009


hah!  alright, I have this sussed.  I was having this issue when I was basing a form on an existing table.  The default view is "Layout View" which seems to be a hybrid between design view and Form view.  I am not sure if that view existed in other version of Access, never used it.

If you swap to design view you can use the mouse as expect to select groups of controls, but in LayoutView you can move stuff around and changes stuff like design view, but with less functionality it seems.  I feel like Alice in wonderland after the red pill.  Curiouser and curiouser indeed...  What a strange idea.  It is not like you cannot see the layout in design view.

hehehehehe.  Too early for a vodka :-/

cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Friday, 17 April 2009 10:06 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007: Keep bound text box - delete label...


Hi Max,

You can so this, that is select a few items and them group them (although they use a different syntax, that is what you are doing).  But what I hate is you cannot drag the mouse over a group of control to select them all at once and then apply a change to the group.  It seems that you have to manually choose them all, one at a time.  I am hoping I have just missed something here with this, otherwise it is a right PITA when building complex forms.

bah humbug.  Must say the transition to XL2007 hasn't been been anywhere near as painful.

regards
Darryl.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Friday, 17 April 2009 2:37 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007: Keep bound text box - delete label...

Darryl,
In A2003 you can opt to have partial select of objects or full select of
objects.  Maybe there is a similar options in A2007?

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: 16 April 2009 05:44
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007: Keep bound text box - delete label...

That is the exactly terminology I would use, but in the brave new world of
the ribbon it is just called "remove", if you can manage to find it that is.
:)

I have been playing with this right now using much larger table. Boy is it
pesky!  you can 'remove' (ungroup) the fields fast enough once you know what
you are looking for, but if you want to regroup them, there is no "select
all' option (or even select some) that I can find (so far anyway).

If you have 50 fields on your source table you need to select them one at a
time it seems (that will be 100 selections, one for the label, one for the
field). hmmmmmmm... :-/

You cannot (well at least *I* cannot) use the mouse to drag over the
controls and select a few or group of controls at once anymore (?!!)  This
seems really odd.

*sigh*

regards
Darryl.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, 16 April 2009 2:30 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007: Keep bound text box - delete label...

Oh, so the autoform somehow 'grouped' the controls, and in effect, you
'ungrouped' them then? 

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Wednesday, April 15, 2009 9:22 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007: Keep bound text box - delete label...

Hi Rocky,

What I did was open the table and choose "Form" to create an 'auto-form'
based on the table.  This produce a 'stacked' type form with a label on the
left and the bound text box on the right and the fields listed vertically
(it is a very simple table with only 4 fields).

Thus I have an auto form like

Field1Lablel | Field1BoundTextBox
Field2Lablel | Field2BoundTextBox
Field3Lablel | Field3BoundTextBox
Field4Lablel | Field4BoundTextBox

If select any part of the label or text box both would selected. I tried the
usual ctrl options when selecting.  Oddly the orange border would only show
up on one or the other as expected using the ctrl key method, however if I
pressed delete then both the label and text box would delete - even if only
one was selected, or worse, all four fields would delete.

Regardless of what was selected if I changed the size of one of the field,
all four fields would replicate the change - ditto for moving.  For example
I couldn't change them around to look like:

Field1Lablel | Field1BoundTextBox    Field3Lablel | Field3BoundTextBox
Field2Lablel | Field2BoundTextBox    Field4Lablel | Field4BoundTextBox

Ugly stuff!

However, if you select all the fields and then choose 'remove' from the
"Arrange" "Control Layout" Group (under form options) it releases them all
so they work as before.

And yes - it is painfully slow and I have problems with coloured comboboxes
not being rendered correctly.  Actually, the whole darn product reeks of
cheap and nasty. bah bah!

regards
Darryl.




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Thursday, 16 April 2009 1:38 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2007: Keep bound text box - delete label...

In 2003 you select the label, hit delete and it goes away.  Just tied it in
2007 and it worked.  Am I misunderstanding what you're trying to do?

One thing I did notice- you may be right about the grade level 2007 was
designed for - it goes...real...slow...ly.  I'd say that if I was as
proficient with the 2007 IDE as I was with the 2003, it would take about 30%
longer to design a form or report in 2007 based on the application's
response time alone.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Wednesday, April 15, 2009 8:14 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Access 2007: Keep bound text box - delete label...

Hi folks,

Building a form based on a table in A2007.  Trying to delete the label and
keep the bound text box, but I cannot seem to do it.  There much be a way to
break the link between the text box and the label.

Anyone got any pointers?

cheers
Darryl.



This email and any attachments may contain privileged and confidential
information and are intended for the named addressee only. If you have
received this e-mail in error, please notify the sender and delete this
e-mail immediately. Any confidentiality, privilege or copyright is not
waived or lost because this e-mail has been sent to you in error. It is your
responsibility to check this e-mail and any attachments for viruses.  No
warranty is made that this material is free from computer virus or any other
defect or error.  Any loss/damage incurred by using this material is not the
sender's responsibility.  The sender's entire liability will be limited to
resupplying the material.


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

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

This email and any attachments may contain privileged and confidential
information and are intended for the named addressee only. If you have
received this e-mail in error, please notify the sender and delete this
e-mail immediately. Any confidentiality, privilege or copyright is not
waived or lost because this e-mail has been sent to you in error. It is your
responsibility to check this e-mail and any attachments for viruses.  No
warranty is made that this material is free from computer virus or any other
defect or error.  Any loss/damage incurred by using this material is not the
sender's responsibility.  The sender's entire liability will be limited to
resupplying the material.


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

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

This email and any attachments may contain privileged and confidential
information
and are intended for the named addressee only. If you have received this
e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this
e-mail
has been sent to you in error. It is your responsibility to check this
e-mail and
any attachments for viruses.  No warranty is made that this material is free
from
computer virus or any other defect or error.  Any loss/damage incurred by
using this
material is not the sender's responsibility.  The sender's entire liability
will be
limited to resupplying the material.


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

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

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.


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

This email and any attachments may contain privileged and confidential information
and are intended for the named addressee only. If you have received this e-mail in
error, please notify the sender and delete this e-mail immediately. Any
confidentiality, privilege or copyright is not waived or lost because this e-mail
has been sent to you in error. It is your responsibility to check this e-mail and
any attachments for viruses.  No warranty is made that this material is free from
computer virus or any other defect or error.  Any loss/damage incurred by using this
material is not the sender's responsibility.  The sender's entire liability will be
limited to resupplying the material.





More information about the AccessD mailing list