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.