[AccessD] AXP Question

Roz,

To give them all they want you probably will have to define your reports
as custom objects with all of their properties set by you instead of by
Access.  This may mean you will not be able to take advantage of the
built-in Access report wizards.  You may even be required to go to VB to
build such report objects.  I cannot say since I have never had to give
the user so many options concerning reports.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk] 
Sent: Monday 2003 Jun 09 09:09
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] AXP Question

Detailed question #1 

I thought you couldn't build / amend reports on the fly in a live,
multi-user database in AXP? Whenever I have tried to do anything of the
sort I got a flat refusal from Access. I was never intending to allow
them to go into Design view as then they might fiddle with the data
source (erk!) - was going to build a custom properties dialogue. But
when you change a report's properties through code Access still forces
an exclusive lock. If I use querydefs as the sources I can amend the
queries - but that's the one thing I won't let them do.

??

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: 09 June 2003 14:56
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AXP Question


Roz,

I think you misunderstand John's comment.  If there is something that is
constantly changing, then you need to develop a way for the user to be
able to pick from a selection of options to get what they want.  As you
mentioned in another of your posts on this thread, sometimes they want
to change the sort order, sometimes they want to change the font.  Have
you thought of designing a form where they get to select such options
and then base the report on those selections?  It may not be easy to
give them all the options they want/need, but if this is the only way to
keep paying customers, then you will find a way to do it.

Good luck, and don't feel afraid to ask us more detailed questions as
you get into this.

Charles Wortz
-----Original Message-----
From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk] 
Sent: Monday 2003 Jun 09 08:30
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] AXP Question

That's what I'm moaning about - I can't change the reports
programmatically any more. ><

Roz

-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com] 
Sent: 09 June 2003 14:10
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AXP Question


It sounds to me like the report changes due to customer needs.  However
it seems that the way to handle this would be to analyze what is
constantly changing and do that programatically.

John W. Colby
www.colbyconsulting.com