Search results

You are right the record source is a table for each form. Date comment ... noted can change this if necessary? Where might I find the Master/Child setting? Thanks Dan

I can enter data in both tables or forms directly. The forms each enter data into two different tables respectively. Both tables have DOB, Date, and Physician in common. The one to one relationship between the tables is Date. Does this help?

Bob, Allow additions is on in both forms. Where is the updateable field found? Wehn I go through the properties I see nothing like this?:confused: Remember I am still a newbe at all of this. Dan

I have two forms and I want form 2 to be a subform of form 1. I have placed the 2nd form on form 1 as a subform and can see all the elements form 2 in design view but when I switch to view I can see form 2 header but none of the elements of form 2 are visible. Can someone help me figure this...

Great ..... thanks for your help Bob.

No problem ... however I should have mentioned I am using Access 2003. Does it make any difference???

I am new to VB and modules. Can anyone suggest a good basic reference book to begin learning how to use these tools??:o Thanks for the help!

Thanks ......... I will give this a try and see what happens?????

Okay ..... I will check into the tutorials. Thanks for pointing the right direction!

I am unfamiliar with VB code. How would I do this???

The query has the -1 condition. When the condition exists the report prints as expected. However when there is no data or 0, the report still is generated but shows no data with #Error in the calculation fields because there is no data. I am looking for a way to not have the report print when...

I have a macro that generates a report based on a query with a date range condition and a field value condition of -1. When the macro runs and both conditions are met I get what I want. However when the -1 condition fails, or is 0, I still get the report with #error which is to be expected. I...

found the answer .... thanks again!!!!

I don't believe I can due to privacy issues here. I do have another question?? I have an expression in the query that is: (done in expression builder) Total Time:[end time]-[start time] How can I format this to be in hours and minutes?

Well even a blind pig finds and ear of corn once in awhile! I removed the DOS relationship and left the relatiionship to DOB and it worked. I assume this is because the between start and end date criteria eliminated the need for that realtionship? I appreciate your help and I am sure I will be...

Ok .... this is over my head (Joins) ... DOB has to equal DOB and DOS has to equal DOS to pull over the other fields I want in the query.

I am not versed in SQL but it appears this might help. How would this be done using expression builder? To try and clarify what I am trying to do based on a date range, I want values form table 2 based on the DOB and DOS being equal in table 1 and table 2. Thanks Dan

I have two tables with two fields in common; DOB (date of birth) and DOS (Date of Service). I need a query that gets information from each table based on a date range, (start date and finnish date) when these two values equal each other. I have tried a number of things but have had no luck...

Brian, I did as you suggested and it worked great. Thanks for the help!! Dan

Thanks Ray, I did as you suggested entered the formula, set the running sum to "Over All" (choices are No, Over Group, Over All) and it only gives me a total of 1 rather than 52 which is what I should see for the range I am using for the date range. Any thought as to why???:confused: