Search results

Tried using that code but I'm getting a Run-time 449: argument not optional. I don't know if this effects anything, but I have KeyPreview on for both forms. The code doesn't work at all in the main form when KeyPreview is set to No. Also, I don't really understand the whole module piece of this...

Hello, I have a form that displays records from a query. I've utilized the following code to allow users to navigate forward and back in records by using the left and right arrow keys on their keyboard: Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) On Error GoTo ErrHandler...

I have a command button set to navigate to the next record (Docmd.gotorecord etc..) but then I want to focus on a textbox that's in a subform so the user can begin typing after clicking the command button without having to then click on the textbox. I have...

The form is continuous and the dlookup is the control source but the dlookup is not the field that needs to be edited. It's another field

Query1, which contains the "Suggested Decision" IIF statement, required the use of a LEFT JOIN, which disables editing any records. How would you suggest I go about being able to edit these records while still utilizing this "Suggested Decision" value? Here's the SQL of Query1: SELECT...

Background: I'm creating a clinical decision support tool in which a Query will provide doctors with a suggested decision for a patient's prescribed drug based on whether the patient's medical condition falls under the domain of the drug. I.e., if a patient is taking an anti-depressant and any...

I'm getting some errors using D-lookup. Here's my syntax: =Dlookup("[Suggestion]", "Output", "[Auth NBR]='" & [Auth NBR] & "'") When I run the query, the program totally freezes up and takes the query really long to run. There's only ~530 entries.

That's unfortunate... How do you suggest I pull in the suggestion from from the query (which is based on the patientprescription table) and the provider decision field (also in the patientprescription table) into one form so the provider can see the suggestion and also update the decision...

Hi Plog, thank you again for helping me out in this matter! I've almost completed the database. :) One problem, the Output query is not allowing me to update any records. Essentially, the provider needs to go through the query, look at the suggestion, and update a separate column with their...

I believe this worked!! Thank you so much! I may have some questions when I try to pick apart your SQL if you don't mind.

Hello, what if I want to display the actual query? A list box doesn't allow the user to edit/add records

I want both cert and drug class code to show up. The output is essentially arow for each patient-drug code combo. In the output, there's also a column that lists all of the patient's certs (concatenated). Finally, an column with either Accepted or Denied depending on whether the patient's...

To walk you through the file...The output sheet pulls each patient's prescription from the "Patient Prescriptions" sheet (table), then pulls the patient's corresponding cert from "Patient Certs". It then references the patient's drug code and cert combo with the "Drug-Cert Crosswalk" sheet to...

Here you go! See attached

I need to know whether a patient has the right cert for the prescription that they're on based on the drug-cert crosswalk. E.g., Patient 1 is on a prescription with Drug Code 1 and Cert A. The crosswalk says that in order for a patient to be on Drug Code 1, they must have Certs B, C, or D...

Right...relational database rookie mistake. Thank you! Where would you go from there?

Surely! Please see the attached file

I'm creating a clinical decision support tool for our clinic with access. Without getting into too much detail, our clinic is required to review all medications that we prescribe to patients to make sure the patient has the correct certification to receive that med. Each certification allows for...

Okay, I've literally copied the coding from the file you attached in here and now for some reason in my database the sub-forms are showing up blank..

Also, I was at no point complaining for the record. Clarifying what I was looking for. Thanks again for the help.