HOW to control printing in a vb DataReport

[Kobeobo]

Hi all,
I have created DataReport1 to print a simple report. The input (from an
Access table) has 1 field.
The report works in as much it prints the one field.

What i want to do is to create 3 (unbound?) controls in the report
detail section... then programatically fill the 3 controls with the
first 3 records, print the 3 controls, then repeat for the next set of 3
records and so on. This would be similar to printing 3 across labels.

Any ideas on how to do this?

many thanks
Baz

 

[Marshall Barton]

I have created DataReport1 to print a simple report. The input (from an
Access table) has 1 field.
The report works in as much it prints the one field.

What i want to do is to create 3 (unbound?) controls in the report
detail section... then programatically fill the 3 controls with the
first 3 records, print the 3 controls, then repeat for the next set of 3
records and so on. This would be similar to printing 3 across labels.

Have you tried setting your report to multiple columns (File
- Page Setup menu)?

 

[Kobeobo]

Hi Marsh... when i open the datareport in VBs design mode "page setup" is not
an option on the File menu.
Baz

 

[Marshall Barton]

Hi Marsh... when i open the datareport in VBs design mode "page setup" is not
an option on the File menu.

What???

What is "VBs design mode"?

Either you have some pretty funky stuff going on, you're not
using Acccess, you didn't really open the report in Design
View or I don't don't understand what you're talking about.

 

[Kobeobo]

Hi Marsh - no, i am not using MS Access to create the report. In fact, i am very
proficient with MS Access and would not have any problems creating MS Access
reports of any kind!. The only reference i make to MS Access is that it's the
Database engine is that its the Database Engine i am using (as opposed to say
SQLServer) - therefore an Access table used as input to my report. The program i
have written is in VB 6.0, and within VB6 i am using the DataEnvironment and
DataReport, which uses an MS Access backend database table, as the input... the
reference i make to VB's design mode is simply VB's version of "design mode" to
design and write VB code for execution. Hopefully this has cleared up the
confusion?
Baz

What???

What is "VBs design mode"?

Either you have some pretty funky stuff going on, you're not
using Acccess, you didn't really open the report in Design
View or I don't don't understand what you're talking about.

[/QUOTE]

 

[Marshall Barton]

Hi Marsh - no, i am not using MS Access to create the report. In fact, i am very
proficient with MS Access and would not have any problems creating MS Access
reports of any kind!. The only reference i make to MS Access is that it's the
Database engine is that its the Database Engine i am using (as opposed to say
SQLServer) - therefore an Access table used as input to my report. The program i
have written is in VB 6.0, and within VB6 i am using the DataEnvironment and
DataReport, which uses an MS Access backend database table, as the input... the
reference i make to VB's design mode is simply VB's version of "design mode" to
design and write VB code for execution. Hopefully this has cleared up the
confusion?

Well, yes, it cleared up my confusion, but it also tells me
that I'm not qualified to attempt an answer to your
question. You would probably have a better chance of
getting an useful answer from one of the VB newsgroups.

Just to eliminate any other confusion for others that might
be reading this thread (and to be a bit pedantic ;-), You
are not using Access in any way at all, period. What you're
using is Jet, one of the database engines that is included
with Access and a few other packages.

 

[Kobeobo]

Yes, that is correct, just the Jet engine - and of course an Access .MDB file

Well, yes, it cleared up my confusion, but it also tells me
that I'm not qualified to attempt an answer to your
question. You would probably have a better chance of
getting an useful answer from one of the VB newsgroups.

Just to eliminate any other confusion for others that might
be reading this thread (and to be a bit pedantic ;-), You
are not using Access in any way at all, period. What you're
using is Jet, one of the database engines that is included
with Access and a few other packages.

[/QUOTE]