By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,071 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

how to set focus on a report control?

P: n/a
Hello

Which command do I've to use to set the focus on a control placed on a
report in Design-View. Ctrl.SetFocus and Cmd.GoToControl don't work for a
report.
The aim is to copy the control from the report into memory using the
DoCmd.RunCommand command.
(Access 2000)

Thank you
Sincerely
Lore
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I don't believe there is a concept of focus on a report, since it is not
interactive.

Do you really need to copy the control itself?
Or is it the value displayed in the control that you want?

That value is accessible in the Format (or Print) event procedure of the
report section which contains the control.

HTH
- Turtle

"Lore Leuneog" <Lo**********@gmx.net> wrote in message
news:bs*************@news.t-online.com...
Hello

Which command do I've to use to set the focus on a control placed on a
report in Design-View. Ctrl.SetFocus and Cmd.GoToControl don't work for a
report.
The aim is to copy the control from the report into memory using the
DoCmd.RunCommand command.
(Access 2000)

Thank you
Sincerely
Lore

Nov 12 '05 #2

P: n/a
Well, what I want to do is to copy diagramms from different reports and
export them all together into one word or powerpoint file. (The access
Diagramms are databound and the data should be exported as a static copy
with the MSGraph object.)

I just succeeded to do it manually: Copy the diagramms from the report onto
a Form. Set the activated property of the diagramm to true and copy the
diagramm from the started form into word or powerpoint. But there are lots
of diagramms and that's why I would prefer to do it by VBA.

Do you' ve got a better idea???

Thank you
Sincerely
Lore
"MacDermott" <ma********@nospam.com> schrieb im Newsbeitrag
news:R_*****************@newsread3.news.atl.earthl ink.net...
I don't believe there is a concept of focus on a report, since it is not
interactive.

Do you really need to copy the control itself?
Or is it the value displayed in the control that you want?

That value is accessible in the Format (or Print) event procedure of the
report section which contains the control.

HTH
- Turtle

"Lore Leuneog" <Lo**********@gmx.net> wrote in message
news:bs*************@news.t-online.com...
Hello

Which command do I've to use to set the focus on a control placed on a
report in Design-View. Ctrl.SetFocus and Cmd.GoToControl don't work for a report.
The aim is to copy the control from the report into memory using the
DoCmd.RunCommand command.
(Access 2000)

Thank you
Sincerely
Lore


Nov 12 '05 #3

P: n/a
There are a number of approaches you could take to this task.

One of the first questions you should ask is whether this is something you
will be doing only once (for several different charts, you indicate)? Or is
it something you will be doing repeatedly - say once a month?

You might want to look at "pulling" the data into Word instead of "pushing"
it out from Access.
You can read the Help on linking to external data.
And in Word you can record a macro to help you do this in a repetitive
fashion.

HTH
- Turtle
"Lore Leuneog" <Lo**********@gmx.net> wrote in message
news:bs*************@news.t-online.com...
Well, what I want to do is to copy diagramms from different reports and
export them all together into one word or powerpoint file. (The access
Diagramms are databound and the data should be exported as a static copy
with the MSGraph object.)

I just succeeded to do it manually: Copy the diagramms from the report onto a Form. Set the activated property of the diagramm to true and copy the
diagramm from the started form into word or powerpoint. But there are lots
of diagramms and that's why I would prefer to do it by VBA.

Do you' ve got a better idea???

Thank you
Sincerely
Lore
"MacDermott" <ma********@nospam.com> schrieb im Newsbeitrag
news:R_*****************@newsread3.news.atl.earthl ink.net...
I don't believe there is a concept of focus on a report, since it is not
interactive.

Do you really need to copy the control itself?
Or is it the value displayed in the control that you want?

That value is accessible in the Format (or Print) event procedure of the
report section which contains the control.

HTH
- Turtle

"Lore Leuneog" <Lo**********@gmx.net> wrote in message
news:bs*************@news.t-online.com...
Hello

Which command do I've to use to set the focus on a control placed on a
report in Design-View. Ctrl.SetFocus and Cmd.GoToControl don't work
for
a report.
The aim is to copy the control from the report into memory using the
DoCmd.RunCommand command.
(Access 2000)

Thank you
Sincerely
Lore



Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.