Programatically manipulate Form Menu in Design Mode

[Edgar]

Hi Fellows,
Thanks for possible anwers to:
I need to manipulate the Form Menu Bar in Design View. When using
Docmd.DoMenuItem, the MenuBar is not to be acFormBar, but another one I don't
find a bit of.
Also I need to select a single control on the form but the only command i
see is SelectAll. Any clue about how to, also would be appreciatted.

 

[Stuart McCall]

Hi Fellows,
Thanks for possible anwers to:
I need to manipulate the Form Menu Bar in Design View. When using
Docmd.DoMenuItem, the MenuBar is not to be acFormBar, but another one I
don't
find a bit of.

Sorry, I don't understand this question. What is the purpose of the
DoMenuItem command you're looking for?

Also I need to select a single control on the form but the only command i
see is SelectAll. Any clue about how to, also would be appreciatted.

Forms!FormName!ControlName.Selected = True

 

[Edgar]

Hi Stuart.
The purpose was to manipulate the datasheet of a graph.chart to change
values on series and categories. To delete and insert rows and columns. And
show the result on a report. I already found it out how to.
But still you can help me in this: I don't see how to change the data series
colors. In a Bar chart i want to specify the color for a single Column. Do
you know how to?

Thanks for your suggestions.

 

[Stuart McCall]

Hi Stuart.
The purpose was to manipulate the datasheet of a graph.chart to change
values on series and categories. To delete and insert rows and columns.
And
show the result on a report. I already found it out how to.
But still you can help me in this: I don't see how to change the data
series
colors. In a Bar chart i want to specify the color for a single Column. Do
you know how to?

Thanks for your suggestions.
--
Edgar Rey

Hi Fellows,
Thanks for possible anwers to:
I need to manipulate the Form Menu Bar in Design View. When using
Docmd.DoMenuItem, the MenuBar is not to be acFormBar, but another one I
don't
find a bit of.

Sorry, I don't understand this question. What is the purpose of the
DoMenuItem command you're looking for?

Also I need to select a single control on the form but the only command
i
see is SelectAll. Any clue about how to, also would be appreciatted.

Forms!FormName!ControlName.Selected = True

I've not done much work with charts so I can't help you with that one,
sorry. Perhaps if you re-post with a more appropriate subject, someone will
respond.

 

[Edgar]

Stuart;
I already figured it out. See, I was used to work with OWC for enhanced
Charts, SpreadSheets and Pivot Tables to be shown and reported in my Access
applications. OWC has a pretty easy functionality to get to these objects,
their properties and methods. And a lot more features to make your graphics
interactive, but Microsoft Office is not supporting anymore OWC. It's ok for
MO 2003 but not supported on MO 2007. So I'm triyng to work with Microsoft
Chart which is the standard in MO for developing these objects. MC is not so
easy to work with but still lets you get through the most importants features
of a Chart. That's my point, and I'm drilling well to it , so far so good.

Thanks for your help. Read you around.