User defined reports

  • Thread starter Thread starter Marc Lacroix
  • Start date Start date
M

Marc Lacroix

Hi,

I need some help. How can I create a system where users
can define their own custom reports by the criteria they
select from a form.

It worked for me in Access 97 but not in XP. In XP, in
order to modify (design) a report you have to be in
exclusive mode. But I would like many users to be using
the database simultaneously and allow other users to
define their choice of reports.

MArc.
 
Hi,
I used to do the same you mentioned. But my report is in fix mode. It is
meant that i make one report base on the fields i need, and the report will
show only the data that matche the criteria i select on one form.

I have done it as follow:
for example my Report1 bound to Query1

after i select something in the form, i modify WHERE clause of Query1 then
open that report.

Chea Vichet
NiDA, Cambodia
 
Split the database into a front-end, which you give to each user, and a
back-end containing the tables and shared data. Then each user can have
exclusive use of their own copy of the front-end.

It's far better to split, in any case, because having multiple users logged
in to the same copy of a front-end or a monolithic database significantly
increases the chance of corruption.

Please clarify or follow up here in the newsgroup, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP
 
Back
Top