Search results

Hi, I attach my DB with the tables, I arranged the tables in the relationship window, and would like to connect them as follows: tbl_ system (Parent) -tbl_LookAt1 (child) --tbl_LookAt2 (grandchild) ---tbl_LookAt3 (grand-grandchild) Then each of LookAt1-2-3 has: LookAt1-2-3 (Parent)...

thank you both, i'll try the suggested methods.

thanks for your reply joeselch, is there away to filter the form directly without pulling data from a query for the form. thanks

i have a check box in the main form i would like to show only records with "No" value [not ticked] , what are the different ways to do that? and one more thing, how can i make a quick subform based on the values of the main form, where when i browse thru the main form, the cursor moves to the...

how can i view small calendars of previous, this and next months in the corner of my report? is it possible thanks .

try At Your Survey

can someone help me please, i'm stuck o this for 3 weeks now :(

The_Doc_Man, i think i'll stick with the old design as it is visually easier to manipulate, please let me know if your design add any more advantage. however i'm still stuck with appending queries, to show all questions at the same time with their options.

my query is The error msg i get: I have no idea how to start doing this. please help

uploaded to a US server :p Symptoms.mdb is the old one Symptoms2.mdb with your suggestions thanks :)

Thanks Pat, i tried so hard to look for a way to do this. i get errors appending the questionID to the tbl_answers. also i don't know where to start to make the queries to build the answers for each question. i'd appreciate any online tutorials about this or a brief step by step on how to do...

i managed to view it with dHTML editor control, Me.DHTMLEdit1.DocumentHTML = txtfield buti hope there is another way

like a webpage in a browser in access form/report, i tried MS web browser ActiveX, but no luck with the coding so far. appreciate your help. thanks

thank you Kodo for your reply. What if i want to view the html code found in the memo field? is there anyway to view it like an html file in a form or a report (without stripping the code) thanks

i was wondering if you found a solution for your problem, because i am facing the same problem now. cheers

Thank you for your reply Pat :) (1) changes were made. i was wondering Pat, if it is possible to add a field for OptionGroup2 in addition to OptionGroup where it is not required and i can add text to this field. so the answer to each question becomes OptionGroup and an optional "Other field"...

Thank you Mike375 for your example, but my problem is beyond this stage. Pat, Rich, Mile-O-phile i took this a big step forward and your suggestions in in the attached file. (based on a survey mdb found and edited by Pat in the forums) please let me know if i should continue based on this. or...

thanks for your reply Pat. i guess what Rich was suggesting makes sense now. regarding the tables suggested by Mile: tblSymptoms SymptomID FK? Symptom tblQuestions QuestionID FK? Question tblSymptomsToQuestions VisitID FK SymptomID PK? QuestionID PK? is the SymptomID & QuestionID in...

thank you Mile-O-Phile for your reply. let me get this straight please, shall i use "QuestionID" field as a primary Key in all the invidiual symptom tables [tbl_Orthopnea, tbl_Stridor, tbl_Cough, tbl_Hemoptysis, tbl_AbnormalSputum, tbl_ChestPain, ...etc] and this "QuestionID" will be foreign key...

Rich i appreciate what you are saying, but each symptom has different questions than the other one. and i do this orally as well as i have a form for each symptom ready which is different than the other symptom. for example asking a patient about cough is different than asking a patient about...