1

Topic: Output of several lines in the report

Hello!
I apologize, at me  a question.
Prompt as from the list to deduce the marked lines? That is the table with a heap of lines, I mark them ticks and to me these lines are deduced stupidly. I need it for this purpose that from a considerable quantity to select necessary and to copy in a Word. In advance thanks!

2

Re: Output of several lines in the report

Source of lines of the report - request:
SELECT * FROM [Table] WHERE [Flag] = True

3

Re: Output of several lines in the report

Anatoly (Kiev);
I will explain even more precisely. Whether it is possible codeless to manage? A mouse and properties of elements, tables, reports etc.??? I will remind - I do not rummage!

4

Re: Output of several lines in the report

diman_ob_304 wrote:

Prompt as from the list to deduce the marked lines? That is the table with a heap of lines, I mark them ticks and to me these lines are deduced stupidly. I need it for this purpose that from a considerable quantity to select necessary and to copy in a Word.

As are deduced
--The table
--Single sheet (form) for the line
At all when that transits the period button usages  and it is necessary to begin programming masterings
You reached it is it is time to LEARN VBA
At first learn
--To understand examples from a forum
--To finish them under the needs
--Then awake to write the

5

Re: Output of several lines in the report

THE PENSIONER;
Prompt similar examples under my tasks. To me  at least it to begin with. That process and operation went, and will read time then literature mountains. Thanks.

6

Re: Output of several lines in the report

diman_ob_304 wrote:

similar examples under my tasks.

And what your situation
--The table
--Sheet

7

Re: Output of several lines in the report

diman_ob_304;
The contract is normally form with bookmarks
Unprofitable is a head part with + a part
The specification is a tabular part with a heading part
...
...
... And from tens variants (at least)
What at you

8

Re: Output of several lines in the report

Accordingly and candidate solutions more than 10
Depends on real needs

9

Re: Output of several lines in the report

THE PENSIONER;
I in terminology  am not strong. Therefore I think that the table.
In an ideal, at the beginning, simply table, with possibility to import new lines. Lines contain simply text  (number and a certificate title). From this table you select a tick the necessary lines (for example, from 100 lines it is necessary to select only 10). And they are grouped in the separate table. To select with a mouse these 10 lines and to copy in a Word.

10

Re: Output of several lines in the report

diman_ob_304 wrote:

(for example, from 100 lines it is necessary to select only 10

And what for to you then the WORD
Unpack 10 lines from 100 the report  can also
I do not understand your situation

11

Re: Output of several lines in the report

THE PENSIONER;
At me is  the document, we name its passport. In this passport in a certain place it is necessary to interpose from 10 to 50 names of certificates. In total these names of the order 500. Here I need to select these certificates, to receive, roughly telling the table of the selected certificates and to interpose (interpose I can also normal ) in  the passport.

12

Re: Output of several lines in the report

It is one of the first tasks. Further I will already understand, it is possible and with  too

13

Re: Output of several lines in the report

diman_ob_304, well so apply the filter on value of a flag - copy - cancel the filter.

14

Re: Output of several lines in the report

diman_ob_304;
Create request

select [the name ] from tab where flag=true

--Open request
--10 lines will be highlighted
--Push the button the EXTERIOR DATA and the OUTPUT In the WORD
--In a Word select the necessary cells, copy
--Also interpose into the document

15

Re: Output of several lines in the report

The PENSIONER, Anatoly (Kiev);
Thanks for the help!