General :: Tracking Patients Medical Tests Then Alerts When It Is Overdue
Apr 8, 2015
I have been asked to create a access data base (using 2007) on tracking patients medical tests that then alerts you when it is overdue set against a scale:
Physical Test - age 20-39 - every 3 years - Male and Female
Physical Test - age 40-49 - every 2 years - Male and Female
Physical Test - age 50+ - every 1 years - Male and Female
PAP Test - 20+ - every 3 years - Female
There is about 10 of these tests like this and then tests specifically for Cancer type patients.
I figured out one way by creating a table with each column being a test but this didn't really work as I need to keep a record of each time they come in and the test is done and then it spits out the next reoccurring test from that date.
I then will need to make a report created from this that alerts on everybody who is overdue to not gotten any of the tests by category.
I then thought okay I will create a table that has the fields as ready something that this is better and to append the records to another form:
Illness - Pulling from tables of Illness
Test - Pulling from table of Tests
AgeGrp - multi-field, referenced from Table of Patients
Gender - Multi-field, pulling from the Table of Patients
Frequency - pulling from table of frequencies with amount of days to calculate
I did this and now I can't figure out anything past this point and how to link all this data up so the right information pops out.
Syntax for finding a change /update in a table. I want to add a data macro to my table "After update" , to send email to group as soon as a new DB entry is made in the table...
just building my first database. Eventually I want to make it open to others/make changes as new research is done. Can I add change-tracking etc. later (perhaps once I know ANYTHING about code etc.). Basically - can I worry about that later, or--like structure etc.--does it have to be set up before I can enter any data to begin with?
(for the initial part in which I am the only one using the db I was planning on just having it stamp the date of the original entry)
Our office needs a way to track reports that are due to us, so I'm trying to build an Access database to do that. What happens is this...
We put out a weekly tasking document (called an AFCTO) every Friday that tasks our outside agencies (units) to do various things. Each task in the AFCTO directs a single unit to do a specific thing. Units may be tasked multiple times in the AFCTO (one-to-many relationship), but each task only applies to one unit.
Some tasks require the units to send us reports on the status of that task, while other tasks don't. The reports that are due can occur at different frequencies. For instance, some tasks require our units to send us reports weekly on Thursdays; other tasks may require reports to be sent to us monthly on the 1st; other tasks may require daily reporting.
Now, with all that said, we need a way to see what's due to us each day. What I would like is a report that displays what's due for this week, similar to this:
So far I have a very rough mockup of what the form should look like (fmAFCTOTasks in the attached db):
The user can type in the AFCTO Task Number of the task, the start and end datetime group, the unit assigned to that task, the task desc, what type of report is due, what triggers the report, and the frequency at which the report is due. Reports can have one of two triggers...
1) event driven (something happens that requires a report to be due), or 2) date driven (report is due on certain date or day(s)).
Obviously if a report is event-driven, then there will be no frequency or date/day associated with it. How to structure the tables and the form.
how to build a construction submittal tracking database.. im doing all this in excel but i find it very hard to trace the data that i need.. i have a form where all the data is inputed.
I'm trying to design a report which lists jobs that are overdue. I've got a field called [ExpectedCompletionDate] and a field called [Status]. The Status field is polulated by a combo box, which has the following options
Started In Progress Complete
My issue is that i'd like the report to list all the jobs which have exceeded the expected completion date and whose status is not listed as 'Complete'.I'm using the following code in the underlying query
Overdue: IIf([ExpectedCompletionDate]<Date(),IIf([Status] Is Not "Complete","Overdue"))
I have a call log database that is used to log calls (Obviously), i have several users over a network and everything works great, but i have been asked to create an alert function that notifies the user when a new call is logged assigned to them by a different user, similar to outlook when a new email is received.
I was planning on having a timer even which checks for new calls every few mins or so and opens up a form to display the new calls which have not been dealt with i thought it was gonna be simple but i have come across a few problems.
1. verifying if a new call has been logged 2. displaying only new calls 3. only displaying alert once per new call
I have attached the database but have had to remove all information from the tables for security reasons.
I am looking to create something called a "transactional" database that tracks historical information.I want to track and keep a record of employees at my organization who have had disciplinary action. We currently have a 5 step approach leading to termination.Eg. Step 1: receive Letter #1 Step 2: receive letter #2 + manager meeting step 3: receive letter 3 + manager and director meeting, etc etc.
I believe this is transactional because for each employee, we would need to see when they received the letter in the past, and an employee may receive two or three "step 1 letter 1" notices due to whatever circumstance.I stumbled upon this database and I found the bottom part where you Add/Edit Employee is what I am looking to do...except I can't Design view or anything to see how all this cool stuff is done! The link is: access-programmers.co.uk/forums/showthread.php?t=154187
Essentially, I want to create a user friendly database like the link above where a clerk/admin assistant can open Access, search for an employee by name or department or manager, and then be prompted to add information such as Letter #2 delivered, manager meeting occured, employee signature, etc.
I am trying to track a yearly training in Access 2010 but am not quite sure how to accomplish it. The training originally was just a one-time thing, due within two weeks of a new hire's start date so I currently have it displayed as three fields in my employee table (Due Date [Calculated], Completed [Date/Time], Paid [Yes/No]). Now, employees will be required to complete this training every year (beginning January 1st, not from employee's start date) and I don't know how to accomplish the tracking it.
I need to keep each year's completion date and whether or not the employee was paid. Currently, the "Paid" field is linked to a query that populates a list of employees that have not completed the training. If the "Paid" Yes/No box is unchecked, the employee's name will be listed in the query; once I check the Yes/No box then the employee's name is removed.
What would be the easiest way to track this training for each year? There are several other training that I am tracking but are one-time only events; these too are separate fields in my Employee table.
I have been tasked at my work to create a database for tracking time off from work. I have built several databases in Access 2003 and have now transitioned to 2010 and it is seems to be going well. My past databases have been rather simple data in data out not really that big of a deal. However on this database they need a report that will show them a week view that shows them all the employees regular days off and any additional time off they have schedule in that week.
I have an employee info table that has employee basic info, Emp name, Emp number, Work Week code (which identifies which days off the employee has) Hire Dates (for seniority sorting) and then I have 7 fields listed as D1, D2, D3 and so on until D7 (I will try to explain these fields later).
I have another table (Time Requests) that has 3 fields, Date, Emp number, and Time code (which identifies why they are off work or unavailable to be assigned).
The last table I will refer to has 7 fields, they are Date1, Date 2 – Date7
I now have a form. This form has the 7, fields Date1, Date2 – Date7.
On my form Date1 field is updated by a manager with a date that is a Sunday then Date2 = [Date1]+1, Date3 = [Date1]+2 and so on until I have all 7 fields showing date from Sunday – Saturday.
These fields are lined across the top in a vertical direction positioned above a subform of the employee info table. So directly below the 7 Date fields are the D1, D2, D3, D4, D5, D6, D7 fields then to the right is the Emp name and Emp number, This gives me a Week view of who is working.
I have been able to get the D1, D2….. fields to show their respective Work Week codes by writing very simple “If Then” statements . So here is where I AM STUCK…When I am showing this week view how do I get D1 –D7 to identify what date they are supposed to be in reference to Date1 – Date7 then compare themselves to the table “Time Requests” to see if they have a match and then set the value of D1, D2 …. to the “Time code” in that table. D1 – D7 need to auto populate and do this for about 50 employees.
Here is a screen shot of what I have so far and where I am stuck: [URL] ....
I am planning my new DB and am contemplating the best design. It will be used for warehouse stock rotation and control of pallets. I want to track each pallet (product/time in/time out etc) to each pallet space within the warehouse. There are a total of 400 pallet spaces or 'locations' as i will refer to them as.
Now, would it be possible for me to have a table set up for each location? Will access object to having 400 tables in my data base?? Is there a limit?
Few months ago, I saw a database about Physicians and Patients, with Skeleton Image on the Switchboard in this site, but now I cant find it, if any one knows its address plz post here, Shall be appreciated.
I have a continuous form, that displays in the body the results of a number of selections from a previous form.
In the header I have a message that I want to either shown or hide depending on the result of the following code in the "On Current event;
Private Sub Form_Current()
If Text29.Value = 0 Then Label32.Visible = False
End If
End Sub
The default form Label32 is for it to be visible. Text29 is unbound and derives it's value from "=Min([WareHouseID])-Max([warehouseid])" no problem there.
The problem is that test does not perform as I expect it to. I have tried all sort of combinations and permutations but can not get it to respond correctly. It seems to think that Text29.Value is equal to zero regardless of the result it is showing
I'm guessing that there is something about continuous forms I have not yet learned :(
I have visitors who come in from one to several days at a time through different times of the year. Usually someone visits each day. Currently I use Excel to track visitors but I often keep typing and retyping the same persons over and over.
I would like to create a database of these people but I'm stuck with how to enter and retrieve the information on a daily basis. Should I create a table with many date fields (up to several); or just two; one FROM and one TO and try to draw the information out through a query? If so, how would one ask ACCESS with a query to PRINT TODAYS LIST and another VIEW TODAYS LIST (of visitors) with a button on a form (I know how to create buttons).
I am a doctor with a knoledge of computer greater than most of doctor. Even though i use a company for part of my office managment, i would like to develop a small database as a project, that can save my patient charts and i though that microsft access should work for this (please correct me if i am wrong, and also let me clarify that i have not use access),
This is what i want, when i dictate a patient chart i do it on a word document template, if i take pictures i save them as jpeg in zoombrowser, and other material is safe as pdf in paperport. Would it be possible to develop a database that will combine this on for example a record called Peter smith # 1234, and when i find this patient, it will have folders like chart, photos, bills, etc
"New" patients are patients that weren't present the prior day. I'm needing a query to show how many patients were NEW on each day [each patient listed once for each service date]. Also, some patients will have multiple visits.
Pt Name & Date/MAINAuto IDpt namedate,1smith1/1/20122smith1/2/20123smith1/3/20124jones1/3/20125jones1/4/20126jones1/5/20127garza1/2/20128garza1/3/20129garza1/4/201210garza1/5/201211smith2/2/201212smith2/3/201213smith2/4/201214smith4/16/201215smith4/17/2012
In my current, new position, I have been asked to look into the possibility of finding out if there exists some good tests available to test how much skill someone has with Access.
Do you know of any existing tests or websites that do testing like that? If not, I may have to create one for us, but I didn't want to have to totally reinvent things if something good already exists.
Also, if something doesn't already exist, maybe we could get some people here to contribute to a thread with potential questions to ask.
I have a data entry form with several values that could be calculated and entered if I knew how. The FAA requires logging and tracking values that result in the following fields: TimeSEL TimeXC TimeNight TimeDay TimeDual TimePIC TimeTotalFlight
My last flight resulted in entering 3.4, 3.4, 0, 3.4, 0, 3.4, 3.4
My question is: is it possible to add some sort of test expression in the TimeXC field which would examine an associated check box (i.e. "Was flight XC?") and if it was checked then would automatically calculate the flight hours (TachStop-TachStart) and enter the value in the TimeXC field?
Some of the calculations I would like to do are based on the number of new patients that a certain clinic received in the previous month. Does anyone have any suggestions on how I can create a field that has the number of new patients from the previous month?
What I can't figure out is how to account for the fact that I have multiple clinics in the [Clinic] field and each clinic has multiple years in which it was receiving new patients. The PrevMonth statement above works fine for the first clinic listed in the query during the first year it received patients (entries are sorted by month and year), but then just repeats these data for each subsequent year and clinic. Any ideas?
I have a form call "frmemployee" that holds employee's details. I have page tabs with sub forms on and the one I'm now concentrating on now at the moment is a Sub form called "medical Sub form" this holds data regarding the last medical the employee has had on continuous form e.g. MedicalDate ,Doctor , Place
now what I'm trying to do is find last medical date for the employee selected and add +730 days to show next medical date in text box on the footer of the subform
I have a sample with bubble speech show what I'm try to do
I am just wondering if theres a way I can create a customise database for my workplace. We are looking at replacing the old record cards that sit on the desk that records each clients visit and the price they paid. We do use MYOB for all our accounting etc but we are wondering if there is a way that we can create a database that enables us to record the date and price paid for each visit for every individual client?
I work at a small mental health clinic and am trying to accomplish the following.
What I have:I have one table that lists all of the patients, their phone number, address, etc.
In another table, it lists the medications that each patient takes, as well as the strength, dosage, etc.
The two tables have a relationship via the "Patient ID" column in each table.
Most patients have multiple entries in the second table, as most patients take multiple medications.
What I am attempting to accomplish:The main form in my database simply lists all the patients names in datasheet view. I want to be able to click a Patient's name, then go to a form that lists all of that patients medications. I've attached a screenshot that encapsulates precisely what I am looking to accomplish.
Since most patients take multiple medications, I need to be able to list multiple records in a single form, grouped by medication name, just like in the attached image.
I am uncertain as to how to accomplish this. I've tried using subforms but it doesn't list the data at all? Also, it looks like an Access report can create precisely what I need, but I need to have a live form that I can use to update data real-time.
I have been writing a database for a medical facility. Currently, I have a box to check if a patient in the database is admitted. What I would like to do is create two radio buttons: one to admit and one to discharge.
When the patient is discharged, I want the data in some of the fields on the form(s) to clear, but not all the fields.
I realize the I will need some scripting here.
As an example: the fields for Unit and Room number will clear upon discharge. As well as fields for diagnosis and informed consent signature located on another form within the same table.