Reports In Visual Basic and Access

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

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.Fields("Column A"), 5 spaces,
Datasource.Fields("Column A")
Loop
No, Access doesn't provide that.


"Greg Teets" <gteets99@yahoo.com> wrote in message
news:o71o019a5eaue0eihjn6n0iptaesqkpp68@4ax.com...[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]

re: Reports In Visual Basic and Access

On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott" <macdermott@nospam.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.Fields("Column A"), 5 spaces,
>Datasource.Fields("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

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:h8lp01d67s7jm18crrb1r2n5f4a99rqs8o@4ax.com...[color=blue]
> On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott" <macdermott@nospam.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.Fields("Column A"), 5 spaces,
> >Datasource.Fields("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]

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@nospam.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:h8lp01d67s7jm18crrb1r2n5f4a99rqs8o@4ax.com.. .[color=green]
>> On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott" <macdermott@nospam.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.Fields("Column A"), 5 spaces,
>> >Datasource.Fields("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

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:qqiq0114evj1b93e2ca4stpog8824gapa5@4ax.com...[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@nospam.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:h8lp01d67s7jm18crrb1r2n5f4a99rqs8o@4ax.com.. .[color=darkred]
> >> On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott" <macdermott@nospam.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.Fields("Column A"), 5 spaces,
> >> >Datasource.Fields("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]

re: Reports In Visual Basic and Access

On Sat, 12 Feb 2005 03:28:01 GMT, "MacDermott" <macdermott@nospam.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