[AccessD] AXP Question

John,

That may be exactly what Roz needs.  I knew one of the great minds on
this list would be able to solve Roz's problem.  Glad I could do my
small part to get that great mind thinking about this. <grin>

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: John Colby [mailto:jcolby at colbyconsulting.com] 
Sent: Monday 2003 Jun 09 09:13
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AXP Question

I think Charles is saying that you need to build a report building
wizard. The WIZARD will take the user's choices, then place the report
into design view (the user doesn't do this, the wizard does), make the
changes, run the report, then NOT save the report when the user closes
the report.  Something of that nature anyway.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Roz Clarke
Sent: Monday, June 09, 2003 10:09 AM
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