Select fielda for report

[Dr. Mohamed Selima]

Dear All,
I have a MailingList Database which contains many fields Like name Address,
zipcode, city, State, E-mail, Phone number, ...etc
What I need is making labels and personal cards from this database. but the
fields needed each time differ, is there is a way to make a report eith
certain number of fields that I can change them any time without going to
the design view

 

[Jeff Boyce]

It sounds a little like you are asking for a way to design a
report/label/... without using the design view. While it might be possible,
wouldn't that just be replicating the functionality of the design view?

What is it about the design view that you wish to bypass?

More information, please...

Jeff Boyce
<Access MVP>

 

[Jeff Boyce]

One approach I've used to do something similar was to use a form to select
criteria, then dynamically build an SQL statement using those criteria to
query the database. However, the report definition was "fixed", and only
displayed the results of the SQL statement/query.

Perhaps one of the other newsgroup readers can offer an approach to doing
what you're describing...

Good luck

Jeff Boyce
<Access MVP>

 

[Dr. Mohamed Selima]

I think this would b fine if u tell me how to do it
Thanks

 

[Jeff Boyce]

I am somewhat confused. I was under the impression that your original
request was to modify the fields to be displayed in a report, without using
the report designer.

It now sounds like you'd like to use a standard report design, but be able
to use differing criteria to get differing recordsets printed in a single
report design.

By the way, I am happy to provide a general approach to how this was done,
but you will find there is a considerable amount of work involved in
creating a set of functions that are customized to meet your needs. Are you
still certain that this is a project you wish to undertake?

The general concept:

create a form with controls for entering and/or selecting criteria
create code behind the form that generates a SQL statement reflecting the choices made/entered
create a standard report
use the DoCmd.OpenReport function, with your SQL statement as the

"WHERE" clause

Good luck!

Jeff Boyce
<Access MVP>