Search results

Hi Guys, I have a form that on completion needs to ask the user a couple of questions to determine where the process goes. I am getting a bit confused with how to write the responses and hopefully someone can guide me in the right direction. The code I have at the moment is as below...

Hi Paul - just to let you know I have worked it out I only needed to sum the 'VaccineCost' thanks anyway

Hi Paul - thanks for the quick reply The control Source is 'Total' (as below) Total: [VaccineProducts]![VaccineCost] and its in the Report Footer thanks again for any help you can offer

Hi Guys For the life of me I can not work out why I can't get a report to add all the products on it. On a test report I have 4 products with values of 50,60,60,80 but the Subtotal box only shows 50 when it should be 250. Any help or advice would really be appricated !! many thanks

Many thanks for such a quick reply Bob - Works perfectly now ! thanks again Paul

Hi guys could someone tell me if it is possbile to requery a listbox on a main form, from the afterupdate event of a Subform? I have a form called 'Vaccination' with a listbox called 'lstVaccinations' On the mainform is the subform called 'VaccinationConsumablesSubform' the last control on...

Thanks Paul

Hi guys Is it possible to restrict a certain value in a combo box through code? E.G I have a table called tblNames one of the values in this is table is 'Not known' This table is referenced on various forms but on some of them I do not want the user to be able to choose 'Not known' from the...

Ahhh thanks very much Bob I'm glad I posted now rather than just jumping in and changing it all !! thanks again

I have just noticed there is a naming problem with one of my tables. Can I simply re-name the 'field name' and rename the relevant forms / code where this applies or am I walking into trouble doing it this way I would appriciate your advice please Many thanks

Hi Bob thanks for the reply - I was trying to close it on an afterupdate of a control on another form but also tried with a vb msg response ect ect.. Sorry though, I should of posted back but I have gone another way around this now today by adding a cmd button which works fine for this form -...

Hi guys i am tottally lost with this one, so would really appriciate some help please sorry if this is posted in the wrong area but not 100% sure what is causing my problem! I have a navigation form with a few command buttons one of which opens another form called "FindPatientTreatment". the...

Thanks Paul - and yes it was Pub time and now it suffering time !! thanks again for all your help !

Hi Paul many thanks for the repllies and advice. I came back to it this morning and after a bit of tweaking I now have the code working as below Private Sub txtSearchItem_Change() On Error GoTo Err_txtProperty_Change Dim strSource As String strSource = "SELECT PatientID, PatientFirstName...

Hi guys - hopefully someone can point me in the right direction as to why this is not working please? I have a table called PatientDetails I have a form called SearchPatient In my form I have a textbox called txtName and A listbox called lstSearchResults The rowource for the listbox is...

Hi Paul thanks for the reply - I have researched your suggestions and will do a new post on this as it has changed somewhat the code I have now is Private Sub txtName_Change() On Error GoTo Err_txtName_Change Dim strSource As String strSource = "SELECT PatientFirstName, PatientSurname...

Thanks for the reply Paul - I know a bit of what you mean but could you please just clarify in more basic terms? Firstly you say use the change event of the text box - is that a typo as I don't have a text box only a cbo and list box on the form or am i missing something here? Wiih regard to...

Hi guys, could someone tell me if it possible to do the following please (also if it is practable!) I have a form with a combo box called cboFindPatient and a listbox called lstpatients. What I would like to happen is as the user types a letter in the combo any patient whose name begins with...

Many thanks Jr - I thought as much just hoping there was an easier fix ! Thanks again