Reports In Visual Basic and Access

[Greg Teets]

I am new to VB and Access reports.

Is it correct to say that VB and Access have the same report engine or
method?

After I do all the dragging and dropping, is there a way to see the
specs for the report somewhere? Or the code that produces the report?

Thanks,
Greg Teets
Cincinnati Ohio USA

[MacDermott]

Re: Reports In Visual Basic and Access

Access has its own very fine report generator, which is not part of Visual
Basic 6.0.
So I would say no, they don't have the same report generator.
Visual Basic 6.0 includes its own rudimentary report generator, but if you
want to go beyond its rather limited capabilities, you'll need a 3rd party
report generator.

You can write code behind a report, but many reports don't require it.
If you're looking for code that will look something like this: (pseudocode)
Write 20 spaces, "Report Header"
Write "Column A", 5 spaces, "Column B"
Do until dataend
Write Datasource.Fiel ds("Column A"), 5 spaces,
Datasource.Fiel ds("Column A")
Loop
No, Access doesn't provide that.


"Greg Teets" <gteets99@yahoo .com> wrote in message
news:o71o019a5e aue0eihjn6n0ipt aesqkpp68@4ax.c om...[color=blue]
> I am new to VB and Access reports.
>
> Is it correct to say that VB and Access have the same report engine or
> method?
>
> After I do all the dragging and dropping, is there a way to see the
> specs for the report somewhere? Or the code that produces the report?
>
> Thanks,
> Greg Teets
> Cincinnati Ohio USA[/color]

[Greg Teets]

Re: Reports In Visual Basic and Access

On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott " <macdermott@nos pam.com>
wrote:
[color=blue]
>You can write code behind a report, but many reports don't require it.
>If you're looking for code that will look something like this: (pseudocode)
> Write 20 spaces, "Report Header"
> Write "Column A", 5 spaces, "Column B"
> Do until dataend
> Write Datasource.Fiel ds("Column A"), 5 spaces,
>Datasource.Fie lds("Column A")
> Loop
>No, Access doesn't provide that.
>[/color]
Thanks for replying.

That is what I was looking for.

It's easier for me to change the 20 spaces to 15 than to drag stuff
around to line it up where I want.

Thanks again.
Greg Teets
Cincinnati Ohio USA

[MacDermott]

Re: Reports In Visual Basic and Access

Try selecting the items you want to line up, then using Format - Align from
the menu to line them up.
Counting spaces is really only effective if you're using a fixed-space
font -
hardly a modern look.

"Greg Teets" <gteets99@yahoo .com> wrote in message
news:h8lp01d67s 7jm18crrb1r2n5f 4a99rqs8o@4ax.c om...[color=blue]
> On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott " <macdermott@nos pam.com>
> wrote:
>[color=green]
> >You can write code behind a report, but many reports don't require it.
> >If you're looking for code that will look something like this:[/color][/color]
(pseudocode)[color=blue][color=green]
> > Write 20 spaces, "Report Header"
> > Write "Column A", 5 spaces, "Column B"
> > Do until dataend
> > Write Datasource.Fiel ds("Column A"), 5 spaces,
> >Datasource.Fie lds("Column A")
> > Loop
> >No, Access doesn't provide that.
> >[/color]
> Thanks for replying.
>
> That is what I was looking for.
>
> It's easier for me to change the 20 spaces to 15 than to drag stuff
> around to line it up where I want.
>
> Thanks again.
> Greg Teets
> Cincinnati Ohio USA[/color]

[Greg Teets]

Re: Reports In Visual Basic and Access

That was not my point. Dragging around is not as precise as putting a
value in.


On Fri, 11 Feb 2005 22:53:50 GMT, "MacDermott " <macdermott@nos pam.com>
wrote:
[color=blue]
>Try selecting the items you want to line up, then using Format - Align from
>the menu to line them up.
>Counting spaces is really only effective if you're using a fixed-space
>font -
> hardly a modern look.
>
>"Greg Teets" <gteets99@yahoo .com> wrote in message
>news:h8lp01d67 s7jm18crrb1r2n5 f4a99rqs8o@4ax. com...[color=green]
>> On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott " <macdermott@nos pam.com>
>> wrote:
>>[color=darkred]
>> >You can write code behind a report, but many reports don't require it.
>> >If you're looking for code that will look something like this:[/color][/color]
>(pseudocode)[color=green][color=darkred]
>> > Write 20 spaces, "Report Header"
>> > Write "Column A", 5 spaces, "Column B"
>> > Do until dataend
>> > Write Datasource.Fiel ds("Column A"), 5 spaces,
>> >Datasource.Fie lds("Column A")
>> > Loop
>> >No, Access doesn't provide that.
>> >[/color]
>> Thanks for replying.
>>
>> That is what I was looking for.
>>
>> It's easier for me to change the 20 spaces to 15 than to drag stuff
>> around to line it up where I want.
>>
>> Thanks again.
>> Greg Teets
>> Cincinnati Ohio USA[/color]
>[/color]

Greg Teets
Cincinnati Ohio USA

[MacDermott]

Re: Reports In Visual Basic and Access

So put a value in the control's Left and Top properties, if you like doing
things that way.
You can also turn off "Snap to Grid", so that your dragging and dropping can
become more precise.


"Greg Teets" <gteets99@yahoo .com> wrote in message
news:qqiq0114ev j1b93e2ca4stpog 8824gapa5@4ax.c om...[color=blue]
> That was not my point. Dragging around is not as precise as putting a
> value in.
>
>
> On Fri, 11 Feb 2005 22:53:50 GMT, "MacDermott " <macdermott@nos pam.com>
> wrote:
>[color=green]
> >Try selecting the items you want to line up, then using Format - Align[/color][/color]
from[color=blue][color=green]
> >the menu to line them up.
> >Counting spaces is really only effective if you're using a fixed-space
> >font -
> > hardly a modern look.
> >
> >"Greg Teets" <gteets99@yahoo .com> wrote in message
> >news:h8lp01d67 s7jm18crrb1r2n5 f4a99rqs8o@4ax. com...[color=darkred]
> >> On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott " <macdermott@nos pam.com>
> >> wrote:
> >>
> >> >You can write code behind a report, but many reports don't require it.
> >> >If you're looking for code that will look something like this:[/color]
> >(pseudocode)[color=darkred]
> >> > Write 20 spaces, "Report Header"
> >> > Write "Column A", 5 spaces, "Column B"
> >> > Do until dataend
> >> > Write Datasource.Fiel ds("Column A"), 5 spaces,
> >> >Datasource.Fie lds("Column A")
> >> > Loop
> >> >No, Access doesn't provide that.
> >> >
> >> Thanks for replying.
> >>
> >> That is what I was looking for.
> >>
> >> It's easier for me to change the 20 spaces to 15 than to drag stuff
> >> around to line it up where I want.
> >>
> >> Thanks again.
> >> Greg Teets
> >> Cincinnati Ohio USA[/color]
> >[/color]
>
> Greg Teets
> Cincinnati Ohio USA[/color]

[Greg Teets]

Re: Reports In Visual Basic and Access

On Sat, 12 Feb 2005 03:28:01 GMT, "MacDermott " <macdermott@nos pam.com>
wrote:
[color=blue]
>So put a value in the control's Left and Top properties, if you like doing
>things that way.
>You can also turn off "Snap to Grid", so that your dragging and dropping can
>become more precise.
>
>[/color]

Cool.

Thanks for the ideas.

Greg

Greg Teets
Cincinnati Ohio USA