Recent content by SHABZO
-
S
ACCESS 2007 Form Input
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... -
S
Selecting fields in a combobox where id matches
The control in the vitals form are PatientID and Dependents. The vital form opens with the dependents name but not with the PatientID. -
S
Selecting fields in a combobox where id matches
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... -
S
Selecting fields in a combobox where id matches
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. -
S
Selecting fields in a combobox where id matches
Sorry copy of medicalaid -listings.Click on that and that opens the tab forms with subforms -
S
Selecting fields in a combobox where id matches
Hi . Here is an attachment -
S
Selecting fields in a combobox where id matches
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... -
S
Selecting fields in a combobox where id matches
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... -
S
Selecting fields in a combobox where id matches
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... -
S
Selecting fields in a combobox where id matches
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... -
S
Selecting fields in a combobox where id matches
Thank you , I will try and confirm if ok. Really appreciate the help. -
S
Selecting fields in a combobox where id matches
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... -
S
Selecting fields in a combobox where id matches
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... -
S
Input Masks for Access 2007
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...