Search results

Attached is the Data Structure I am starting with. Property Group: - Table to Store Definition of a Property Group PropertyGroupProperty - Many-to-Many Junction between PropertyGroup and PropertyDefinition Property Definition: Define a Unique Property (Contains DataType identifier...

Thanks @MajP

Having trouble with the link Doesnt seem to be working

In my db, ive created a feature I'll call Custom Properties. This feature is intended to allow additional User Defined information to be captured about a particular entity and then the value(s) assigned to these properties to be used at decision points in processing logic. An individual...

You are reading too much into it. Right now Im the only user. The system is using Ms Access 2007 as the front end and is an Adp. Project. Support for this setup ended with either access 2010 or with 2013. So i really don't have a simple upgrade path. Having said that, the next iteration of...

@The_Doc_Man Thanks again, at this point i "just" have to build it. I already have a number of places with cascading combo's so im good there. I think the primary decision i have left is the location of the processing code when generating a new quote. Since my db is in mssql and i'm fairly...

Thanks again @The_Doc_Man you've given me plenty to ponder. I think I need to put this down for a day or two in order get out some overdue proposals using my old process. During that time these concepts and ideas will be allowed to brew. One more question. Since most of these items and...

@The_Doc_Man I had a chance to spend some time at the Thinking Rock and read through your suggestions a couple of times and well the light bulb turned on. I always have seperate tables to define the parent and child then a third table to establish the many to many relationships. I see now how...

Thank you of your thoughts. I have - and generally I find the products that I could consider from a cost perspective fall short of the functionality I desire. It seems they want to focus on one aspect or another - like producing pretty quotes with pictures but not having the smarts to generate...

@The_Doc_Man Thanks again. Im not sure if those db tools are available to me. Currently by db is an Access 2007 adp or SqlProject file connected to a Mssql 2012 Express db server. Since Access 2007 is not certified for Mssql 2012 some of the functionality gets greyed out or is just not...

I just had a rather fustrating experiece New code and controls added to a screen were not saved - upon completing some work compiling the code, closing and saving the screen. This happened twice in a row on the same screen so i was doubly careful to save after every small change. Still after...

Thanks again @The_Doc_Man You have done more than I have a right to ask. You have invested your time to help me solve my challenges with thoughtful suggestions. It now time for me print out your responses, go to my "Thinking Rock" tap my head "think think, think" and make some decisions. -...

@The_Doc_Man Thank you for taking the time to put together such a detailed response. I will definitely need to read and re-read many times to fully grasps it all. On the surface, i think im heading in the same direction. What i didn't mention was i do also have a set of tables that define...

Hoping to get some insight into the level of granularity i should implement in the Estimating/Quoting module I am building. As I posted before, I currently run a small Home Improvement company. We specialize in really just a few types of projects. Deck Construction during most of the year...

Wow - This something I need to check out. Many thanks

Uncle Gizmo, sorry if my comment came accross as disrespectful. I've read many of your posts and know you always help out other members with your valuable insight and experience. Truthfully, i was at the end of a long day, feeling stressed, and just reacted without thinking. Please forgive my...

Funny us Accountants playing software developer. Kinda similar though, logical and procedural. Having a hard time giving up any piece of my baby. Its been suggested to me in the past to buy something off the self but.... its my baby.

Thanks so much for these code bit, I'm sure they will be helpful if/when I ever get around to converting. I did convert this app to linked tables about 5 years ago, had it working, but missed the adp. Just seemed to run so much smoother and easoer to work with so switched back. Duh! The app...

Thanks for your input CJ, most of the things you mentioned I'm doing. While im currently running my Home Improvement Business, I have a background in Accouting and Accounting Systems. 5 Years Cpa - Auditor of Wall Street Companies with KPMG 10 Years Financial Systems with FlexiInternational...

This I know, but really, how does this help??