Search results

I updated my example dB to start trying to apply your description, but I think I'm off track somewhere

Thank you that is a very helpful explanation. I had never really thought about having an all purpose y/n field like that. For the structure, are you indicating that each level would be its own table (5 data tables and some value tables), or have one data table with all of the foreign key...

JDraw, I've looked at the example files and read the information with them. I'm trying to picture how I would adopt this table structure since it does sound appropriate for me. How would I manage the relationship between Status etc?

Sorry just got back. As for an example: Project X has a Planning period, Design time, Construction, and Post-Occupancy work. Those are four of the statuses used, and each has separate events under them. I'll just do a bit to clarify. Status --- Phase ------- Activity Design --- Development...

OK I’m dying here. I’ve built and rebuilt these tables in my database over and over trying to find the best/correct way to do so. Someone somewhere must have done this before, but I’ve gotten so deep into it that I can’t see it clearly any longer. My team is doing project management on...

I just turned 40, so I guess I'm "medium toothed". My experience has been that the cold war that company IT departments wage on Access means few folks get a chance to even try it. Coupled with the lack of innovation/change/support from Microsoft, Access seems relegated to the discount bin...

That is exactly what I do as well. Also, I like having that Code Library always compiled to squeeze every last drop of performance that I can.

Paul, I've done that as well. Honestly I will probably combine mine into one with a couple of commented lines, but currently my plate overfloweth.

MZ-Tools was mentioned above, which is how I do it. I have two ErrorHandlers, one for simple code and one for Recordset/Object code. The only real difference is that the RS/Obj handler has a different exit method to remind me to SET any objects = Nothing and close any RSets. The RS Handler...

I know what you are referring to GBalcom. I put a code database into play and it has saved me some serious time, as well as ensuring that updating any shared functions is easy and consistent.