Search results

Hey thanks for your help, im using the following code for a textbox called "PatientID" and it works fine, just wondering if i could add another textbox to the if statement for example "IF PatientID or Surname etc is equal to 0 then error message" If Len(Nz(Me!PatientID, "")) = 0 Then...

I have a form that has various fields with the field property required set to yes, i want to add validation that validates if a required field is equal to null for example If IsNull(.Required) then MsgBox "Required fields incomplete" End If I want one msg to check all the fields set to...

Hey thanks for the reply, im looking validation to add to an add command button that checks if the user has entered for example a person forename. Im new to the vb side of things and im looking for a basic example of textbox validation.

Im looking to add some validation to textboxs within a form ie if a textbox is empty/has not been completed output an error message. Can anyone provide me with an example of validation for this?

Hey, yeah i want to cancel/disable the update event

I want to disable the close form from saving/updating records in my database table when i close the form, i have tried setting the "Add Additions" setting in the form properties to "No" but it doesnt same to work, can anyone help?

Hey David thanks for that, ur code sames alot easier to use :), i have a slight problem, when i select the add command to add the record to the admission table the record adds fine but when i close the form it adds another row in the table with the HopitalName and WardName empty and the Question...

I have tried the following code but i know the syntax is incorrect: Private Sub btnSaveToAdmissions_Click() Dim rs As DAO.Recordset Dim qDef As DAO.QueryDef Set qDef = CurrentDb.CreateQueryDef("") qDef.SQL = "INSERT INTO Admission (WardName, HospitalName, Question) VALUES (@WardName...

I have an insert statement inside i command button ("Add") on a form and the code at present adds the values from two combo boxes populated from two tables (Hospital and Ward). The insert statement inserts the values into a table called "Admission", at the minute the combo box values for the...

Jal how do i add a textbox value to the admission table, can i just add another field name to the insert statement? for example if i was to create another field called "Test" in the admissions table and then create a textbox assigned to the "Test" field in the form and be able to add this value...

Jal im just using this as a test form, im planning to add the functionality to another much larger form. I have got a solution to the databinding problem :) thanks jal.

jal i just noticed on the form that when i go through the records on the table using the form the hospital name and ward details do not change for each record, it just stays the same for each, is there anyway i can amend this?

jal thankyou so much for that, i really appreciate your help :)

Thanks for your help, i am inserting values from two combo boxs with the following names for each: "Hospital" "Ward" I want to insert values selected from these into a table called "admission" in the fields "HospitalName" and "WardName". Heres is a copy of my test database with a test...

Hey thanks for that, all i need to do is create a button to adds the values of the populated combo boxes to another table. I have two tables created, one that lists names of hospitals and the other that lists the name of wards. I have created a relationship between the two tables so that i can...

Hey thanks for that, i created two tables (Hospital and Ward) with a relationship and then created the form with the combo boxs, it works very well :). Just wondering how i add the values selected in the combo boxes to another table uses the command button with the add function?

Hey thanks for your help, can you provide anymore info on the append query and how i would go about creating it?

I have created two combo boxs which are populated by value from two tables and i want to add a command button to be able to add these records to another table, can anyone help?

Im have a table called "patients" and i have two fields within this table called "hospital" and "wards", i want to have a value list for each of these fields but i want when a user enters a hospital that the value list in the "wards" field changes to list all the wards within the particular...

I am working on a project atm that uses 3 tables with relationships between them. The tables are as follows: Patientdetails tbl: #PatientID (text field) input by user. forename surname address etc. age date etc Admission tbl: #EpisodeID (autonumber) PatientID (text field) unit hospital...