Search results

bump. Any ideas?

I have a database for my staff to enter data into via a data access page. It works on all windows xp os computers. We do have staff working on Windows 2000 os computers and it is not working appropriately. The database was created in Access 2003. When the user pulls up the page, none of the...

i have the same question. did you ever find a way? jason

Hello. I built a database for work that lists high risk medications. It includes the name of the med, special monitoring parameters, warnings, and links to various policies. I created a form with a search function that works perfectly. I have a list box that contains all of the meds. In a...

never mind, I figured it out. Thanks

Hey Guys, I have a DB with a 4 tbls: MedRecAudit; Physicians; Unit; PracticeName I have a query that finds only physicians from a particular practice and whether they filled out a particular order. One portion of the query is AuditDate. I use a between statement to limit the dates. I then...

Does anybody have any suggestions? thanks, Jason

I created a database to track tardies and absences of my employees. I would like to be able to sum the number of absences and tardies for each person per month and graph it. Per our attendance policy, 6 tardies = 1 absence. I need to take the total number of tardies that month/6 and add to...

Pat, Thanks for the info. I'm still not getting the result I would like. I need to run a query that will look at the most recent 6 month period and sum the total number of tardies and absences separately. I then need to take the number of tardies and divide by 6 and that value will be added...

I would like to build a database to keep track of tardies and absences in my dept (~70 employees). I need Date, Name, tardy or absent, My current table: TblEmployees EmployeeID PK Last Name First Name Team TblEvent EventID PK Event (Tardy or absent) TblAttendance Date EmployeeID EventID Is...

Scott, I done the things that you recommended. Everything seems to be working fine except for my subform. I set the main form and the subform to data entry and allow additions to "YES". Everytime I open the main form, the subform is blank and the properties shows the subform to be set to...

That worked perfectly!! Thanks Bryan. Jason

I'm trying to run a query that will show when something is due within the next 90 days. I keep track of employees competencies that they complete. I want to run a query that will only show me when the field [Renewal Date] is within 90 days of the current date the query is run. How can I do...

The "EducationID = 4" statement is referencing the combo box. EducationID is the name of the combo box as well as the other objects in the code. Do I need to reference the tables the values are in? EducationID is in one table while the incubation information is in another?

I am creating a data entry form with combo boxes related to two different tables: TblEducationID EducationID - Auto# PK Education - Text TblMediaFill MediaFillID - auto# PK Incubation Time- text Incubation Temp - text In my form, I have a combo box that the user selects the Education Type...

I need some help setting up my tables to allow cascading combo boxes. I need to document when a Pharmacy IV room and chemotherapy room are cleaned. Each Room requires different cleaning procedures. Here is my table structure: TblCleaningDuties DutyID-Auto# (PK) Duty - text (Example- mop...

Thanks for your help Scott. I'm a novice at Access. What would my relationships look like? I made the tables and linked at InspectionTypeID, Results ID and Inspection ID, and another table I named units. Everytime I select an Inspection type, it defaults all of the entries to that one...

I'm sure this is difficult to answer via a forum, but; What would be the best way to create the table to allow me to run the reports easier? Jason

I have a table that documents the result of unit inspections. The data is Date inspected (once/month), Unit, and about 12 yes/no fields. I want to run a query that shows the percentage compliant (yes) of all of the categories per month. I also want to be able to graph the results for one year...