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

Reports In Visual Basic and Access

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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" <gt******@yahoo.com> wrote in message
news:o7********************************@4ax.com...
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

Nov 13 '05 #2

P: n/a
On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott" <ma********@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: (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.

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
Nov 13 '05 #3

P: n/a
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" <gt******@yahoo.com> wrote in message
news:h8********************************@4ax.com...
On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott" <ma********@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: (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.

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

Nov 13 '05 #4

P: n/a
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" <ma********@nospam.com>
wrote:
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" <gt******@yahoo.com> wrote in message
news:h8********************************@4ax.com.. .
On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott" <ma********@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:(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.
>

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


Greg Teets
Cincinnati Ohio USA
Nov 13 '05 #5

P: n/a
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" <gt******@yahoo.com> wrote in message
news:qq********************************@4ax.com...
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" <ma********@nospam.com>
wrote:
Try selecting the items you want to line up, then using Format - Align fromthe 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" <gt******@yahoo.com> wrote in message
news:h8********************************@4ax.com.. .
On Fri, 11 Feb 2005 03:10:28 GMT, "MacDermott" <ma********@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:

(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.
>
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


Greg Teets
Cincinnati Ohio USA

Nov 13 '05 #6

P: n/a
On Sat, 12 Feb 2005 03:28:01 GMT, "MacDermott" <ma********@nospam.com>
wrote:
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.


Cool.

Thanks for the ideas.

Greg

Greg Teets
Cincinnati Ohio USA
Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.