Recent content by scroce

How did the 3 field primary key become problematic?" As I was jogging this weekend the recollection came back to me - as this was some time ago If you do this - as is suggested above: "A table of agentIDs, policyIDs, and year (make the 3 fields a primary key - so no duplicates)" One major...

much obliged. made my day I am a nobody, and nobody is perfect; therefore, I am perfect.

rockin!!! - it worked! while i have you on the topic - is there any way to disable the hold down shift trick that bypasses and goes right into the database window? I am a nobody, and nobody is perfect; therefore, I am perfect.

microsoft access 2002 (10.2627.3501) SP1 i believe that is XP behaviour not as expected. here's something odd: one thing i noticed when I open the db - for some reason there are two boxes in my taskbar for my database. If you hold your mouse over the left one, it says "MyDBName", and if you...

I have a problem where the database window keeps popping up, allowing users to see my tables, forms, modules, etc. I disabled all the shortcut keys and unchecked "display database window" in tools>startup. the database window mysteriously re-appears if a user minimizes the adp window and then...

ok - thanks for the tip! I am a nobody, and nobody is perfect; therefore, I am perfect.

well, i finally got this to work using loops and an array. the code is quite simple looking written out, and not very lengthy. I will post it if anyone cares, but it looks different b/c makes calls to other functions not described here, etc. etc. Gumm - you brought up some good points about...

what are the ramifications of increasing a paging file size? I have win2k pro running with 256k of mem. Some of my users (including myself) have lately been getting the "system low on virtual memory" error, due mostly, i think, to some background antivirus apps that global IS has rolled...

yes that is true - and currently the data model takes this into consideration and does not allow that to happen. I have associated an agent directly with a policy, and in turn the policy directly with a member. I debated several ways of doing this with myself, but finally settled on this one...

I have the first two, but not the third. I have worked to normalize the data as best I knew how over the past few years. The data store got larger, and I wanted to share it out, so I moved it recently to SQL server. When I built this DB I had originally had the third, with the 3 primary keys...

it's going to take me a bit to apply your SQL statement, so forgive me if my post back is slow you are saying to only have one table that holds all policies? The problem with that, is that each type of policy tracks a ton different information. - i.e. it's not uniform. Where would I store all...

do you really need the array" I don't know - i guess this is open to debate... i see what you are trying to do, querying through the records, and then thru them records, finding which ones have unit numbers, and concatenating them into 1 large comma separated string - a good idea, I have...

gummown i don't know that i could go that way without completely revamping my report, which i'm trying to avoid at the moment. maybe it would help if i took this in small pieces so say I have this array: WC| AL|PR|CR |EDP 109|109|78|109|46 the top row is a policy identifier - the bottom...

payback so far i've kind of done that. each page on the report is dedicated to a client. Then I have functions that return booleans that tell me what policies they have. WC, AL and PR are 3 types of policies - so right now, if the Validate funciton is true, then it finds the AgentID and...

trying to be brief and simple as possible. my insurance company provides 5 policies to its clients: a, b, c, d, & e. my company also works with several different agents. some agents are associated with more than one policy. there is a report that I'm trying to build that shows the client...