Thanks for your thoughtful notes. It sounds like a good path to take on the project. FYI, I've done work for the client, they like it, that's the reason they offered more projects, this one is one of them, the client is easy to work with, however, as you noted it and I agree it's advisable to get as much about requirements from the client as possible, meantimes figuring out how much as I could from the existing FORM-based app without spending too much time on it. FYI, there's another reason I'd like to work on this project.
Best regards,
Don
>A few thoughts...
>Access is "query-based" so you want to look closely at the queries.
>Look at the tables and see how the data design can be improved, but be
>careful.
>Look at the forms for things like input masks and validation and add these
>to your written specs, these are part of you BRs, as are any enforcements in
>the tables.
>The catch-22 of these kind of jobs is that most people dont; want to be
>bothered with figuring out and telling you what they need.
>And you can't afford to put too much work into it, but you may have to.
>Look in the code for Form Modules, and look in Modules for code. The
>application may have neither of these. Also look for Macros.
>Look at the reports for logic as well. You talk of functions and you will
>need to understand these as well, whether user-defined or built-in.
>I would do a thorough written audit and specs.
>Then check out your understanding with the customer.
>You may need to say something like - I just wanted to clarify a few
>points...BUT do your homework first and try to understand as much as
>possible ahead of time.
>Make sure you are talking to the person who actually uses the application.
>If the secretary/admin person is the one who usually used the app then you
>want to talk to them and not their boss or business owner. They may also be
>giving of their time.
>If the client will not provide you with details about requirements then do
>not take it on. Never take on a project where they won't provide what you
>need.
>The best resource for Access coding on the web is www.mvps.org/access
><http://www.mvps.org/access> .
>good luck,
>Patrick
>
>
>
>
>
>-----Original Message-----
>From: Chunshen Li
>
>Patrick,
>
>Client does not have any doc on the BRs etc for the FORM app, I thought if
>there's some way to find out BRs etc. from the existing Access FORM, it
>would help for the new app's functions. Are you suggesting to "sqeeze" the
>client for the BRs etc. for the web app?
>
>Thanks.
>
>Don
>
> _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]