Search results

Thanks, FoFa that worked but I realized I have a similar issue with the IF side of the statement as well: If DateAdd("yyyy", 18, Me.Txt14) > Me.txtBegin Then Me.StatofLimits = DateAdd("yyyy", 20, Me.Txt14) The number "20" is also now a variable. This number is determined by adding 18 to the...

I have the following date calculation : ----------------- Private Sub StatofLimits_GotFocus() '--Determines Statute of Limitations accounting for minors. If DateAdd("yyyy", 18, Me.Txt14) > Me.txtBegin Then Me.StatofLimits = DateAdd("yyyy", 20, Me.Txt14) Else...

Pat, I do appreciate all your help. This has been quite helpful. It might not seem that way but I am actually making most of the structural changes you have suggested. I am moving all the dates into one table in each of the 4 sub groups. Hopefully, I won't need Union queries. Again, thanks...

Pat, I reread your Post. I now understand it better. You are suggesting I replace the 4 main tables with one. I think I said this in my previous post but so its clear thats how I started out this db and had to abandon the the idea of one main case table linked to all the individual case types...

Pat, I think I already have done most of that if I understand you correctly. I currently have 4 Main case tables- one for all state civil cases, one for all state criminal cases, one for all Federal Criminal Cases and one for all Federal Civil Cases. Each of the 25(there are actually 38)...

Shane, I don't agree with you at all. There is no relationship between each of the 4 subgroups. Theres no relationship between a state criminal case and a federal civil case for example. We could just as easily have created 4 seperate dbs-one for each of the 4 groups but then we would have to...

I have 2 questions. First, Why would I want to put all due dates, criminal and civil, federal and civil, in one table? As currently structured, each of these subgroups-State civil. state criminal. Federal Criminal and Federal Civil are completly independent of each other and there is no...

Pat, Mr. George, In rereading both your posts It just hit me that I think we have a misunderstanding. I think I am already doing what you are suggesting. Its just a difference in labeling. Mt George writes: "Auto Accident is one "Civil Case Type". Slip and Fall is one "Civil Case Type". Med...

thanks. I didn't know Mr George but I am very familiar with Pat and I have all the respect in the world for her advice.

Pat, George, Sorry , our posts crossed each other. Here is why I disagree. You are relating civil cases to lawsuits. That is a misunderstanding. Most cases do not end up in litigation. The information recorded for different type of civil cases is completly different from each other. There...

Shane, Thats what I'm thinking but I'm not sure how to do it. I really didn't set forth the scope of the problem and I think that is where George got confused. The db is divided into 4 sub-groups: State-Court Civil Cases. State-Court Criminal Cases, Federal Court Criminal Cases and Federal...

Actually, George My tables are completly normalized. The state civil cases do not represent 25 different states. They represent different type of civil cases in state court-ie auto accidents, divorces, Medical malpractice, slip and fall, Insurance cases, etc. The db is designed that way to...

I have a db for my LawOffice. Is there a reason/advantage to create and send form letters as Access Reports instead of just using Word directly? I can't see any but maybe I am missing something?

I realize this sounds like it should be posted in the Report section but I am posting it here because I suspect the answer will involve coding or modifying my forms. I have multiple tables with bound data input forms for my law office db. One of the items recorded is due dates for different...

You're right. It wasn't intentional. I got a "Web Site not responding" message and when I hit retry it apparently posted it a second time. My apologies.

I have a multiple row of tab controls on a form. I need to add another tabcontrol in the middle of the row. Is there a way to do this? Every time I insert a new tab Access inserts it after the last tab. I have searched for a way to reorder the tabs but haven't had any luck.

I have a multiple row of tab controls on a form. I need to add another tabcontrol in the middle of the row. Is there a way to do this? Every time I insert a new tab Access inserts it after the last tab. I have searched for a way to reorder the tabs but haven't had any luck.

The reason for 2 subforms based on the same table is mainly for Real Estate Purposes. The table actually has more than 8 fields. The db is for my lawoffice. The table is a details table for autoaccidents-ie- Where Accident happened. Weather conditions. Speed limit, Traffic signals, Police...

This is so basic I am almost embarrassed to ask but here goes. I have two subforms bound to a 8 field table. Subform 1 fills in 5 of the 8 fields and subform 2 fills in the other 3. I fill out my main form bound to Table1 then open subform1 and fill in the 5 fields. This subform is linked to...

Thankd, RG As usual you were right on the money. Much appreciated.