Search results

I am using the Northwind Database example. I have a Product table with a product called Injection1, Injection2, etc In my order form i have a subform called sbforderdetails and another called sbfvitals. in the order details form there is a dropdown combo that has all the products . In the...

The control in the vitals form are PatientID and Dependents. The vital form opens with the dependents name but not with the PatientID.

Thank you Sir. Works like a charm I have the subforms History query and PatientHistory in a form Called PatientDetails. Both subforms are open when you open PatientDetails. Now if you doubleclick the control ID on HistoryQuery it suppose to change the record OF PatientHistory . it works with...

It works fine . Thank you very much. It does open the vitals form with the Dependents name. How can i also includw the PatientID and all recxords.

Sorry copy of medicalaid -listings.Click on that and that opens the tab forms with subforms

Hi . Here is an attachment

oKAY. So what I rally want is this. 1. Patients table with patients name. Patients nedical iad and dependents.and patientid(utonumber) 2.In vitals form have a field called dependents. and patientid. 3.in examination form have a field dependent and patiendid Open patients form. select the...

You are right . Thr dependents are wife and kids that are dependents on a main member medical aid. AT the moment it is not what we actually wanted. Basically I wanted in the main sheet a list with all the paitents. When you double click on it it should open another form with all that patients...

Me.Vitals.Form.txtDependents.RowSource = "SELECT Dependents FROM Dependents WHERE PatientID=" & Me.PatientID It works like a bomb. Thank you so much. You are right i will change the field name. Sir, can this work; In Patients form , I want to doubleclick on the subforn Dependents PatientID...

I get an error doing that. object does not support this property or method Private Sub Form_Open(Cancel As Integer) Me.Vitals.Form.txtDependents.RecordSource = "SELECT PatientName FROM Dependents WHERE PatientID=" & Me.PatientID End Sub The combo box is a field in my Vitals table and also a...

Thank you , I will try and confirm if ok. Really appreciate the help.

No sir, I am busy with a request for a surgery. Basically I have three tables. The first table being the Patients. with a primary key PatientID and the other names , last names.etc. Then i have a Dependents table with fields for all the dependents for medical aid for a patient using PatientID...

In my Patients table i have a field called PatientID (AUTONUMBER) as my primary key I hve another problem. Is this possible as i hve been trying for two days now. I hve tried a lot of ways but i cant get it to work right. I have a table called dependents. ID , PatientID,,Dependents,DOB,Age id...

Sorted 00"%RA"99;0;-

I have a field in my table called SATS. This is then on my form as a control bound to the SATS field in my table. The application is for a surgery where the person doing vitals ( blood test and HPpressure testing) need to enter the redings. The norm is 96%RA80 tHE 96 never goes beyond 100...

Thank you all for the help. This is what i eventually did and it works. There is a warning that is displayed on the top: Certain contents in the databse has been disabled. option enable. Once enabled it works perfectly. My apologies to all. Is there a way to to get rid of that message. cos...

Hallo Sir I am trying to open the test.zip file . It says that it has unrecognizable database format. I use access 2007 Basically my client wants to scan his documents and allocate an account no to it and in his access form he needs to call it up for each patient.

Thank you and my apologies for the late response. Will give it a try and confirm .

Hallo This has nothing todo with this topic. I just want to know if you have solved the incremnt issue using dmax.

This is what i have at the moment but it still does not increment Private Sub GenerateCode_Click() Me.Increment = Nz(DMax("[Increment]", "Contacts", "Left([LastName],3)='" & Left(Me.LastName, 3) & "'"), 0) + 1 End Sub I have a hidden control on my form named Increment bound to the...