Search results

apart of the tbl_symptoms i'm going to have a table for each symptom to ask more about that particular symptom. and i can't include all in one table. e.g. tbl_symptoms ICDID ICDNumber ICDDescription 7082 786.02 Orthopnea 7084 786.1 Stridor 7085 786.2...

Thank you Professor for the post, I really enjoyed reading it :) I realized that I didn’t give attention to the tblvisit being the one involved in all the rest, and thanks a million for pointing this out. And some of course as you mentioned related directly to the patient. now back to the part...

Thank you sir for your reply. i can't question your experience in this field ;) so i thought of another way to sort these in the subforms view. basically in the combobox in the main form, i'll be recording Patient's symptoms chronologically. so the use of "date field" will be tied to the...

hello, can someone help into translating the attached form into tables. is it better to go with 1 table or 2? as each cutomer from the tbl_customer can buy 1 or more items and each item "when checked" can have different questions from 1 to 6 questions. your help is greatly appreciated. thanks

Wow Chris you are my hero :) very nice demo. if i may ask how can you add the link criteria for the main form. also in choosing from the list box and clicking next. this will bring the forms in sequence but not in Clicking-sequence, for e.g. when you choose the last one then choose the first...

Please Help: table design to manage my patients i am trying to construct tables to manage my patients. tbl_Patients tbl_Symptoms (yes/no) every patient has a set of symptoms given by yes/no in a table. so this is 1 to many relationship. problems i am facing: (1) i would like to make a form...

thanks for the reply Chris i like your idea about having the "Back and Next" and i constructed these forms to help you understand the picture. in here cbo1 and cbo 3 were chosen, so when i click the second tab, i see cbo1 subform waiting for me and when i click next button cbo3 will be next...

Thanks Thank you ChrisO, nice example :) Do you know how can edit this so more than 1 subform can appear. for example: Main Form: cbo1 = 1 cbo2 = 2 cbo3 = 3 cbo4 = 4 ...... = ... cbo50 = 50 and since this is continous form so i'll be adding more than 1 cbo value. so when i choose the...

i have a "main form" which is continous. when i choose data from the dropdown menu in the main form. i would like to call the subform that is related. there are 50 values in the drop down menu linked to 50 subforms. so i think the invisible doesnt work well for appearance purposes. any idea...

:D 30 seconds max. freebie Collectables + used to add my words over the years

nice ones you have there :) ...it would be nicer if you could choose the numbers as well. anyone is going for the words part? i can supply the dictionary if you want. keep your ideas and projects coming please :)

yeah i think this is the best to do for now, thanks for the tip :)

I was thinking to construct a database based on channel 4 "countdown" game show in the UK. click here for more information . by contructing a dictionary database and having a query that can search a word when random letters are given to it. and this could be expanded later on to have 2 or more...

one of my to do list is to have a check box of what to include in a report. i would really appreciate help as well regarding this matter. Cheers :)

thanks for the information Pat, i feel MS Access is closing its doors on me :(

i am trying to add images to a list/combo box where i can choose from, and they can be shown in the DB, is this possible? if so can someone give me pointers. for example i would like to have symbols for the gender instead of "Male" & "Female" and so on. thank you :)

I read the the posts related to genealogy, very informative and nice. however their approach is different than mine. they are tracking the families while i am investigating the genes of a particular patient. what that means is when the patient comes he could have many relatives (1-to-many)...

why do you think it's wrong? :confused:

thank you guys that really helps :)

i am trying to evaluate an activeX control by exporting data from access tables to XML then feeding it to the activeX control. this is all what i know about it. i tried getting more information from the company but they were a little bit conservative sounds like they want me to ask them to do...