Recent content by Graybeard

Thanks everyone. You are absolutely correct. One of the major reasons I have so many tables is because I tried to avoid blank fields. For example, I made a seperate main table for Corporate Defendants so I wound't have have blank fields for all the entries for date of birth, soc security no...

thanks Mike. My preference was to keep it as once but didnt want to get it done and then find out I had a problem.

My DB is designed around 4 groups of tables all linked to an initial main table. It is a DB for a Law office. The 4 groups are the cateogories of cases the firm handles- State criminal cases, state civil cases, federal criminal cases and federal civil cases. The initial main table is general...

Thanks Doc I will use a query when I go to design my report. I hate to be thickheaded but I am a newbee and there is something I still don't understand. Rich said not to put a field in my table for the final completion date(180 + delay caused by company). I understand that I cant have a...

Thanks Neil and Rich. I will create a seperate table but I do have a another question.We are going to want to generate reports every week showing what completion dates are up that week. If I dont put the completion date field in my table how will be able to run our report?

I need to set up fields which will ultimately calculate a changing time period.Im not worried about the code at this point. Im concerned about the structure of my table. An example will illustrate. All employees are given 180 days to complete a task from a date certain.(the start is...

SJ, Im hoping you check this thread. I decided to stick with it and not start a new thread. am posting back because I took your advice and am not sure about something. I grouped my tables like you suggested on paper and decided to make the Criminal case tables first. Its a progression. The...

SJ, thanks for the help. idn't mean to confuse. I was trying to keep my post short. I do have name broken out as first and last and age as date of birth Though I did have it

As a newbee, I have asked many questions and everyone has been very helpful. I have also learned a lot by reading different threads. My problem is that I discovered this forum after I was 3/4 of the way thru creating my db and had done almost everything wrong. As a result, despite what I'm...

Thanks. sorry to be a pest

Thank you SJ and Colin. I ended up using SJ's method. Seemed simplier and worked perfectly.At the risk of being a pain in the butt, SJ I do have a question. I like to understand and not just copy code. My customerID field which is the bound field is in column 1. I used 0 as you had in your...

Im not sure if this question is being posted in the right place so please excuse me if it should be posted someplace else. I have combobox on a form based on a select query that allows the user to select the name of any customer in the data base(approximately 400 names). When they select the...

Sounds good to me, Rich. ::grins:: Thanks

I've worked with subroutines in terms of form commands and have even managed to learn some interesting tricks with the help of some of the people here. For example, I have written code that opens a form, populates a field with garbage then immediately sets the field back to null. The purpose...

I know that most here are down on macros and prefer code. I have started learning code and using code instead of code. However, I have a question. I have a popup form that allows the user to record the details of a customer phone call. I want the user to popup the form at anytime whenever...