Search results

found the problem!!! Data type for DischargeMeds_Date is Text"!!!! Doh!!

still getting data type mismatch error though.

Custom fields is probably the wrong term. In my query I have SELECT tblPatient.Patient_Name, tblEpisode.EpisodeID, tblPatient.Unit_Number, tblPatient.PatientID, tblPatient.DOB, tblPatient.Gender, tblPatient.Postcode, tblPatient.Ethnic_Origin, tblPatient.GP_DR, tblEpisode.Date_Referred...

The origins of the fields are created as thus: ReferralToClinicdate: DateDiff("d",[Date_referred],[Date_seen]) They are custom fields

there are some null values in there and the nz function could help with that. I tried suggested syntax but the same message comes up

I have a query SELECT Avg(qryWaitingTimes.ReferralToClinicdate) AS AvgOfReferralToClinicdate, Avg(qryWaitingTimes.ReferralToTreatment) AS AvgOfReferralToTreatment FROM qryWaitingTimes; But when I run it it comes up with data type mismatch error?

Fixed it!If Me.NameOfControl.Value = DLookup("[NameOfCorrespondingTableField]","NameOfTable","[NameOfCorrespondingTableField] = '" & Me.NameOfControl.Value & "'") ThenCancel = TrueMsgBox "YourMessage"End If

Hi thereThank goodness its Friday eh?I have a form witha field in it that indexed called UnitNumber, allowing no duplicates. I was wondering how to add a validation message telling the user that the 'unit number already exists' etc if they try and enter the same numberNot the best with VBA so...

Works a treat now! thank you kindly

Hi RuralguyI got the sample code from another database. I notice the old database was using CustomerID and that primary key had a text property against it. My EpisodeID is an autonumber.I am it sure how to do what you say as VBA is my acheilles heel

Run time Error 2001 you cancelled previous operation Hi thereI am getting an error message 'error 2001 cancelled previous operation'It happens when I click an item in a list boxHer eis the codePrivate Sub LstCustomer_Click()Me.RecordSource = "SELECT * FROM tblPatient " & _...

I was womdering - how cold I replicate this but have it so that when you choose an item from the list box, another form opens? (the form fields are not on the same screen)

trying this at form level

I have tried [startdate] Is Not Null but it made no difference

I have set up a a validation rules for a text box - 'Is Not Null' and a validation text "please enter date"Howvever when I test it the resulting message is "The Microsoft jet engine does not recognise "as a valid field name or expression"

Think I have itWHERE SomeColumn NOT LIKE "XXX*" AND SomeColumn NOT LIKE "YYY*"

Hi thereI am trying to filter out some rows in a query usign the Not Like functionI have Not Like "2. Too late"but when I add OR "1. Ineligible ECG" it still shows up those rows?

I think I have a solution.. use the unmatched query?

I have three tablestblPatienttblMINAPtblBCISI have set up an indeterminate relationship between tblPatient and tblMINAP using NHSNumber, and done the same with tblBCIS.My problem is thistblMINAP is a complete dataset for the financial 2010/11tblBCIS only has April 2010 to January 2010.How do I...

So far my test has involvedsetting up a cross tab query that counts the number of episodes per day (this was quite long as there are 274 episodes occuring on 191 days)