Just a quick thought:
Say the IP Nurse enters a pathogen that is not in the list, will a number be automatically assigned to it? How will the data from that field be recorded.
Given the nature of this field, these Pathogens are likely to change often. I just wanted to make sure that I've accounted for such a possibility.
THANKS!...
davisjr6
Last Activity: Dec 13 '10, 06:43 PM
Joined: May 18 '10
Location:
-
That's true. I just created the ID field (AutoNumber) and it worked like a dream.
Thanks again!...Leave a comment:
-
Setting Relationships with queries
Ok, All this is my last question for the day!
Still working as a novice on the hospital infection surveillance database.
I've created two different forms to capture two different types of infections FrmVAP and FrmCLABSI.
The problem is that I had to edit the tables related to the form and the form would no longer work.
So, I created two different query with all the needed fields to use... -
Perfect! It works now!!!
Thanks a mil to you both (NeoPa and Pat)!!!Leave a comment:
-
Friends,
Sorry, but I'm having troubles executing the Auto Number suggestion.
I imported the Pathogen List to TblPaths from excel and then created a RecordID (Auto Number). However, when I input the pathogen into the form, the field in the table reads the entire path name.
I typed column widths 0";2" initially, but was unable to read my path list from the drop down box in the form, so switched it...Leave a comment:
-
Thanks Pat!
In the interim I asked the question, I figured out how to put to use your advice and it's working minus the ID field.
Question for you: The information we will be storing concerning pathogens is intended to be exported to a CDC reporting database, where the actual pathogen name is used. Should I go ahead as you suggested and create an ID field. If so, what do you mean by ID a number or abbreviation (e.g, Adenovirus=ADV) ?...Leave a comment:
-
How to build a combo box with 1300+ options?
Hi All!
I'm a returning novice working on building a database to house Hospital Acquired Infections. I'm seeking advice on how to build a combo box with a list of over 1,300 pathogens. There are three fields on a form requesting Pathogen identification and as it stands I have 1,300 + pathogens to chose from. Is a combo box an appropriate way to do this? I have the pathogens in an excel spread sheet and in a word document.
... -
Thanks (screams), ADezii!!! You're response made things much more clear!!!Leave a comment:
-
Thanks so much for taking time to investigate further! Very helpful!!! I agree some form of redesign should be pursued; however, I'm at a loss as in what direction.
Essentially, each patient will have the same MRN (unique identifier=Medi cal record number) for every visit, but a different Patient ID number (billing number) for each visit. My problem is trying to figure out how to build tables/forms appropriately factoring in the correct...Leave a comment:
-
Thanks to all, it's now working!Leave a comment:
-
Form fields will not display in Form View
I recently converted an Access database built in Access 2000 to the Access 2007 format. Upon doing so, I created a new form that used a table from the old database plus two new tables created in Access 2007 in a blank form design. The form displays in Design view, but does not display in either Layout view or Form view. -
Missingling is right on. Did he clear up your question? Thanks again for looking into this for me....Leave a comment:
-
Thanks, friend!Leave a comment:
-
P.S. The main form is VAP....Leave a comment:
-
LinkMasterField s property setting has produced this error
Here you go! Thanks!!!!...Leave a comment:
-
Sure, I'll upload the dummy database. Just need to figure out where and how. Access 2003.
Note: The system will not let me upload the database. Let me see what else I can do....Leave a comment:
-
LinkMasterFields property setting has produced this error
I'm attempting to build an Access database to house hospital infection surveillance information.
Upon completing the database, I decided I needed a search function in the main form (complete with 2 subforms) to assist nurses in quickly finding a patient to monitor concurrently.
I tried two different things:
1) creating a search filter in the main form with a filter and clear filter button ),
...
No activity results to display
Leave a comment: