Search results

Well, I came to this point myself, but problem starts after... As you said the subform would be continuous, but I need to rearrange 168 textboxes in 12x14 grid so that it looks like the printout. And more and more I am afraid it is not possible?!

Thank you for your responses, here I will give more details as requested: 1. I want the user to add/edit test results, that is the whole purpose. 2. Test names and amount of tests per number (which is patient) are fixed and they do not change. 3. There are 168 tests per number (that is the...

Hello Usually I "Google" the problems, but I could not find key words for my question. I was told that if I have data in this shape: Number ¦ Test1 ¦ Test2 ¦ Test3 ------------------------------------ 000001 ¦ Pos ¦ Neg ¦ Pos 000002 ¦ Pos ¦ Pos ¦ Neg It is always better to make table in...

Thanks a lot, very helpful Problem solved

Hello Some months ago I wrote an expression and included it into the Default Value of a form text box. It was working perfectly until one day and since then I am breaking my head, but cannot find the reason. Here is the info: It is a simple form/subform for the simple related (two tables)...

@ apr pillai Actually I was trying your sql code and realized that if instead of UNION ALL i use just UNION in the first query, it will automatically eliminate duplicates and no need for GROUP BY anymore. Thanks for good idea

Thanks a lot. One query less is really nice.

Dear experts Say I have two following tables: Table1: ID | Item1 1 | Table 2 | Chair 3 | Shelf Table2: ID | Item2 2 | Book 3 | Paper 4...

Thanks a lot I will try that

Hello guys I am very new to Access, but not new to databases (I have been using other epidemiological software). I would like to know if it is possible to do the following: the database is about patients, who have there unique numbers (identifier). I want in the form when doctor enters the...