Search results

Okay - here's my predicament! I have 4 tables, each dedicated to a different level of personel. These need to be discreet! The other functions that I use them for wont work if they are all in one table. I need to generate either one of the following: 1) Either a list of all of their names...

Hi, I've a problem whereby I have a form with various embedded subforms. When I design my master form, all of the subforms look justified and normal as they should. However - when I open the forms in normal view (ie using the application), they appear as tables. This is probably something really...

Query Okay - I'm doing what you've suggested. Just a couple of querues - do you suggest when doing each individual query, doing it for just the table data, or linking it to the original query too. Also - with the UNISON SQL statement, each criteria is very slightly different and holds different...

Many Thanks Thank you! This has been of much help! As each criteria is different, this is what I've decided to do: 1) Each criteria of the consultation has now it's own Table and Sub Form, It's ID=Consultation ID 2) A Query is conducted on each where Consultation ID=Condition ID AND Active =...

Thanks for that! Right then, each point one by one! The database is for use in a consultation scenario. Therefore, there are approx 20 different outcomes for any one consultation. Within that, any can be selected dependent upon what the consultation finds. By adding in the "active" check box...

Hi! This may be a tough one. My knowledge is not sufficient enough to achieve it! I have a Form linked to a Table. On this form I have several groups of fields seperated by tabs following the format: GroupA_active (yes/no) GroupA_notes (text) GroupA_actions (text) then on the next tab...