A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

07 Design management confusion



 
 
Thread Tools Display Modes
  #1  
Old November 6th, 2007, 01:02 AM posted to microsoft.public.access.reports
NetworkTrade
external usenet poster
 
Posts: 825
Default 07 Design management confusion

Hi....if you are experienced with Access07 ; can you briefly explain the
phenomena when one used the Report Design Wizard all the fields created are
"bound" together...and when you go to alter one it alters the entire
group.....so to speak...

and the data field is "bound" to its label....I can't seem to tweak the
label names

have floundered around to turn off this field group binding but not sure if
it is possible.... tia

--
NTC
  #2  
Old November 6th, 2007, 10:23 AM posted to microsoft.public.access.reports
RoyVidar
external usenet poster
 
Posts: 417
Default 07 Design management confusion

NetworkTrade wrote:
Hi....if you are experienced with Access07 ; can you briefly explain the
phenomena when one used the Report Design Wizard all the fields created are
"bound" together...and when you go to alter one it alters the entire
group.....so to speak...

and the data field is "bound" to its label....I can't seem to tweak the
label names

have floundered around to turn off this field group binding but not sure if
it is possible.... tia


I think it is supposed to be one of the "fantastic enhancements" of the
2007 version.

When in design view, select the controls, find the "Arrange" Tab, and
hit the "Remove" button in the "Control Layout" Group.

You should be able to "tweak" the lables, at least the text, even when
it is "grouped" as above. If you wish to manipulate them individually,
after removing the layout thingie, you can either drag'n'drop from the
upper left of the label control, or deattach it (cut/paste).

--
Roy-Vidar
  #3  
Old November 6th, 2007, 08:28 PM posted to microsoft.public.access.reports
NetworkTrade
external usenet poster
 
Posts: 825
Default 07 Design management confusion

much thanks

did not like the 07 look & feel at all at the beginning - very
frustrating..... but am slowly getting to know it...much is not better/worse
- just different... but this Report Design stuff is definitely new.....thanks
for the advice & assist.
--
NTC


"RoyVidar" wrote:

NetworkTrade wrote:
Hi....if you are experienced with Access07 ; can you briefly explain the
phenomena when one used the Report Design Wizard all the fields created are
"bound" together...and when you go to alter one it alters the entire
group.....so to speak...

and the data field is "bound" to its label....I can't seem to tweak the
label names

have floundered around to turn off this field group binding but not sure if
it is possible.... tia


I think it is supposed to be one of the "fantastic enhancements" of the
2007 version.

When in design view, select the controls, find the "Arrange" Tab, and
hit the "Remove" button in the "Control Layout" Group.

You should be able to "tweak" the lables, at least the text, even when
it is "grouped" as above. If you wish to manipulate them individually,
after removing the layout thingie, you can either drag'n'drop from the
upper left of the label control, or deattach it (cut/paste).

--
Roy-Vidar

  #4  
Old November 9th, 2007, 01:30 AM posted to microsoft.public.access.reports
NetworkTrade
external usenet poster
 
Posts: 825
Default 07 Design management confusion

finally got back to this;

tried to follow your instructions - but in design view, select the controls,
find the "Arrange" Tab, so far so good

and hit the "Remove" button in the "Control Layout" Group.

can't find a 'Remove' button and the Control Layout group all seems
inactive....
--
NTC


"RoyVidar" wrote:

NetworkTrade wrote:
Hi....if you are experienced with Access07 ; can you briefly explain the
phenomena when one used the Report Design Wizard all the fields created are
"bound" together...and when you go to alter one it alters the entire
group.....so to speak...

and the data field is "bound" to its label....I can't seem to tweak the
label names

have floundered around to turn off this field group binding but not sure if
it is possible.... tia


I think it is supposed to be one of the "fantastic enhancements" of the
2007 version.

When in design view, select the controls, find the "Arrange" Tab, and
hit the "Remove" button in the "Control Layout" Group.

You should be able to "tweak" the lables, at least the text, even when
it is "grouped" as above. If you wish to manipulate them individually,
after removing the layout thingie, you can either drag'n'drop from the
upper left of the label control, or deattach it (cut/paste).

--
Roy-Vidar

  #5  
Old November 9th, 2007, 06:10 PM posted to microsoft.public.access.reports
RoyVidar
external usenet poster
 
Posts: 417
Default 07 Design management confusion

NetworkTrade wrote:
finally got back to this;

tried to follow your instructions - but in design view, select the controls,
find the "Arrange" Tab, so far so good

and hit the "Remove" button in the "Control Layout" Group.

can't find a 'Remove' button and the Control Layout group all seems
inactive....


Strange.

On my setup, it shows the Remove button both in layout view and design
view. Only time it is disabled, is when no controls are selected, or the
control layout is alredy removed.

I e - it looks exactly like how it does in the topic "New control
layouts to help create polished forms and reports" here

http://office.microsoft.com/en-us/he...241851033.aspx

But then, I haven't familiarized myself much with this new "feature",
yet. Hopefully someone else can give guidance...

--
Roy-Vidar
  #6  
Old November 10th, 2007, 08:13 PM posted to microsoft.public.access.reports
NetworkTrade
external usenet poster
 
Posts: 825
Default 07 Design management confusion

My mistake; yes you are right - when a control is highlighted then the
Remove button is activated; but when I press that it literally removes
that control.

My original question is about breaking this group binding that is
established via Report Wizard. There is the big group off all the fields
that is bound together with a yellow dotted line....and then each individual
contro/label is bound together with a yellow dotted line.

This yellow dotted line is what I want to get rid of. Not the fields.

Let's say I really don't need a label (but do need the field) because the
label is obvious to the reader and I need more space for some of the other
labels....I can't remove the label without removing the field too that is
connected to it with the yellow dotted lines....

....that's just one instance of where it would be helpful to be able to turn
off this yellow dotted line feature; and can't seem to find anyway to turn
it off if you have created the report using report wizard....
--
NTC


"RoyVidar" wrote:

NetworkTrade wrote:
finally got back to this;

tried to follow your instructions - but in design view, select the controls,
find the "Arrange" Tab, so far so good

and hit the "Remove" button in the "Control Layout" Group.

can't find a 'Remove' button and the Control Layout group all seems
inactive....


Strange.

On my setup, it shows the Remove button both in layout view and design
view. Only time it is disabled, is when no controls are selected, or the
control layout is alredy removed.

I e - it looks exactly like how it does in the topic "New control
layouts to help create polished forms and reports" here

http://office.microsoft.com/en-us/he...241851033.aspx

But then, I haven't familiarized myself much with this new "feature",
yet. Hopefully someone else can give guidance...

--
Roy-Vidar

  #7  
Old November 11th, 2007, 02:37 PM posted to microsoft.public.access.reports
RoyVidar
external usenet poster
 
Posts: 417
Default 07 Design management confusion

NetworkTrade wrote:

Comments inline

My mistake; yes you are right - when a control is highlighted then the
Remove button is activated; but when I press that it literally removes
that control.


Strange, when I select one control and hit remove, it removes the
control from the layout, but not from the report. To remove it from the
report, I'll have to select it and hit delete afterwards.

But removing one single control from the layout, shows how this
"enhancement" works. The rest of the controls in the layout are moved to
the left, "over" the controls you've just removed from the layout.

You can then select them (maybe through the dropdown in the property
sheet?), move them, delete them...

My original question is about breaking this group binding that is
established via Report Wizard. There is the big group off all the fields
that is bound together with a yellow dotted line....and then each individual
contro/label is bound together with a yellow dotted line.

This yellow dotted line is what I want to get rid of. Not the fields.


You don't remove controls through this method, you remove them from the
control layout. Select all the controls in this control layout (if you
select one control belonging to such control layout, you'll get a little
"box" to the left of the leftmost control in this control layout - looks
like the "Select Table" box found when working with tables in Word, use
that to select all controls), then go to the arrange tab, and hit
remove. Now you can manipulate each label and control as you wish.

Let's say I really don't need a label (but do need the field) because the
label is obvious to the reader and I need more space for some of the other
labels....I can't remove the label without removing the field too that is
connected to it with the yellow dotted lines....

....that's just one instance of where it would be helpful to be able to turn
off this yellow dotted line feature; and can't seem to find anyway to turn
it off if you have created the report using report wizard....


I think that is how the Remove button is supposed to work.

--
Roy-Vidar
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.