If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access Programming
Hello,
I am trying to determine what my development times are in relation to industy benchmark for Access development. Sometimes a form will take me 1 hour to design(including object coding) Or sometimes it may take a couple hours(including object coding), it is not consistent and it become frustrating for me when I attempting to establish a baseline for my personal use. Is there any guideline that is recognized as a baseline for an individual creating forms and controls, reports and controls, queries and such. I just cannot seem to get a handle of my time lines and think that if there is a target value to aim for, I might be a little more targeted. Thanks, Frustrated. |
#2
|
|||
|
|||
Access Programming
"mbox204" wrote
Is there any guideline that is recognized as a baseline for an individual creating forms and controls, reports and controls, queries and such. No. I just cannot seem to get a handle of my time lines and think that if there is a target value to aim for, I might be a little more targeted. There is so wide a range of functionality that may be needed in any of those objects that it would be impossible to have a "rule of thumb" for how long any should take. A form could be as simple as an Autoform on a simple lookup table (5 seconds or so), or it could be a form with multiple subforms dealing with several related tables and complex logic (who knows how many hours or days?). Larry Linson Microsoft Access MVP |
#3
|
|||
|
|||
Access Programming
"mbox204" wrote in message ... Hello, I am trying to determine what my development times are in relation to industy benchmark for Access development. Sometimes a form will take me 1 hour to design(including object coding) Or sometimes it may take a couple hours(including object coding), it is not consistent and it become frustrating for me when I attempting to establish a baseline for my personal use. Is there any guideline that is recognized as a baseline for an individual creating forms and controls, reports and controls, queries and such. I just cannot seem to get a handle of my time lines and think that if there is a target value to aim for, I might be a little more targeted. I doubt you'll find anything. I've done applications in a few hours and a form in many many hours, and that doesn't count the time's I started over. In general be as lazy as possible. Make sure you are using the relational model. Use queries over code whenever possible. (That saved a deal that would have killed a very profitable project.) Make sure you are doing it the "Access" way. Just read through the events, commands and functions available in Access, or any other language, once in a while. Most of us have heard "us" say "Damn, I could have used that and saved an hour." Steal ideas from here. |
#4
|
|||
|
|||
Access Programming
As mentioned, the difference between one form, and the next can be really
amazing. If you take a look at the following article, there is a screen shot part way down. It looks like a VERY AVERY simple screen. http://www.attcanada.net/%7ekallal.m.../WhyClass.html Here is stats for that simple screen: 700 lines of VB code (this does include blank lines). It uses a class object I created, and that module has 730 lines of code So, basically this simple screen that does not even edit data has 1500 lines of code to make it work? I can assure you, that this screen took a good 3 days of work, and that does NOT include the writing of the class object that I used to make this routine function.. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.attcanada.net/~kallal.msn |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error while running Access MDE | Hemil | General Discussion | 2 | June 21st, 2004 01:03 PM |
Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |
Recommendations needed for installation order of Access XP, Access XP runtime, ... | Mark Plantenberg | Setup, Installing & Configuration | 0 | June 11th, 2004 11:22 PM |
Data Access Page Problem | Doug Munich | General Discussion | 0 | June 5th, 2004 12:03 AM |
Does not switch from VBE to Access Main Window | Tony_VBACoder | General Discussion | 1 | June 4th, 2004 04:20 PM |